
11-09-2006, 05:28 PM
|
 |
|
|
Join Date: Mar 2004
Location: Alabama
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
I keep getting database errors like this:
Quote:
<!--
Database error in vBulletin 3.6.2:
Invalid SQL:
SELECT COUNT(post.postid) as unread
FROM post as post
INNER JOIN thread as thread ON (thread.threadid = post.threadid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(1, 2, 3, 28, 23, 4, 5, 6, 7, 8, 27, 14, 16, 17, 18, 19, 20, 21, 22, 9, 10, 11, 12, 13)
AND thread.sticky IN (0,1) AND thread.visible IN (0,1,2)
AND thread.lastpost > IF(threadread.readtime IS NULL, , threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, , forumread.readtime)
AND thread.lastpost >
AND post.dateline > IF(threadread.readtime IS NULL, , threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, , forumread.readtime)
AND post.dateline >;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, , ' at line 9
Error Number : 1064
Date : Thursday, November 9th 2006 @ 11:31:48 AM
Script : vBulletin Template Conditionals List - vBulletin Zone
Referrer : (vBSEO Article) List of Commonly Used Template Conditionals - vBulletin-Fans.com
IP Address : 24.214.88.63
Username : Brent
Classname : vB_Database
-->
|
I was looking through my plugins to see which deal with the threadread.readtime and this one had it.
Any suggestions on what is causing the database error?
The error happens when clicking on a link from another site to a thread on my site.
It doesn't happen everytime
|