Moving servers. Created a mysql5 database and imported my 3.6.3 database into it.
Copied my old forum files to the new server, then the 3.8.4 files overtop (without install.php)
Ran upgrade.php but was unsuccessful in upgrading from 3.6.3 to 3.8.4 with the 3.6.3 forum intact (but offline). Maybe due to some mods I had installed.
So....
Deleted all files on the new server, cleared the database and imported the database again. Uploaded all 3.8.4 files to the new server and ran upgrade.php.
This time the upgrade completed, but when it finished, trying to log into the forum, I get this error:
(my url changed to xxxxx for this post)
Looking at the database, it does not have the "postid" field in the moderation table.
Help?
Copied my old forum files to the new server, then the 3.8.4 files overtop (without install.php)
Ran upgrade.php but was unsuccessful in upgrading from 3.6.3 to 3.8.4 with the 3.6.3 forum intact (but offline). Maybe due to some mods I had installed.
So....
Deleted all files on the new server, cleared the database and imported the database again. Uploaded all 3.8.4 files to the new server and ran upgrade.php.
This time the upgrade completed, but when it finished, trying to log into the forum, I get this error:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Sunday, October 18th 2009 @ 04:27:18 PM
Error Date : Sunday, October 18th 2009 @ 04:27:18 PM
Script : http://www.xxxxx.com/forum/index.php
Referrer :
IP Address : 173.136.4.63
Username : Andy
Classname : vb_database
MySQL Version : 5.0.81-log
Invalid SQL:
SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Sunday, October 18th 2009 @ 04:27:18 PM
Error Date : Sunday, October 18th 2009 @ 04:27:18 PM
Script : http://www.xxxxx.com/forum/index.php
Referrer :
IP Address : 173.136.4.63
Username : Andy
Classname : vb_database
MySQL Version : 5.0.81-log
Looking at the database, it does not have the "postid" field in the moderation table.
Help?
Comment