Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Can't Edit User - MySQL Error Number 1064 Details »»
Can't Edit User - MySQL Error Number 1064
Version: , by Tailfeathers Tailfeathers is offline
Developer Last Online: Jun 2011 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 09-29-2002 Last Update: Never Installs: 0
 
No support by the author.

If I try to edit a user from the admin control panel, I get this error:

There seems to have been a slight problem with the Tailfeathers database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


Code:
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET birthday='0',awaydate=UNIX_TIMESTAMP('1969-12-31 19:00:00'),returndate='0000-00-00',awayreason='',1982-12-19',options='15',usergroupid='2',username='taffywduck',email='taffyduck_02@hotmail.com',styleid='1',parentemail='',coppauser=0,homepage='http://',icq='17541430',aim='',yahoo='',signature='',adminemail=1,showemail=0,invisible=0,usertitle='Egg',customtitle=0,joindate=UNIX_TIMESTAMP('2002-09-29 17:14:58'),cookieuser=1,nosessionhash=1,daysprune='5',lastvisit=UNIX_TIMESTAMP('2002-09-29 17:22:34'),lastactivity=UNIX_TIMESTAMP('2002-09-29 17:42:19'),lastpost=UNIX_TIMESTAMP('2002-09-29 17:20:34'),posts='1',timezoneoffset='-3.5',emailnotification=1,receivepm='1',emailonpm='1',ipaddress='65.94.131.31',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1'),canreportposts='1' WHERE userid=5
mysql error: You have an error in your SQL syntax near '1982-12-19',options='15',usergroupid='2',username='taffywduck',email='taffyduck_' at line 1

mysql error number: 1064

Date: Sunday 29th of September 2002 06:20:10 PM
Script: http://www.tailfeathersnetwork.com/admin/user.php
Referer: http://www.tailfeathersnetwork.com/a...=edit&userid=5
Any ideas?

Thanks.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 09-29-2002, 09:24 PM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Reupload the original user.php file from the 2.2.8 zip file. Make sure you upload in ASCII and overwrite the one on the server.
Reply With Quote
  #3  
Old 09-29-2002, 09:37 PM
Tailfeathers's Avatar
Tailfeathers Tailfeathers is offline
 
Join Date: Sep 2002
Location: Utah, USA
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It worked. Thank you very much.
Reply With Quote
  #4  
Old 09-29-2002, 09:42 PM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No problem!
Reply With Quote
Reply


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 06:29 AM.


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.03568 seconds
  • Memory Usage 2,232KB
  • Queries Executed 19 (?)
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)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)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_postinfo_query
  • fetch_postinfo
  • 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