DB error manually adding a user

[ATVTorture]

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:

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]

Try disabling any modifications you have running.

[ATVTorture]

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]

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]

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]

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]

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]

Originally Posted by ATVTorture

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

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