vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Error Number : 1064 (https://vborg.vbsupport.ru/showthread.php?t=256114)

Tahir_Younus786 12-29-2010 09:28 AM

Error Number : 1064
 
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

PHP Code:

define('DISABLE_HOOKS'true); 


Tahir_Younus786 12-30-2010 04:56 PM

Quote:

Originally Posted by Lynne (Post 2141389)
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

PHP Code:

define('DISABLE_HOOKS'true); 




I can't understand, Please elaborate it.. Can i disable all plugins?

TheLastSuperman 12-30-2010 05:00 PM

Quote:

Originally Posted by Lynne (Post 2141389)
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

PHP Code:

define('DISABLE_HOOKS'true); 


Quote:

Originally Posted by Tahir_Younus786 (Post 2141412)

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
PHP Code:

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


All times are GMT. The time now is 03:27 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01622 seconds
  • Memory Usage 1,728KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete