PDA

View Full Version : Problem when i try to post a comment.


Blind
12-29-2008, 06:16 PM
Hi,

when I try to post a new comment in any review, article or tutorial always goes wrong.

The error that appears is:

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT post.*
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid = 88687
AND dateline > 1230492296
AND visible = 1 AND deletionlog.primaryid IS NULL
AND postid <> 769935
ORDER BY dateline DESC
LIMIT 1;

MySQL Error : Column 'dateline' in where clause is ambiguous
Error Number : 1052
Request Date : Monday, December 29th 2008 @ 08:24:56 PM
Error Date : Monday, December 29th 2008 @ 08:24:56 PM
Script : http://www.xxxx.com/foro/newreply.php?do=postreply&t=88687
Referrer : http://www.xxxx.com/foro/newreply.php?do=newreply&noquote=1&p=769931
IP Address : xx.xx.xx.73
Username : Blind
Classname : vB_Database
MySQL Version : 5.0.44-log


Replys to normal threads work perfectly.

¿Any idea?

Sorry for my bad english.

Greetings

Morgan
12-30-2008, 05:28 PM
Are you using a 'Prevent Doubleposting' add-on? If so, see this (http://www.vbulletin.org/forum/showpost.php?p=1054999&postcount=568) post or check the thread for the add-on. If not, temporarily disable all add-ons except for GARS and then turn them on one by one, testing each time, to see if/where a conflict exists.