Database error in vBulletin 3.0.7:

[IWLSR5]

I posted this same question under vbulletin.com, but they directed me to vbulletin.org because the error is related to a hack? The problem is, I have no idea what hack is causing the error.

Can anyone help me with this error? We're getting automated emails with this error, and can't figure out why? Any help would be much appreciated.

The hacks we installed are:
1. Links Database version 1.60
2. vbChat
3. Aambience (Skin)
4. Admin Alert (Alerts us with the login info of people trying to access admin)

I believe Links "Database version 1.60" was the last hack installed, but everything has been running fine for nearly 2 weeks. Now all of the sudden we're getting this error.

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(threadid) AS articles,
SUM(IF(lastpost>=1121776790 AND open<>10,1,0)) AS newarticle
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE 1=1
AND forumid IN ()
AND thread.pollid > 0
AND visible = 1
AND open != 10
AND lastpost >= 1121171990
AND deletionlog.primaryid IS NULL

mysql error: You have an error in your SQL syntax near ')
AND thread.pollid > 0
AND visible = 1
AND open != 10
AND lastpost >= 11211' at line 8

mysql error number: 1064

[Paul M]

Are you sure you don't have an Articles hack installed - because that's what it looks like.

[Marco van Herwaarden]

Looks like a rticle hack to me, just like Paul said.

Also please include the full error message including the scriptname etc.

[IWLSR5]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT COUNT(threadid) AS articles,
SUM(IF(lastpost>=1121761353 AND open<>10,1,0)) AS newarticle FROM vb3_thread AS thread LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')

WHERE 1=1
AND forumid IN ()
AND thread.pollid > 0
AND visible = 1
AND open != 10
AND lastpost >= 1121156553
AND deletionlog.primaryid IS NULL

mysql error: You have an error in your SQL syntax near ')
AND thread.pollid > 0
AND visible = 1
AND open != 10
AND lastpost >= 11211' at line 8

mysql error number: 1064

Date: Tuesday 19th of July 2005 04:22:33 AM
Script: http://dmatter.net/modules.php?name=More_Polls
Referer:
Username: Unregistered
IP Address: xx.xxx.xx.xxx

[Paul M]

modules.php is not one I recognise - sounds like a portal hack.