vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   I have a big problem. Error Messages. (https://vborg.vbsupport.ru/showthread.php?t=40671)

Peace 07-05-2002 12:31 AM
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]

g-force2k2 07-05-2002 12:33 AM
What are you trying to do by chance? I can see part of the problem but to play it safe i think you're going to have to go to the members area and input your password and id... at least soemthing like that ;)

g-force2k2

Peace 07-05-2002 12:46 AM
Quote:
Originally posted by g-force2k2
What are you trying to do by chance? I can see part of the problem but to play it safe i think you're going to have to go to the members area and input your password and id... at least soemthing like that ;)

g-force2k2
I'm trying to get help on solving my forum problem.

Can you tell me part of the problem and how can it be fixed?

g-force2k2 07-05-2002 01:24 AM
Well it seems you have a problem with first something to do with the avatars... second unknown fields... and third im not even sure of the php3 extensions... like i said best bet is to go to the members area to seek support ;)

g-force2k2

Logician 07-07-2002 08:02 AM
very likely: you applied gender hack modifications to your php scripts but forgot to run the relevant SQL query to update your tables.

Last error message explains it all: "mysql error: Unknown column 'gender' in 'field list'". That is, you are supposed to have a gender column in your table and you dont have it.

Check hack instructions carefully..

Xenon 07-07-2002 08:08 AM
<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=40707" target="_blank">https://vborg.vbsupport.ru/showt...threadid=40707</a>

look what i found ^^

g-force2k2 07-07-2002 08:33 AM
^^ thanks Xenon thought i was seeing double somewhere ;)

g-force2k2


All times are GMT. The time now is 11:37 AM.

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.00947 seconds
  • Memory Usage 1,736KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete