hubbersA small bit of history.
I used auto upgrade to upgrade wp from 2.8.x to 2.9.2 and part way through the process it stopped and now gives me this error when i try to log into the control panel:
You cannot upgrade because WordPress 2.9.2 requires MySQL version 4.1.2 or higher.
There are a few posts on this and the fix seems to be to upgrade the db. I have been in touch with my host to upgrading from mysql version 4.0.24 to 5.0.22.
This seems pretty simple and the steps for this at my host are as follows:
1. Take a backup of the CURRENT 4.0.24 db (the pre upgrade backup is lost in an office move)
2. ftp that file to my desktop
3. create a new blank version 5.0.22 db at host
4. ftp that file to another location on host servers (no idea why)
5. then i restore the backup to the 5.0.22 db
when i do the restore i get this error:
ERROR 1064 (42000) at line 185: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use
near 'default varchar(128) NOT NULL default '0',
active char(1) NOT NULL default '1'' at line 7
If I try to do it again I get this error
*Error - ERROR 1050 (42S01) at line 11: Table 'address_book' already exists
so it looks like the restore starts but fails for some reason.
the offending part of the db backup (e.g. at line 185) is somewhere in this (i think):
CREATE TABLE bb_collect_data_forms (
id bigint(20) unsigned NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
type varchar(64) NOT NULL default '',
mandatory char(1) NOT NULL default '0',
display_log char(1) NOT NULL default '0',
default varchar(128) NOT NULL default '0',
order int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY order (order)
) TYPE=MyISAM;
i am open to suggestions wordpress/mysql gurus :)
thanks to anyone who takes the time to chip in their $0.02.
