SQL error after upgrade.

[mightyb]

Hey guys!

I went from 3.5.4 to 3.6.5 and now every time i login as an admin i get the following error:

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT COUNT(postid) AS count
FROM vbpost AS post
LEFT JOIN vbdeletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE visible = 0 AND dateline > 1174327637
AND deletionlog.primaryid IS NULL;

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Monday, March 19th 2007 @ 02:54:59 PM
Script : http://www.thelocalforum.co.uk/forum/
Referrer :
IP Address : my IP
Username : My username
Classname : vb_database

Everything else seem to work fine. I was told that this error is probably caused by a mod. Does anyone know what one that might be and how i could disable it via php admin because obviously i don't have access to CP.

Thanks a lot!

[Lynne]

Which table is dateline in? Change it from just "dateline" to "table.dateline" where table is the name of the table.

[WetWired]

That looks like a query to find the number of new posts needing moderation. I'd guess that you either have a mod relating to thread/post moderation (or just a general admincp front page enhancement) that needs updating, or that you didn't upload the new admincp files and it's still running on old code.