Upgrade gone wrong!!!

[Martin-TMGRS]

After the upgrade to VB3.7 I'm getting a database error. Can someone help me on how to fix this please.

Database error in vBulletin 3.7.0:

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 : Wednesday, April 30th 2008 @ 11:35:39 AM
Error Date : Wednesday, April 30th 2008 @ 11:35:40 AM
Script : http://www.tmgrs.co.uk/forum/index.php
Referrer : http://www.tmgrs.co.uk/forum/index.php
IP Address : **.**.**.**
Username : Martin
Classname : vB_Database
MySQL Version : 5.1.22-rc-community

[EricPSF]

Hi Martin,

I got this similar error too :(

Database error in vBulletin 3.7.0:
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 'xxxxxxx_forum.moderation.postid' in 'on clause'
Error Number : 1054
Request Date : Wednesday, April 30th 2008 @ 09:53:23 AM
Error Date : Wednesday, April 30th 2008 @ 09:53:23 AM
Script : http://www.xxxxxxx.com/forums/admincp/index.php?do=home
Referrer : http://www.xxxxxxx.com/forums/admincp/index.php?do=nav
IP Address : xxxxxxxxxx
Username : Eric
Classname : vB_Database
MySQL Version : 4.1.22-standard

Anyone please help us.

[DigitALL2]

I have done upgrades since 3.5.1 with no problems. Now I have upgraded form 3.6.10 and I did follow the steps carefully each time.
I am with my forum in hold. Please help.
I started the upgrade and at "This script will update your vBulletin installation to version 3.7.0 Beta 5"
when I pressed next I got the following:

Please help me as as possible. I don't know what to do.


Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
UPDATE vbtemplate SET title = '.inlinemod' WHERE title = 'td.inlinemod';
MySQL Error : Duplicate entry '.inlinemod-87-css' for key 2
Error Number : 1062
Request Date : Wednesday, April 30th 2008 @ 11:01:47 PM
Error Date : Wednesday, April 30th 2008 @ 11:01:48 PM
Script : http://www.myforum.com/forum/install/upgrade_370b5.php?step=1
Referrer : http://www.myforum.com/forum/install/upgrade_370b5.php
IP Address : 111.212.200.39
Username :
Classname : vB_Database
MySQL Version : 4.1.22-standard


I have tried to do the upgrade again starting the installation precess and it jumps directly to ""This script will update your vBulletin installation to version 3.7.0 Beta 5" and when I press next, it is the same error.

I have triple checked the configp.php to contain the same info as the prior file, it all matches.
All uploads have been with no problem, no error, using CuteFTP, the same as I did many time before.

[soundbarrierpro]

Did you guys backup your db and root first? If so reset everything and start over.

Did you delete the install/install.php file first before running the upgrade? Everything went smoothly for me and I upgraded through every level from 3.6.8

[DigitALL2]

All that has been done. thank you for the reply.

Why somebody from vbul does not help us?

[DigitALL2]

I have uploaded all files again but it stops at the same error. Please help.
As per the message attached, what is error 1062?

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[DigitALL2]

I have just done that, thank you very much.

[Jingus]

I had the same problem and the same message.
I uploaded my administrator file again and it fixed it.

[Jafo]

If you have this plugin installed "Moderation Queue on FORUMHOME (http://www.vbulletin.org/forum/showthread.php?t=120150)", you will get this error. You need to disable the product.