View Full Version : Error Number : 1064
Tahir_Younus786
12-29-2010, 09:28 AM
Database error in vBulletin 4.0.8:
Invalid SQL:
SELECT ipaddress
FROM user
WHERE userid =;
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
Lynne
12-30-2010, 04:21 PM
I can find no query in default vbulletin like this, so I would guess it's from a modification. Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php
define('DISABLE_HOOKS', true);
Tahir_Younus786
12-30-2010, 04:56 PM
I can find no query in default vbulletin like this, so I would guess it's from a modification. Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php
define('DISABLE_HOOKS', true);
I can't understand, Please elaborate it.. Can i disable all plugins?
TheLastSuperman
12-30-2010, 05:00 PM
I can find no query in default vbulletin like this, so I would guess it's from a modification. Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php
define('DISABLE_HOOKS', true);
I can't understand, Please elaborate it.. Can i disable all plugins?
Yes ;).
Lynne said to edit this file: config.php
On your server, look for FORUMFOLDER/includes/config.php
Edit that, add in the
define('DISABLE_HOOKS', true);
Directly below the <?php in the file then save and upload back into the /includes folder. That disables your mods/plugins. Now check to see if you still have issues, if not then you know it was a plugin or mod and you can disable one by one to debug and track etc.
Pretty much what Lynne said I just drug it out lol.
Tahir_Younus786
12-30-2010, 05:26 PM
I have disabled all the plugins using Admin CP. My Problem has been solved. Now tell me what to do next?
Lynne
12-30-2010, 05:39 PM
Now you need to figure out which product or plugin is causing the issue. Turn them all off via the Manage Products AND Plugin Manager page, remove that line from the config.php file, then turn on the products/plugins one by one until you have the problem again. Or, take a look at the plugins to find that query.
Tahir_Younus786
12-30-2010, 06:10 PM
Thanks Both of You i have Prob with This Plugin
i have Del This Plug in can i Reinstall This
Welcome Thread On Register 2.0
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.