
2006-08-21
|
 |
Moderador

|
|
Registrado: Aug 2004
Posts: 1.419
FoquiMoney: 6.604
Gracias dadas: 4
Agradecido 34 vez en 24 posts
|
|
|
Re: VB [Req] DoublePosting
Search for:
Code:
**************************
Change to:
Code:
Reason:
With vBulletin v3.6.x the row dateline exists in the tables post and deletionlog (ambiguous).
Regards, Stoebi
***********
Quote:
Originally Posted by Yorixz
Code:
Database error in vBulletin 3.6.0 Beta 3:
Invalid SQL:
SELECT post.*
FROM vb3_post AS post
LEFT JOIN vb3_deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 47971
AND dateline > 1151567543
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 409299
ORDER BY dateline DESC
LIMIT 1;
MySQL Error : Column 'dateline' in where clause is ambiguous
I'm getting that error quite often, didn't manage to reproduce it but I suppose theres something wrong in the query it's using.
|