New site SQL Error : 1054 Unknown column

Mod that adds a extra field to the users profile, the gender is displayed beside the posts

Moderator: Moderators

Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

New site SQL Error : 1054 Unknown column

Postby DragonMaster on Wed 17. Nov, 2004 20:35

I have just installed the gender mod on a new phpBB 2.0.10 installation and it was done with Easy Nod. Nothing else was installed except the flags and then after gender the gender_require_0.9.1emc

Now I get this error and I am unable to update any profile as the gender is required and nothing is allowed to be changed.

Can you help me with this please?


SQL Error : 1054 Unknown column 'user_gender' in 'field list'
UPDATE phpbb_users SET user_email = 'tzap@earthlink.net', user_icq = '', user_website = '', user_occ = '', user_from = '', user_from_flag = 'blank.gif', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = -5, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 1, user_active = 1, user_actkey = '', user_gender = '1' WHERE user_id = 2
Line : 479
File : /home/ronnieja/public_html/test-1dio/includes/usercp_register.php
DragonMaster
Poster
Poster
 
Posts: 18
Joined: Wed 08. Sep, 2004 02:11

Postby kooky on Wed 17. Nov, 2004 21:55

it's a common error, with a little search you would have found it ;)

run gender_db_update.php (and read install.txt about SQL queries)
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Postby DragonMaster on Wed 17. Nov, 2004 22:29

Thanx.

I am currently reinstalling the entire site and starting over and adding this one first....and HOPING it will work well then.
DragonMaster
Poster
Poster
 
Posts: 18
Joined: Wed 08. Sep, 2004 02:11

Postby DragonMaster on Wed 17. Nov, 2004 23:10

It works now, but when I added the gender required mod nothing happens when anyone resisters. It allows any to do so with no action when no gender is not selected. It also does not have a gender required notice on this board listed. I used EM to install this. Any ideas for this please?
DragonMaster
Poster
Poster
 
Posts: 18
Joined: Wed 08. Sep, 2004 02:11

Postby kooky on Thu 18. Nov, 2004 18:06

DragonMaster wrote:It works now, but when I added the gender required mod nothing happens when anyone resisters. It allows any to do so with no action when no gender is not selected. It also does not have a gender required notice on this board listed. I used EM to install this. Any ideas for this please?
Gender required addon isn't included in original mod
there is a sticky about this one
you need to download it and install it like you did with Gender Mod

i fixed download link, so it should work ;)
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Postby DragonMaster on Thu 18. Nov, 2004 20:31

I missed seeing it as a button in the ACP set up.

Now my gender icons quite showing?
Any idea how to get them back?

They are in the right folder but all I get now is a missing icon and they used to work


I fixed this.
I found that EM did nor do the code right in my subBlack

All appears to be working right now.
Thanx
DragonMaster
Poster
Poster
 
Posts: 18
Joined: Wed 08. Sep, 2004 02:11


Return to Gender [2.0.10/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron