vb.org Archive - DB error manually adding a user

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

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

- - DB error manually adding a user (https://vborg.vbsupport.ru/showthread.php?t=191906)

ATVTorture

09-25-2008 09:20 PM

DB error manually adding a user

We I try to maually add a user from admincp, I get the following error and was wondering if anyone can tell me how to resolve:

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

SHOW TABLE STATUS LIKE user';



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 'user'' at line 1

Error Number  : 1064

Script        : http://www.mydomain.com/forums/admincp/user.php?do=update

Referrer      : http://www.mydomain.com/forums/admincp/user.php?do=add

Classname     : vb_database

MySQL Version : 4.1.22-max-log

The error actually does have my correct doman url. Ijust replced it for privacy.

Dismounted

09-26-2008 06:07 AM

Try disabling any modifications you have running.

ATVTorture

09-30-2008 01:35 AM

I've tried disabling every mod and still get the same error? Do you ahve another idea as to where to look. Does the code in the error look correct?

Thanks!
Buster

Lynne

09-30-2008 01:58 AM

Did you disable them all at once or just one by one?
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:


		
			
define('DISABLE_HOOKS', true);

Also, try reuploading all totally default vb files in your modcp and admincp.

ATVTorture

09-30-2008 02:05 AM

Lynne, I tried one at a time, trying a new user after each plugin was disabled ( I think) until they were all disabled at the same time.

However, I just tried what you said as far as adding "define('DISABLE_HOOKS', true); " to config.php and was able to create a user. Where do I go from here?

Thanks again for your help!
Buster

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

Another question, I'm running 3.7.3, but not Patch level 1. If I upload those files, replacing my existing ones, and have heavily modified templates, will I lose my theme modifications?

Or, is that even the thing to do at this point based on my last post?

Thanks!
Buster

SEOvB

09-30-2008 02:14 AM

You have a modification causing the problem or possibly a .xml file in the includes folder that is causing the havoc.

Start by removing unneccassary .xml files. Followed with uninstalling plugins/modifications on at a time and you should find the culprit

ATVTorture

09-30-2008 02:22 AM

But if I remove an xml file not knowing if it is the culpritt, might I make that plugin disfunctional unnecessarily?

Thanks!
Buster

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

Well, in trying it again, I found that vbgallery is causing the error. What should I do to resolve? If I remove the xml file, won't it render vbgallery useless?

Thanks!
Buster

SEOvB

09-30-2008 03:06 AM

Quote:

Originally Posted by ATVTorture (Post 1633640)

Well you can leave it there and run a modification that is cuasing issues with standard vbulletin functions (not advisible) or you could make sure you're running the latest version, and then inform the modification author of the problem

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01027 seconds Memory Usage 1,732KB 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)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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: