royals
Fri 11th Jan '08, 7:46pm
Upgrading from 3.0.1 to the latest version
I'm at this point: upgrade_360b1.php?step=10
Encountered this error:
atabase error in vBulletin 3.5.5:
Invalid SQL:
ALTER TABLE attachmenttype CHANGE extension extension VARCHAR(20) BINARY NOT NULL DEFAULT '';
MySQL Error : Incorrect key file for table 'attachmenttype'; try to repair it
Error Number : 1034
Date : Friday, January 11th 2008 @ 05:34:57 PM
Script : install/upgrade_360b1.php?step=10 (http://therabblerousers.com/forums/install/upgrade_360b1.php?step=10)
Referrer : /install/upgrade_360b1.php?step=9 (http://therabblerousers.com/forums/install/upgrade_360b1.php?step=9)
Username :
Classname : vB_Database_MySQLi
Right below this:
Step 10) Super Moderator Permission Updates
Super Moderator 'A' updated
Super Moderator 'J' updated
Altering postparsed Table (1 of 8)
Altering postparsed Table (2 of 8)
Altering postparsed Table (3 of 8)
Altering postparsed Table (4 of 8)
Altering postparsed Table (5 of 8)
Altering postparsed Table (6 of 8)
Altering postparsed Table (7 of 8)
Altering postparsed Table (8 of 8)
Altering attachment Table (1 of 1)
Altering attachmenttype Table (1 of 1)
--- I hit refresh (the page directed me to) and now its just hanging out at
install/upgrade_360b1.php?step=10 (http://therabblerousers.com/forums/install/upgrade_360b1.php?step=10)
And if you go to my board there is this error:
Database error in vBulletin 3.5.5:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1200094226
ORDER BY username ASC;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Friday, January 11th 2008 @ 05:45:26 PM
Script : (URL)
Referrer :
IP Address :
Username : (me)
Classname : vB_Database_MySQLi
----------- UPDATE
Now its not hanging anymore - I'm back to the error above
After going back to step 9 at the bottom there is this error and no "proceed":
Altering attachmenttype Table (1 of 1) vB_Database_Alter: fetch_table_info() has not been called successfully.
I'm at this point: upgrade_360b1.php?step=10
Encountered this error:
atabase error in vBulletin 3.5.5:
Invalid SQL:
ALTER TABLE attachmenttype CHANGE extension extension VARCHAR(20) BINARY NOT NULL DEFAULT '';
MySQL Error : Incorrect key file for table 'attachmenttype'; try to repair it
Error Number : 1034
Date : Friday, January 11th 2008 @ 05:34:57 PM
Script : install/upgrade_360b1.php?step=10 (http://therabblerousers.com/forums/install/upgrade_360b1.php?step=10)
Referrer : /install/upgrade_360b1.php?step=9 (http://therabblerousers.com/forums/install/upgrade_360b1.php?step=9)
Username :
Classname : vB_Database_MySQLi
Right below this:
Step 10) Super Moderator Permission Updates
Super Moderator 'A' updated
Super Moderator 'J' updated
Altering postparsed Table (1 of 8)
Altering postparsed Table (2 of 8)
Altering postparsed Table (3 of 8)
Altering postparsed Table (4 of 8)
Altering postparsed Table (5 of 8)
Altering postparsed Table (6 of 8)
Altering postparsed Table (7 of 8)
Altering postparsed Table (8 of 8)
Altering attachment Table (1 of 1)
Altering attachmenttype Table (1 of 1)
--- I hit refresh (the page directed me to) and now its just hanging out at
install/upgrade_360b1.php?step=10 (http://therabblerousers.com/forums/install/upgrade_360b1.php?step=10)
And if you go to my board there is this error:
Database error in vBulletin 3.5.5:
Invalid SQL:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1200094226
ORDER BY username ASC;
MySQL Error : Unknown column 'infractiongroupid' in 'field list'
Error Number : 1054
Date : Friday, January 11th 2008 @ 05:45:26 PM
Script : (URL)
Referrer :
IP Address :
Username : (me)
Classname : vB_Database_MySQLi
----------- UPDATE
Now its not hanging anymore - I'm back to the error above
After going back to step 9 at the bottom there is this error and no "proceed":
Altering attachmenttype Table (1 of 1) vB_Database_Alter: fetch_table_info() has not been called successfully.