Data base error evry time ,

[ForYou]

Hello ,

There is message Data base error i recievd it evry day by the email , but i don't know how can i solve it ,

Database error in vBulletin 3.8.0 Release Candidate 2:
Invalid SQL:
       SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, 
       thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
       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(95,2,114,85,70,71,86,145,96,20,,19,110,145,96,20)
       ORDER BY lastpost DESC 
       LIMIT 0, 10;
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 '19,110,145,96,20)
       ORDER BY lastpost DESC 
       LIMIT 0, 10' at line 9
Error Number  : 1064
Request Date  : Friday, December 26th 2008 @ 03:53:37 PM
Error Date    : Friday, December 26th 2008 @ 03:53:38 PM
Script        : http://www.dardasha.ps/montada/forumdisplay.php?f=119
Referrer      : 
IP Address    : 2.11.64.97
Username      : admin
Classname     : vB_Database
MySQL Version : 

that mean if the member or vistor click on missing forum he will show Db's Error , but if the link correct and the forum number still on there is no problem and no data base error ,


Please help me to solve this problem ,

Regards

[Steve Machol]

Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-party hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

[ForYou]

Hello ,

The error just come when the members click on this link

http://www.dardasha.ps/montada/f119

but is the members click on this link there is no error come ,
http://www.dardasha.ps/montada/f52/

becuse the first link is error forum# but the seconed is correct !!

How can i solve it am sure there is no problem in files and style and there is no alot of hacks ,

[Zachery]

Make sure your addons are compatable with the latest version of vbulletin. Additionally you'll need to disable them to get support.