3 Jul 07, 2006 10:10
The conversion choked.
Here's the error:
Installing b2evolution tables and copying existing b2 data MySQL error! Table 'cmwong_Maindatabase.b2settings' doesn't exist(Errno=1146) Your query: SELECT archive_mode, time_difference, AutoBR FROM b2settings
The problem is,
instead of the format "cmwong_Maindatabase.b2settings", my table uses "cmwong_Maintabase.SANb2settings".
How can I edit the upgrading install.php to use this format?
4 Jul 07, 2006 18:20
I hope you have a backup of your database because if the installer got through any of the steps it'll choke when it tries to do the same step again.
In your conf folder find _advanced.php and look for this bit:
/**#@+ * Old b2 tables used exclusively by the upgrade mode of the install script * * You can ignore those if you're not planning to upgrade from an original b2 database. */ $oldtableposts = 'b2posts'; $oldtableusers = 'b2users'; $oldtablesettings = 'b2settings'; $oldtablecategories = 'b2categories'; $oldtablecomments = 'b2comments'; /**#@-*/
Change "b2settings" to "SANb2settings" and you should be good to go. It is possible that other table names won't match what the installer expects. If so repeat the sequence until it all works.