Missing users Missing users
 

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]

Main Menu

Missing users

Started by FBleu, December 04, 2010, 06:41:27 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

FBleu

Hello  :)
CPG 1.4.27 / 1.5.10

the number of users is not correct !


The banned users in CPG 1.4.27 don't are more apparent in CPG 1.5.10 while they are still counting
http://www.lien-d-amis.net/test1427/usermgr.php

cordially

Αndré

Please elaborate. You had banned users. What exactly happened with them?

FBleu

In CPG 1.4.27
I was 6 users in User manager

2 Administrator
2 Registered
2 banned


I did a updated 1.5.10


in the user manager is displayed
2 administrator
2 registered

It lacks the banned
They are not visible in the page Ban Users

For cons, the number on the bottom left of the user management page is correct, since the figure is 6  :)

Αndré

#3
Do you remember how you banned that users? Did you used the ban form (banning.php) or do you put those users into the user group 'Banned'?

I guess those users where in the user group 'Banned' which doesn't exist anymore.
Code (sql/update.sql) Select
# Remove the group "Banned", as it never was used anyway
DELETE FROM CPG_usergroups WHERE `group_name` = 'Banned';

Have a look at your database (use a tool like phpMyAdmin). I assume the users resides in the user group id '4' (which was the default id for the banned group prior to cpg1.5.x).

François Keller

Fbleu asked me to try to expalin the problem:
case 1:
In cpg1.4.27, users where banned only by editing theire profile to put the users in the banned group.
After upgrade to cpg 1.5.x, the banned users are not visible in the user manager, nor after clocking on the "banning users" buton on the admin menu

case 2:
In cpg 1.4.27, some users where banned by editong theire profile, and some using the "banning users" buton on the admin menu
After upgrade to cpg 1.5.x, all users are displayed in the user manager and the banned users are visible in the banned list
Avez vous lu la DOC ? la FAQ ? et cherché sur le forum avant de poster ?
Did you read the DOC ? the FAQ ? and search the board before posting ?
Mon Blog

FBleu

Hello  :)

Up

A solution ? :'(

Αndré

Quote from: Αndré on January 19, 2011, 02:50:58 PM
Have a look at your database (use a tool like phpMyAdmin). I assume the users resides in the user group id '4' (which was the default id for the banned group prior to cpg1.5.x).

FBleu

Hello André, with some delay ...

Yes
I assume the users resides in the user group id '4' of the table "user"

Αndré

I suggest to either delete them from the database or adjust their group_id to a valid value, like "2" (Registered users).

FBleu

It is not possible switch automatically Coppermine 1.5.26/1.5.28 user_group "4" of the table users in the table banned ?

In french
Il n'est pas possible que Coppermine 1.5.26/ 1.5.28 transfert automatiquement les user_group "4" de la table users dans la table banned ?

Thank you André

Αndré

It's possible via a MySQL query. Something like
UPDATE cpg15x_users SET user_group = 2 WHERE user_group = 4
should work.