Missing users

[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é]

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 Expand

# 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

[FBleu]

Hello 

Up

A solution ? :'(

[Αndré]

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

Code Select Expand

UPDATE cpg15x_users SET user_group = 2 WHERE user_group = 4
should work.