Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-25-2008, 09:20 PM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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.
Reply With Quote
  #2  
Old 09-26-2008, 06:07 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try disabling any modifications you have running.
Reply With Quote
  #3  
Old 09-30-2008, 01:35 AM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #4  
Old 09-30-2008, 01:58 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #5  
Old 09-30-2008, 02:05 AM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #6  
Old 09-30-2008, 02:14 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #7  
Old 09-30-2008, 02:22 AM
ATVTorture ATVTorture is offline
 
Join Date: Sep 2008
Posts: 121
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #8  
Old 09-30-2008, 03:06 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ATVTorture View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:10 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05943 seconds
  • Memory Usage 2,226KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete