vBulletin Database Error?

[KevinGupta]

What is this? I mean what should I do about this error? I don't even know why I am getting it?

I received this error in email via my forum:

Database error in vBulletin 4.0.1:

Invalid SQL:

SELECT COUNT(*) AS threads, SUM(IF(thread.lastpost > 1266667805 AND open <> 10, 1, 0)) AS newthread
FROM thread AS thread
WHERE forumid IN( )
AND thread.visible = 1;

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 ')
AND thread.visible = 1' at line 3
Error Number : 1064
Request Date : Saturday, February 20th 2010 @ 06:10:05 AM
Error Date : Saturday, February 20th 2010 @ 06:10:06 AM
Script : http://www."forum".com/forum/articles.php?c=33
Referrer : http://www."forum".com/forum/articles.php?c=33
IP Address : 195.xxx.xx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

This is the error that I get on the website when I click on the link that I received in email (above):

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: navbar in [path]/includes/functions.php on line 3893

Parse error: syntax error, unexpected T_STRING in /home/public_html/forum/articles.php(40) : eval()'d code on line 1

Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: STANDARD_ERROR in [path]/includes/functions.php on line 3893

Parse error: syntax error, unexpected T_STRING in /home/public_html/forum/articles.php(73) : eval()'d code on line 1
Database error
Forum database has encountered a problem.

--------------------------------------------------------------------------------

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the www."forum".com home page, then try to open another page.
Click the Back button to try another link.

The www."forum".com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[ForumsMods]

It is a problem with a product. Disable the product.

[borbole]

Hoe it happened? Did you do any modifications to your forum prior to getting that error?

[KevinGupta]

I am not sure... Although, it looks like it is due to a mod for Articles that I installed a while ago (before I upgraded my forum to 4.0.1) So, do you think it could be due to some files left uploaded on the server?

I am sure new mods that I installed are not related to articles and all the other previous mods were fully uninstalled via vB Admin Panel.

[Videx]

If this was a one time error, I'd ignore it. Especially if you're on a shared server, since a random timeout could cause it. Don't go changing a whole bunch of stuff because of one random error.

[KevinGupta]

Alright... I don't think I am using this much.. So, not too worried about it.. but thought if there could be something to fix easily without changing much.. I would do it... So, I stop receiving emails about this error...lol

[Paul M]

Originally Posted by KevinGupta

I am not sure... Although, it looks like it is due to a mod for Articles that I installed a while ago (before I upgraded my forum to 4.0.1)

Mods written for vb3 will almost always fail on vb4.

[KevinGupta]

So you are saying it could be due to a mod that I installed recently for vB 4.0.1?