The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
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 ![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|