SQL error after upgrade.

[Mightyb]

I have just upgraded to the latest version after skipping a few updates. I did not get any errors during the install and everything looked fine. When i log in as an admin however 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

Any ideas? Thanks a lot!

[Zachery]

What version of vbulletin are you running?

[Mightyb]

Upgraded to 3.6.5 from 3.5.4

Ta!

[Steve Machol]

Which version of MySQL are you running? Have you installed any hacks, products or plugins?

[Mightyb]

Its 4.1.21

Yes i did. Shall i try and disable these via php admin? What would be the best way of doing this?

[Steve Machol]

That version of MySQL has a serious bug and I strongly recommend you get your host to upgrade it, but this problem is not due to that bug.

It appears that one of your add-ons created a 'dateline' field somewhere in the database that is conflicting with vB. To fix this you will need to find out which plugin did this and remove it along with the changes it made to the database.

[meissen]

I have that same exact problem after upgrading. Have you figured out what modification that causes it? I can't replicate it on a regular basis, I just get random instances where it happens. I thought it might be the "Prevent Double Post" modification, so I disabled that. Figure I'd see if that fixes it for now, if it still happens then I know it's not that and something else needs to be disabled.