Fishtails,
Don't mention it. Now that we have found a solution, I would like to suggest that you run one set of queries with phpMySQLAdmin (like Dave suggested) instead of manually doing one by one in turn. This will reduce the time needed for the upgrade. Unfortunately I don't know if users can/will be able to access the forum while the boards are closed. Maybe someone else can shed some light on this.
Run this in phpMySQLAdmin:
code:
ALTER TABLE w3t_addressbook RENAME threadsaddressbook;
ALTER TABLE w3t_banned RENAME threadsbanned;
ALTER TABLE w3t_boards RENAME threadsboards;
ALTER TABLE w3t_category RENAME threadscategory;
ALTER TABLE w3t_favorites RENAME threadsfavorites;
ALTER TABLE w3t_graemlins RENAME threadsgraemlins;
ALTER TABLE w3t_groups RENAME threadsgroups;
ALTER TABLE w3t_last RENAME threadslast;
ALTER TABLE w3t_messages RENAME threadsmessages;
ALTER TABLE w3t_moderators RENAME threadsmoderators;
ALTER TABLE w3t_modnotify RENAME threadsmodnotify;
ALTER TABLE w3t_online RENAME threadsonline;
ALTER TABLE w3t_polldata RENAME threadspolldata;
ALTER TABLE w3t_polls RENAME threadspolls;
ALTER TABLE w3t_posts RENAME threadsposts;
ALTER TABLE w3t_ratings RENAME threadsratings;
ALTER TABLE w3t_subscribe RENAME threadssubscribe;
ALTER TABLE w3t_users RENAME threadsusers;
If you have IIP installed also run:
code:
ALTER TABLE w3t_iipcache RENAME threadsiipcache;
And if you have the Calendar 3.0 hack installed, run:
code:
ALTER TABLE w3t_events RENAME threadsevents;
Also make sure that
before you do anything backup your database!!!!Warm regards
Nikos
