diff options
| author | MW <joasch@users.sourceforge.net> | 2007-12-05 11:33:30 +0000 |
|---|---|---|
| committer | MW <joasch@users.sourceforge.net> | 2007-12-05 11:33:30 +0000 |
| commit | 24e002d681812db1171a3174870ff30fe3a6f53f (patch) | |
| tree | 2b2a656a2b7a500993c87638dbbd9b8a8c944ea9 /admin | |
| parent | 3d5c9954524b71e123609f747cc756155aa5343c (diff) | |
| download | blogs-24e002d681812db1171a3174870ff30fe3a6f53f.tar.gz blogs-24e002d681812db1171a3174870ff30fe3a6f53f.tar.bz2 blogs-24e002d681812db1171a3174870ff30fe3a6f53f.zip | |
add missing prefix on R1 to R2 upgrade
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/upgrade_inc.php | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index 696e04c..483ce65 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -42,6 +42,9 @@ array( 'DATADICT' => array( , CONSTRAINT `blogs_posts_map_blog_ref` FOREIGN KEY (`blog_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' ", )), + array( 'CREATESEQUENCE' => array( + 'blogs_blog_id_seq', + )), array( 'RENAMESEQUENCE' => array( "tiki_blog_posts_post_id_seq" => "blog_posts_post_id_seq", )), @@ -80,7 +83,7 @@ error_log( $conId."->".$blogId ); $query2 = "INSERT INTO `'.BIT_DB_PREFIX.'blogs_posts_map` (`post_content_id`,`blog_content_id`,`date_added`) (SELECT blp.`content_id`, blc.`content_id`, bplc.`created` FROM `'.BIT_DB_PREFIX.'blog_posts` blp INNER JOIN `'.BIT_DB_PREFIX.'liberty_content` bplc ON(blp.`content_id`=bplc.`content_id`) INNER JOIN `'.BIT_DB_PREFIX.'blogs` bl ON(blp.`blog_id`=bl.`blog_id`) INNER JOIN `'.BIT_DB_PREFIX.'liberty_content` blc ON(bl.`content_id`=blc.`content_id`))"; $gBitSystem->mDb->query( $query2 ); $query3 = $gBitDb->getOne("SELECT MAX(blog_id) FROM `'.BIT_DB_PREFIX.'blogs`"); - $tempId = $gBitDb->mDb->GenID("blogs_blog_id_seq", $query3); + $tempId = $gBitDb->mDb->GenID("`'.BIT_DB_PREFIX.'blogs_blog_id_seq`", $query3); ' ), // Drop moved columns |