Firefly, can you help me please?

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

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

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

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

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

[Neo]

Is this the gender hack mate?

[Xenon]

think so

first of all, have you run al querys correct in the installation file:
Unknown column 'gender' in 'field list'

secound quote:
AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar

missing a , between awydate and avatar.avatarpath

[Peace]

Originally posted by neo
Is this the gender hack mate?

I don't have a gender hack installed. I did create a gender "profile field" via the Admin CP.

[Xenon]

then you cant insert into the user table gender=...., you have to insert this value in the userfield table

[Peace]

Originally posted by Xenon
secound quote:
AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar

missing a , between awydate and avatar.avatarpath

Do I insert the "," via PhpmyAdmin to solve this error problem? If so, between where in "awydate and avatar.avatarpath" should I insert the ","?



Thanks

[Xenon]

if you ran this query through phpmyadmin then you have to add it in the query:
AS awaydate,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar

if this query is run by a script, you have to find where and then add the , where i put it

[Peace]

Originally posted by Xenon
then you cant insert into the user table gender=...., you have to insert this value in the userfield table

I'm a newbie at this, what "value" do I insert, in the userfield table and is there a specific field I insert the vaule in?

[Xenon]

the value Gender is just the name of your field, but not the tablename of you DB, it should be something like field5='male' or something

[Peace]

I reinstalled the forum again and I will start over. :cross-eyed: