Firefly, can you help me please?
 

Is this the gender hack mate?

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

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

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

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

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 ;)

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?

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

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