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

Reply
 
Thread Tools
database error Details »»
database error
Version: , by Roxie Roxie is offline
Developer Last Online: Jul 2014 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 06-06-2002 Last Update: Never Installs: 0
 
No support by the author.

I get this error when I try to edit a members profile

Quote:
Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1969-12-31 19:00:00'),returndate='0000-00-00',awayreason='',birthday='1977-08-29'options='15',usergroupid='8',username='BabyGirl ',email='babyeskimo@hotmail.com',styleid='1',paren temail='',coppauser=0,homepage='http://members.blackplanet.com/1Babygirl2000/',icq='',aim='Babygirl1dst2000',yahoo='Babyeskimo' ,signature='',adminemail=1,showemail=1,invisible=0 ,usertitle='Co-Admin',customtitle=0,joindate=UNIX_TIMESTAMP('2002-05-20 10:28:15'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-06-06 12:57:05'),lastactivity=UNIX_TIMESTAMP('2002-06-06 13:58:45'),lastpost=UNIX_TIMESTAMP('2002-06-06 13:56:13'),posts='648',timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='0' ,ipaddress='67.104.144.141',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1') WHERE userid=6
mysql error: You have an error in your SQL syntax near 'options='15',usergroupid='8',username='BabyGirl', email='babyeskimo@hotmail.com',' at line 1

mysql error number: 1064

Date: Thursday 06th of June 2002 03:12:10 PM
Script: http://odb.dayum.net/admin/user.php
Referer: http://odb.dayum.net/admin/user.php?...=edit&userid=6
I have added a few hacks and I don't which one could have caused the error. :surprised:

Show Your Support

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

Comments
  #2  
Old 06-06-2002, 06:28 PM
Steve Machol's Avatar
Steve Machol Steve Machol is offline
 
Join Date: Nov 2001
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
This looks like the error that results from an incompatibility between vB and PHP 4.2.0/4.2.1. You can either upgrade to 2.2.6 (recommended) or apply the patches in the PHP 4.2.0 thread in the Announcements forum at vbulletin.com.
Reply With Quote
  #3  
Old 06-06-2002, 06:35 PM
Roxie's Avatar
Roxie Roxie is offline
 
Join Date: May 2002
Location: on vb.org
Posts: 526
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
If I upgrade I will lose all my hacks?
Reply With Quote
  #4  
Old 06-07-2002, 01:16 PM
Xenon's Avatar
Xenon Xenon is offline
 
Join Date: Oct 2001
Location: Bavaria
Posts: 12,878
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
birthday='1977-08-29'options='15'

the ' before options has to be a , i think
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 10:40 PM.

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.03462 seconds
  • Memory Usage 2,225KB
  • Queries Executed 17 (?)
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_quote
  • (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_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