ModphpBB3 Community Forum

Posted: **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

Posted: **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.

Posted: **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.

Posted: **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...

)

ModphpBB3 Community Forum

Custom Profile Fields

Custom Profile Fields

Re: Custom Profile Fields

Re: Custom Profile Fields

Re: Custom Profile Fields