Custom Profile Fields

Post any general problems, information or issues on ModphpBB3 in here.
Post Reply
User avatar
uk_martin
Forum Member
Forum Member
Posts: 85
Joined: Fri Jan 30, 2009 2:49 pm

Custom Profile Fields

Post by uk_martin »

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
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: Custom Profile Fields

Post by LDM »

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.
User avatar
LDM
Site Admin
Site Admin
Posts: 1786
Joined: Thu May 29, 2008 6:51 pm

Re: Custom Profile Fields

Post by LDM »

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.
User avatar
uk_martin
Forum Member
Forum Member
Posts: 85
Joined: Fri Jan 30, 2009 2:49 pm

Re: Custom Profile Fields

Post by uk_martin »

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... :cray: )
Post Reply