Codezwiz >> Forums >> General PHP Nuke Help >> gender mods on phpnuke 7.6 can't update profile

Dear all, i have this problem whenever i update the user profile so that the gender of the user will show... this shows up.... Please help someone...

Could not update users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_gender' in 'field list'

UPDATE nuke_users SET user_email = 'yanger@nagafairyusa.com', user_icq = '', user_website = 'http://www.nagasonline.com', user_occ = '', user_from = 'Nagaland', user_interests = '', user_sig = 'The world is full of people who are cribbing and self-seeking. So the rare individual who unselfishly tries to serve others has an enormous advantage. He has little competition.', user_sig_bbcode_uid = 'a1f3346933', user_viewemail = '0', user_aim = '', user_yim = '', user_msnm = '', user_attachsig = '1', user_allowsmile = '1', user_allowhtml = '1', user_allowbbcode = '1', user_allow_viewonline = '1', user_notify = '0', user_notify_pm = '0', user_popup_pm = '1', user_timezone = '6', user_dateformat = 'D M d, Y g:i a', user_lang = 'english', user_style = '1', user_active = '1', user_actkey = '', user_gender = '1' WHERE user_id = '28'

Line : 496
File : /home/naga/public_html/includes/usercp_register.php

My guess is... there could be something wrong with the .txt instruction here

#
#-----[ IN-LINE FIND ]------------------------------------------
#
$avatar_sql . "

#
#-----[ IN-LINE, AFTER, ADD ]------------------------------------------
#
, user_gender=$gender

Register

It looks like you have missed a database update. Look through your database and see if the field "user_gender" is in the "nuke_users" table.

If it isn't, you may need to run the database update from the install.

Dear Dauthus thank you so much for taking your time looking into my problem... yes i have installed the user_gender in my database.... i ran the sql query included and it said sql query runned successfully... but to be 100% sure let me check it out again... i will be back with the result... thank you again. God Bless you.

hello again Dauthus... am so sorry that i made this silly mistake taking your time to review into my problem... yes the mistake was with my database... instead of user_gender i put gender only on my database and that was the problem... thank you again... will be back if i have more problems... very kool staffs here...