Problems with Users Problems with Users
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Problems with Users

Started by Tunnelrat, December 16, 2003, 03:21:53 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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:

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

DJMaze

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';
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0