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()
gender updating error.
-
- Forum Member
- Posts: 17
- Joined: Mon Jan 12, 2009 10:02 am
gender updating error.
I got this error message. Anyone know what the sql is for adding the user_gender field in the database?
Re: gender updating error.
Try this:
Code: Select all
ALTER TABLE phpbb_users ADD user_gender TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
-
- Forum Member
- Posts: 17
- Joined: Mon Jan 12, 2009 10:02 am
Re: gender updating error.
it worked. I just didnt know what field properties it had to have so yea...