Thread: I have a big problem. Error Messages.
View Single Post
  #1  
Old 07-05-2002, 12:31 AM
Peace Peace is offline
 
Join Date: Apr 2002
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default I have a big problem. Error Messages.
Please help.


Quote:
Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO userfield (userid,field10,field29,field11,field8,field6,fiel d1,field4,field2,field12,field13,field15,field3,fi
eld16,field17,field18,field19,field20,field22,fiel d21,field24,field25,field26,field27,field28) VALUES (,'','Male','','','','','','','','','','','','','' ,'','','','','','','','','')
mysql error: You have an error in your SQL syntax near ''','Male','','','','','','','','','','','','','', '','','','','','','','','')' at line 1

mysql error number: 1064

Quote:
Invalid SQL: SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=1
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064




Quote:
Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO userfield (userid,field10,field9,field11,field8,field6,field 1,field4,field2,field12,field13,field15,field3,fie
ld16,field17,field18,field19,field20,field22,field 21,field24,field25,field26,field27,field28) VALUES (,'','Male','19','','','','','','','','','','','', '','','','','','','','','','')
mysql error: You have an error in your SQL syntax near ''','Male','19','','','','','','','','','','','',' ','','',' at line 1

mysql error number: 1064




Quote:
Invalid SQL: INSERT INTO userfield (userid,field10,field9,field11,field8,field6,field 1,field4,field2,field12,field13,field15,field3,fie
ld16,field17,field18,field19,field20,field22,field 21,field24,field25,field26,field27,field28) VALUES (,'','Female','','','','','','','','','','','','', '','','','','','','','','','')
mysql error: You have an error in your SQL syntax near ''','Female','','','','','','','','','','','','',' ','','','','','','','','','')' at line 1

mysql error number: 1064

Date: Tuesday 02nd of July 2002 11:00:06 PM
Script: http://www.theonline***.com/foru...m/register.php3
Referer: http://www.theonline***.com/forum/register.php3


Quote:
Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh
owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon
eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu
p,referrerid,nosessionhash,starlevel,starimg,gende r) VALUES (NULL,'Test 4','test','test@test.com','','0','http://','','','','','1','1','0','New-bie','1025736962','1','-1','1025736962','1025736962','3','0','1','1','0',' 15','0','-1','1','216.176.168.147','0','0','1','','','gender ')
mysql error: Unknown column 'gender' in 'field list'

mysql error number: 1054

Date: Wednesday 03rd of July 2002 05:56:02 PM
Script: http://www.theonline***.com/foru...s/register.php3
Referer: http://theonline****.com/forums/register.php3


[/i]
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01116 seconds
  • Memory Usage 1,784KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete