tanha
12-26-2008, 07:24 PM
plase help i have Database error
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN (Array)
ORDER BY lastpost DESC
LIMIT 0, 15;
MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Request Date : Friday, December 26th 2008 @ 03:13:22 PM
Error Date : Friday, December 26th 2008 @ 03:13:22 PM
IP Address : ........................
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-community
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN (Array)
ORDER BY lastpost DESC
LIMIT 0, 15;
MySQL Error : Unknown column 'Array' in 'where clause'
Error Number : 1054
Request Date : Friday, December 26th 2008 @ 03:13:22 PM
Error Date : Friday, December 26th 2008 @ 03:13:22 PM
IP Address : ........................
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-community