Post any general problems, information or issues on ModphpBB3 in here.
uk_martin
Forum Member
Posts: 85 Joined: Fri Jan 30, 2009 2:49 pm
Post
by uk_martin » Mon Mar 02, 2009 9:35 pm
Hi
I just tried changing some profile info, in a field that formed part of the built-in Custom Profile Fields section. Sadly I got this error:
Code: Select all
SQL ERROR [ mysql4 ]
Unknown column 'user_gender' in 'field list' [1054]
SQL
UPDATE phpbb_users SET user_icq = '', user_aim = '', user_msnm = '', user_yim = '', user_jabber = '', user_website = 'http://www.brummiesfans.com', user_from = 'Birmingham', user_occ = 'Web Site Administrator', user_interests = 'Rugby Photography Speedway', user_birthday = '18-11-1961', user_gender = NULL WHERE user_id = 2
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/acp/acp_users.php
LINE: 1155
CALL: dbal_mysql->sql_query()
FILE: includes/functions_module.php
LINE: 507
CALL: acp_users->main()
FILE: adm/index.php
LINE: 76
CALL: p_master->load_active()
If it helps at all, as part of the info that I was changing, I was altering the gender from not specified to Male.
Any idea what the problem may be and how to fix it?
Thanks
Martin
LDM
Site Admin
Posts: 1786 Joined: Thu May 29, 2008 6:51 pm
Post
by LDM » Mon Mar 02, 2009 9:54 pm
I have seen this on another forum Martin and thought the newer version of the genders mod (cause thats where the error is coming from) that was added didn't have that bug.
I will re-trace the fix I put on the other forum and post it.
LDM
Site Admin
Posts: 1786 Joined: Thu May 29, 2008 6:51 pm
Post
by LDM » Tue Mar 03, 2009 1:10 am
martin, did it do what you wanted after the error or did the error stop your request?
Edit: I actually think yours could be different but try this in this topic
http://www.modphpbb3.com/viewtopic.php? ... 026&p=2234 and we can rule that out.
uk_martin
Forum Member
Posts: 85 Joined: Fri Jan 30, 2009 2:49 pm
Post
by uk_martin » Tue Mar 03, 2009 7:18 am
Hi
That was the fix that was needed. It all works fine now.
Thanks again
Martin
p.s. (now to MANUALY! amend about 250 users worth of Custom Profile Fields that didn't migrate over from my old board in the conversion...
)