Tweet
Error Number : 1052
I keep getting this error when users try to post. I upgraded from 3.5.4 to 3.6.1. Might have been a big mistake to do that.... 
Please help. Thanks.
----------------------------
Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT post.*
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 2043
AND dateline > 1159323960
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 19827
ORDER BY dateline DESC
LIMIT 1;
MySQL Error : Column: 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Wednesday, September 27th 2006 @ 07:26:01 PM
Script : http://www.thedomain.com/newreply.php
Please help. Thanks.
----------------------------
Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT post.*
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 2043
AND dateline > 1159323960
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 19827
ORDER BY dateline DESC
LIMIT 1;
MySQL Error : Column: 'dateline' in where clause is ambiguous
Error Number : 1052
Date : Wednesday, September 27th 2006 @ 07:26:01 PM
Script : http://www.thedomain.com/newreply.php
Comment