vb.org Archive - Database Error 3 7 x

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database Error 3 7 x (https://vborg.vbsupport.ru/showthread.php?t=206718)

Duslerforum.ORG

02-26-2009 08:32 PM

Database Error 3 7 x

Hello, my problem I
Database error

changing the admin panel members would encounter problems

error code

Code:



Database error in vBulletin 3.7.4:

Invalid SQL:

UPDATE;

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 1

Error Number  : 1064

Request Date  : Tuesday, February 24th 2009 @ 08:05:30 PM

Error Date    : Tuesday, February 24th 2009 @ 08:05:31 PM

Script        : http://www.xxxx.org/admincp/user.php?do=update

Referrer      : http://www.xxx.org/admincp/user.php?do=edit&u=5010

IP Address    : 88.242.xxx.xxx

Username      : xxxxxx

Classname     : vB_Database

MySQL Version : 5.0.67-community

BSMedia

02-26-2009 10:06 PM

Disable any plugins and modifications you have to your forums and try again.

Duslerforum.ORG

02-26-2009 10:59 PM

I've tried, but did not change :(

--------------- Added [DATE]1235731737[/DATE] at [TIME]1235731737[/TIME] ---------------

??.........

Dismounted

02-27-2009 10:58 AM

Add this to the end of your config.php and try again:

PHP Code:


		
			
define('DISABLE_HOOKS', true);

Duslerforum.ORG

03-01-2009 11:27 AM

No, it gives the same error again

:(

Duslerforum.ORG

03-02-2009 11:44 PM

Do not the solution :S

pattycake

03-02-2009 11:57 PM

From google:
You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved word in your query such as "when" or "order".

Marco van Herwaarden

03-03-2009 08:40 AM

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, do you still have the same problems? If you are troubleshooting login or guest issues, you will need to set this style as board default in the vBulletin Options.

Duslerforum.ORG

03-08-2009 11:19 PM

ok but
did not change

:(

snakes1100

03-08-2009 11:32 PM

Post the complete mysql error.

All times are GMT. The time now is 06:05 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00936 seconds Memory Usage 1,724KB 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 (1)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)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
Messages: