gender updating error.

[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()

[LDM]

Try this:

Code: Select all

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

[themandimi]

it worked. I just didnt know what field properties it had to have so yea...