Usermanger help!?!?!

[Yukino]

alright.  i upgraded to 1.4 but found it to be to buggy...

so then it replaced the files that i had saved from my 1.3 

but now when i go to the user manager to add users to other groups and i select the group that i want my users in then try to save it i get this

Critical error
There was an error while processing a database query 


heeeelp?!?!?!  how do i fix it?

[Nibbler]

Enable debug mode and post the mysql error message that you get when you replicate the error.

[Yukino]

ok with debug mode enabled when i do all that i get the following:

Critical error

There was an error while processing a database query.


While executing query "UPDATE cpg132_users SET user_name           = 'Tyrinn', user_email          = '', user_active    = 'YES', user_group           = '2', user_location  = '', user_interests = '', user_website          = '', user_occupation= '', user_group_list      = '6' WHERE user_id = '71'" on 0

mySQL error: Unknown column 'user_location' in 'field list'



File: /www/a/animeextreme/htdocs/imagegallery/include/functions.inc.php - Line: 105

[Nibbler]

Restore your database from the backup you made during the upgrade to 1.4

[Yukino]

that's the only way to fix it?

[Nibbler]

The other way is to reverse the database changes manually by inspecting sql/update.sql and applying the reverse operations to your database.