| Ninth Dimension |
09-28-2005 02:30 PM |
Database error
I'm not sure if this is the correct forum or not, but here goes..
I'm getting a database error generated when someone visits my site. This specific person has been banned, but I guess he does not know it yet (i.e. he keeps coming back), so I'd like to try and fix the problem.. here is the error:
Code:
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT
thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM vb3_thread as thread
LEFT JOIN vb3_icon USING (iconid)
LEFT JOIN vb3_forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN vb3_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 929)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(1,7,31,36,9,11,16,4,15,32,46,22,24,26,39,23,12,20,38,40,48,45,21,41,44,43,49,35,42,33,13,29,30,2,47,14) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 18
mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 18
' at line 15
mysql error number: 1064
Date: Wednesday 28th of September 2005 02:11:11 PM
Script: http://www.arathor.theice.co.uk/
Referer:
Username: meh
IP Address: 85.167.188.10
I'm using vBadvance as my front page, so I'm guessing it's an error with that, but I've never been too good with MySQL errors, so if you could point me in the right direction. thank you :)
|
More Information