Tweet
Database errors upgrade 3.7.2 to 3.8x (trying to get to 4.1.2)
i just purchased the 4.1x Suite to upgrade my vB from 3.7.2
i have never upgraded before and read a lot but i still found it all pretty overwhelming. anyway my end result is not good and i really need some help.
i have tried to upgrade to 3.8 first and it seemed to recommend that.
my PHP was a bit old so i 'upgraded' that first on my host to PHP5.2
then i backed up my main site via PHPadmin (apparently not the best way to do it but i couldn't figure anything else out) and have a sql file.
i disabled my plugins.
then i uploaded the renamed upload folder via ftp overwriting my live site.
[was i meant to do anything else here as this part is not entirely clear to me
even after multiple readings e.g part of the instructions say remove the install file but the next bit says upload ALL the files in the install folder, so this is what i did]
after that my site was still there but i was getting this error [one example anyway] but most were same error number
i noticed that the top of the control panel said i had 3.8 patch level but in the maintenance area it said i was still on version 3.7.2. i tried to upload the folder again in case it missed a few files but had same result.
i also noticed on my host backup this version was a measly few Kb's in comparison to the previous backups.
i then tried to tackle the SSH stuff to restore my sql file which i kept failing at, eventually asking my host to do it, which they said they did, and sent me the email showing me the pathway fro it. however i noticed no difference on the forum. it said the same conflicting version numbers, had missing images, and was still throwing database errors.
i finally worked out the SSH for myself (bad password permission) and tried to load the sql myself resulting in losing my forum altogether!
i am currently waiting on a support ticket again with my host - but would appreciate some guidance for another attempt on the upgrade - hoping my original forum can be restored.
edit: only other thing i noted since was a mention about the mySQL being too old could be an issue. it seems our host doesn't upgrade the sql unless you request it, so i guess its still a quite old version from 2005/6. didn't know this as i thought they auto updated them.
i have never upgraded before and read a lot but i still found it all pretty overwhelming. anyway my end result is not good and i really need some help.
i have tried to upgrade to 3.8 first and it seemed to recommend that.
my PHP was a bit old so i 'upgraded' that first on my host to PHP5.2
then i backed up my main site via PHPadmin (apparently not the best way to do it but i couldn't figure anything else out) and have a sql file.
i disabled my plugins.
then i uploaded the renamed upload folder via ftp overwriting my live site.
[was i meant to do anything else here as this part is not entirely clear to me
even after multiple readings e.g part of the instructions say remove the install file but the next bit says upload ALL the files in the install folder, so this is what i did]after that my site was still there but i was getting this error [one example anyway] but most were same error number
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT * FROM ftwstyle
WHERE (styleid = 0 AND userselect = 1)
OR styleid = 3
ORDER BY styleid ASC;
MySQL Error : Table 'vbdatabase.ftwstyle' doesn't exist
Error Number : 1146
Request Date : Monday, February 21st 2011 @ 05:01:03 AM
Error Date : Monday, February 21st 2011 @ 05:01:04 AM
Script :
Referrer :
IP Address : 67.195.114.34
Username :
Classname : vB_Database
MySQL Version :
Invalid SQL:
SELECT * FROM ftwstyle
WHERE (styleid = 0 AND userselect = 1)
OR styleid = 3
ORDER BY styleid ASC;
MySQL Error : Table 'vbdatabase.ftwstyle' doesn't exist
Error Number : 1146
Request Date : Monday, February 21st 2011 @ 05:01:03 AM
Error Date : Monday, February 21st 2011 @ 05:01:04 AM
Script :
Referrer :
IP Address : 67.195.114.34
Username :
Classname : vB_Database
MySQL Version :
i also noticed on my host backup this version was a measly few Kb's in comparison to the previous backups.
i then tried to tackle the SSH stuff to restore my sql file which i kept failing at, eventually asking my host to do it, which they said they did, and sent me the email showing me the pathway fro it. however i noticed no difference on the forum. it said the same conflicting version numbers, had missing images, and was still throwing database errors.
i finally worked out the SSH for myself (bad password permission) and tried to load the sql myself resulting in losing my forum altogether!
i am currently waiting on a support ticket again with my host - but would appreciate some guidance for another attempt on the upgrade - hoping my original forum can be restored.
edit: only other thing i noted since was a mention about the mySQL being too old could be an issue. it seems our host doesn't upgrade the sql unless you request it, so i guess its still a quite old version from 2005/6. didn't know this as i thought they auto updated them.
Comment