Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page SQL error
FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1  
Old 04-21-2003, 09:47 PM
Hobbes's Avatar
Hobbes Hobbes is offline
 
Join Date: Dec 2002
Location: Cali
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SQL error
PHP Code:
Database error in vBulletin 2.3.0:

Invalid SQL: UPDATE user SET birthday='1987-11-1',signature='<center><br>
<br>[IMG]http://flint.rpgsyndicate.com/HobbesSig.jpg[/IMG]</center>
<br>
<center><a href=\"http://forums.rpgsyndicate.com/index.php?s=\"><img alt=\"Administrator at RPG Syndicate\" src=\"http://flint.rpgsyndicate.com/OrangeAdmin.gif\" border=\"0\"></a></center>
<br>
<center><a href=\"http://www.rpgsyndicate.com/site/index.html\"><img alt=\"RPG Syndicate\" src=\"http://www11.brinkster.com/rpgsyn/header.html\" border=\"0\"></a></center>',customtitle='1',usertitle='Stuffed Toy',email='ambulantpunk@yahoo.com',parentemail='',coppauser='0',homepage='http://www.rpgsyndicate.com',icq='',aim='AnguishUnsaid5',yahoo='SmileyKidPunk',usergroupid='6', gender='' WHERE userid='18'
mysql error: Unknown column 'gender' in 'field list'

mysql error number: 1054

Date: Monday 21st of April 2003 04:19:53 PM
Script: [url]http://forums.rpgsyndicate.com/member.php[/url]
Referer: [url]http://forums.rpgsyndicate.com/member.php?s=&action=editprofile[/url] 
help? anyone?


sorry i posted this in the wrong forum first
Reply With Quote
  #2  
Old 04-21-2003, 10:46 PM
Hobbes's Avatar
Hobbes Hobbes is offline
 
Join Date: Dec 2002
Location: Cali
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
bitsys you rock thank yo so much
Reply With Quote
  #3  
Old 04-21-2003, 10:56 PM
mr e's Avatar
mr e mr e is offline
 
Join Date: Dec 2001
Posts: 461
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
that just means you dont have the "gender" column in "field list"
Reply With Quote
  #4  
Old 04-22-2003, 12:34 AM
Hobbes's Avatar
Hobbes Hobbes is offline
 
Join Date: Dec 2002
Location: Cali
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
actually...no *hides*

the other admin edited member.php and messed up...and uploaded some other one (he didnt make a correct backup) and the messed up one didnt have the RPG integration member.php file edits :P:P:P:P:P:P!
Reply With Quote
  #5  
Old 04-22-2003, 04:35 AM
mr e's Avatar
mr e mr e is offline
 
Join Date: Dec 2001
Posts: 461
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
if the php script was buggy than of course, it's trying to get data that isn't there and you'll get an error
Reply With Quote
  #6  
Old 04-22-2003, 07:05 AM
Hobbes's Avatar
Hobbes Hobbes is offline
 
Join Date: Dec 2002
Location: Cali
Posts: 230
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
indeed :P all becuz of the other admin uploading the member.php that didnt have the rpg integrationg file edits ^_^

*tips hat* goodday
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

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 11:23 AM.

Contact Us - Archive - Top

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.04298 seconds
  • Memory Usage 2,210KB
  • Queries Executed 13 (?)
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_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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