Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Problems with Users  (Read 3214 times)

0 Members and 1 Guest are viewing this topic.

Tunnelrat

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Problems with Users
« 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:

Quote
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
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Problems with Users
« Reply #1 on: December 16, 2003, 05:29:26 am »

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';
Logged
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
Pages: [1]   Go Up
 

Page created in 0.013 seconds with 20 queries.