MySQL syntax?

[jojok]

Apparently on one of the hacks I have an error in my SQL syntax? How can I fix that? What is it?

Database error in vBulletin 2.3.4:

Invalid SQL: SELECT pagetext,postid FROM post WHERE postid IN () ORDER BY postid DESC
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 ') ORDER BY postid DESC' at line 1

mysql error number: 1064

Date: Monday 12th of January 2004 11:45:02 PM
Script: http://www.treehillhigh.net/forum/forum/newsportal.php?
Referer: http://www.treehillhigh.net/forum/newsportal.php?

The Referer URL is wrong, it should be /forum, not /forum/forum

[Xenon]

"WHERE postid IN () "

there should be at least one id in that!

[jojok]

I don't know, that's the error I'm receiving. I don't really consider myself a MySQL expert, and I've never seen an error like this. I'm just wondering how I can fix it.

[cirisme]

WHat hack is it?

[M1th]

its most probably the php script that is causing this, not the mysql tables.

[MindTrix]

https://vborg.vbsupport.ru/showthrea...&page=10&pp=15

That is the hack

[jojok]

I'm getting the same error when I install vBhome lite, so I really don't think it's the script?

[assassingod]

Originally Posted by jojok

I'm getting the same error when I install vBhome lite, so I really don't think it's the script?

You may need to update the vBulletin Options via the AdminCP (and possibly change some for the hack).

[MindTrix]

Im pretty sure with vBhomelite you have to change the settings in the admin cp like assassingod said, to get rid of the MYSQL error.

[jojok]

Thats so odd, I just checked again and vBhomelite is working now.