forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: Yukino on September 15, 2005, 03:32:48 am

Title: Usermanger help!?!?!
Post by: Yukino on September 15, 2005, 03:32:48 am

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?

Title: Re: Usermanger help!?!?!
Post by: Nibbler on September 15, 2005, 03:39:56 am

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

Title: Re: Usermanger help!?!?!
Post by: Yukino on September 15, 2005, 03:58:26 am

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
 

Title: Re: Usermanger help!?!?!
Post by: Nibbler on September 15, 2005, 04:03:12 am

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

Title: Re: Usermanger help!?!?!
Post by: Yukino on September 15, 2005, 04:07:05 am

that's the only way to fix it?

Title: Re: Usermanger help!?!?!
Post by: Nibbler on September 15, 2005, 04:10:54 am

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