forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: FBleu on December 04, 2010, 06:41:27 pm
-
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
-
Please elaborate. You had banned users. What exactly happened with them?
-
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 :)
-
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.
# 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).
-
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
-
Hello :)
Up
A solution ? :'(
-
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).
-
Hello André, with some delay ...
Yes
I assume the users resides in the user group id '4' of the table "user"
-
I suggest to either delete them from the database or adjust their group_id to a valid value, like "2" (Registered users).
-
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é
-
It's possible via a MySQL query. Something like
UPDATE cpg15x_users SET user_group = 2 WHERE user_group = 4should work.