Print

[Tunnelrat]

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:

While 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

[DJMaze]

Change "nuke_users" into your users tablename and run these 3 queries on your nuke database

Code: [Select]

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';