Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page Database error when trying to Edit Users via. AdminCP
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2004, 04:25 AM
ZiRu$'s Avatar
ZiRu$ ZiRu$ is offline
 
Join Date: Jan 2002
Location: Manitoba, Canada
Posts: 520
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database error when trying to Edit Users via. AdminCP
Hey, I'm trying to edit my info (change avatar, country, details etc.) from the admin CP and whenever i do i get this error:

PHP Code:
Database error in vBulletin Control Panel 2.3.5:

Invalid SQL: UPDATE user SET birthday='1985-03-25',options='3',usergroupid='6',username='Zirus',email='test@hotmail.com',styleid='',parentemail='',coppauser=,homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,invisible=0,usertitle='Administrator',customtitle=,joindate=UNIX_TIMESTAMP('2004-11-05 18:27:35'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2004-11-17 22:07:35'),lastactivity=UNIX_TIMESTAMP('2004-11-18 22:18:57'),lastpost=UNIX_TIMESTAMP('2004-11-08 17:45:59'),posts='1',timezoneoffset='-6',country='Canada',emailnotification=0,receivepm='0',emailonpm='0',ipaddress='',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=1
mysql error: You have an error in your SQL syntax near 'homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,i' at line 1

mysql error number: 1064

Date: Thursday 18th of November 2004 10:19:15 PM
Script: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php
Referer: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php?action=edit&userid=1 
Can anyone help?
Reply With Quote
  #2  
Old 11-19-2004, 05:27 AM
Colin F's Avatar
Colin F Colin F is offline
 
Join Date: Jul 2004
Location: Switzerland
Posts: 1,551
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by ZiRu$
Hey, I'm trying to edit my info (change avatar, country, details etc.) from the admin CP and whenever i do i get this error:

PHP Code:
Database error in vBulletin Control Panel 2.3.5:

Invalid SQL: UPDATE user SET birthday='1985-03-25',options='3',usergroupid='6',username='Zirus',email='test@hotmail.com',styleid='',parentemail='',coppauser=,homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,invisible=0,usertitle='Administrator',customtitle=,joindate=UNIX_TIMESTAMP('2004-11-05 18:27:35'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2004-11-17 22:07:35'),lastactivity=UNIX_TIMESTAMP('2004-11-18 22:18:57'),lastpost=UNIX_TIMESTAMP('2004-11-08 17:45:59'),posts='1',timezoneoffset='-6',country='Canada',emailnotification=0,receivepm='0',emailonpm='0',ipaddress='',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=1
mysql error: You have an error in your SQL syntax near 'homepage='',icq='',aim='',yahoo='',signature='hi mom',adminemail=0,showemail=0,i' at line 1

mysql error number: 1064

Date: Thursday 18th of November 2004 10:19:15 PM
Script: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php
Referer: XXXXXXXXXXXXXXXXXXXXXXX/forum/admin/user.php?action=edit&userid=1 
Can anyone help?
you're missing the ''s after coppauser.

Did you edit your admincp/user.php lately? If so, try to take the default file and redo the changes.
Reply With Quote
  #3  
Old 11-19-2004, 08:09 PM
HiDeo's Avatar
HiDeo HiDeo is offline
 
Join Date: Oct 2003
Posts: 306
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Yes, upload original file
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 05:49 AM.

Contact Us - Archive - Top

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.03314 seconds
  • Memory Usage 2,218KB
  • 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
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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