coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: Tunnelrat on December 16, 2003, 03:21:53 AM

Title: Problems with Users
Post by: Tunnelrat on December 16, 2003, 03:21:53 AM
I created a group and when clicking on users in the coppermine admin panel and then select a user to add him to a group, i get the following error message:

QuoteWhile executing query "SELECT username, user_active_cp, user_group_cp, user_group_list_cp FROM nuke_users WHERE user_id = '654'" on 0

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

Does anyone know a solution? I'm not that firm with php and mysql, so I didn't get the clue out of this message.


Thanks
Title: Problems with Users
Post by: DJMaze on December 16, 2003, 05:29:26 AM
Change "nuke_users" into your users tablename and run these 3 queries on your nuke database

ALTER TABLE nuke_users ADD user_group_list_cp VARCHAR(100) DEFAULT '2' NOT NULL AFTER user_group_cp;
UPDATE nuke_users SET user_group_cp = '3', user_group_list_cp = '3' WHERE user_id = '-1';
UPDATE nuke_users SET user_group_cp = '3', user_group_list_cp = '3' WHERE user_id = '1';