Log in

View Full Version : MySQL error on Post - suspect subscription?


hoochblues
03-30-2007, 05:54 PM
I keep getting the following MySQL error when I post a new thread. The thread posts ok. Based on the SQL statements, I am guessing I have a problem with subscriptions. But I am not sure where to look.

Any ideas?

Thanks!

Walt

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT email, username
FROM user
WHERE userid IN ();

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 ')' at line 3
Error Number : 1064
Date : Friday, March 30th 2007 @ 01:47:45 PM

Marco van Herwaarden
03-30-2007, 09:06 PM
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

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.

If your problem still exists, please create a new Style with no Parent set. Now browse the forum using this new style.

calorie
03-30-2007, 10:15 PM
Using Instant New Thread Notification (https://vborg.vbsupport.ru/showthread.php?t=141280)? If so, upgrade to the latest version. Note post eleven (https://vborg.vbsupport.ru/showpost.php?p=1203096&postcount=11) had the same error before upgrading.