Vbulletin upgrade problem.

Discussion in 'vBulletin' started by mightyb, Mar 19, 2007.

0
  1. #1
    I have just upgraded to the latest version. 3.5.4 to 3.6.5 i think. Everything worked but when i log in 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
    Code (markup):
    Any ideas guys? Thanks!

    I was going to get some support on Vbulletin but i run into even more problems there. (My forum account would not get activated etc)
     
    mightyb, Mar 19, 2007 IP