Upgraded to 3.8.4, now having MySQL issues in the admincp homepage

[jdefini]

Hello Everyone, I was hoping someone could help me out with my recent upgrade. I went from 3.5 to 3.8.4 and besides some template stuff everything appears to be OK except for my admincp homepage.

When I go to the admincp I get a message in the body area that states exactly......

Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT COUNT(*) AS count
FROM vb_moderation AS moderation
INNER JOIN vb_post AS post USING (postid)
WHERE moderation.type='reply';
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Friday, January 1st 2010 @ 06:52:43 PM
Error Date : Friday, January 1st 2010 @ 06:52:43 PM
Script : http://www.tuner-junction.com/TJForum/administratorcp/index.php?do=home
Referrer : http://www.tuner-junction.com/TJForum/administratorcp/index.php
IP Address : 75.97.105.192
Username : 'myusername'
Classname : vb_database
MySQL Version : 5.0.83-log

I realy don't know where to go with this error and it's confusing because everything seems to be working on the forum thus far (knock on wood). Any help would be greatly appreciated.

Thanks
-John

[jdefini]

hhmmmm... I guess I spoke to soon. I am now also getting this error when I click on my "posts awaiting modertaion" link. It's.....

Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT postid, pagetext, post.dateline, post.userid, post.title AS post_title,
thread.title AS thread_title, thread.forumid AS forumid, username, thread.threadid
FROM vb_post AS post
LEFT JOIN vb_thread AS thread ON(thread.threadid = post.threadid)
WHERE (1 = 0 thread.forumid IN(1, 130, 183, 53, 54, 52, 184, 51, 67, 69, 83, 68, 74, 72, 77, 79, 76, 181, 111, 86, 92, 73, 115, 179, 15, 120, 17, 21, 18, 19, 20, 123, 25, 26, 121, 23, 22, 24, 122, 33, 35, 36, 134, 178, 182, 176, 131, 34, 152, 153, 154, 155, 156, 157, 144, 147, 148, 149, 150, 151, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 27, 28, 29, 30, 31, 118, 43, 44, 45, 46, 133, 37, 38, 40, 41, 119, 124, 42, 180, 56, 58, 125, 126, 127, 128, 60)) AND postid IN(,,)
ORDER BY dateline;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'thread.forumid IN(1, 130, 183, 53, 54, 52, 184, 51, 67, 69, 83, 68, 74, 72, 77, ' at line 5
Error Number : 1064
Request Date : Friday, January 1st 2010 @ 07:00:16 PM
Error Date : Friday, January 1st 2010 @ 07:00:17 PM
Script : http://www.tuner-junction.com/TJForum/moderatorcp/moderate.php?do=posts
Referrer : http://www.tuner-junction.com/TJForum/index.php
IP Address : 75.97.105.192
Username : jadkar
Classname : vb_database
MySQL Version : 5.0.83-log

[tassoman]

I'm running an upgrade from 3.6.x to 4.0.0 on test environment:

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM vb_attachment AS attachment
INNER JOIN vb_post AS post USING (postid)
WHERE attachment.visible = 0;

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Tuesday, January 5th 2010 @ 01:13:54 AM
Error Date : Tuesday, January 5th 2010 @ 01:13:54 AM
Script : http://forum.netplay.it/acp/index.php?do=home
Referrer : http://forum.netplay.it/acp/index.php?do=nav
IP Address : 192.168.1.7
Username : Tassoman
Classname : vB_Database
MySQL Version : 5.0.51a-24+lenny2

The problem is that column postid is missing into table vb_attachments. First I gave a run to upgrade with attachments into database and problem was the same. Then also I got it again the same with filesystem attachments.

[Trevor Hannant]

tassoman, please post your problem in the correct vB4 forum.

jdefini - can you try reuploading the 3.8.4 files again - ensure these are in ASCII mode and that the existing files are overwritten