Page 1 of 1

gender updating error.

Posted: Thu Jan 29, 2009 9:34 pm
by themandimi
I got this error message. Anyone know what the sql is for adding the user_gender field in the database?

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_gender' in 'field list' [1054]

SQL

UPDATE phpbb2_users SET user_icq = '', user_aim = '', user_msnm = '*', user_yim = '', user_jabber = '', user_website = '', user_from = '', user_occ = '* = '', user_gender = NULL, user_birthday = ' *' WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_profile.php
LINE: 382
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: ucp_profile->main()

FILE: ucp.php
LINE: 330
CALL: p_master->load_active()

Re: gender updating error.

Posted: Thu Jan 29, 2009 10:16 pm
by LDM
Try this:

Code: Select all

ALTER TABLE phpbb_users ADD user_gender TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;

Re: gender updating error.

Posted: Sat Jan 31, 2009 9:14 am
by themandimi
it worked. I just didnt know what field properties it had to have so yea...