2 edb Jul 07, 2006 10:04

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?
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.
Yup. Download the zip for 0.9.2, unzip it, edit conf/config.php and put in your database connection info and baseurl and admin email and set config_is_done to 1, upload it to your server and run the installer. Tell it you're upgrading from b2 and it'll do all the rest.