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: Missing users  (Read 6548 times)

0 Members and 1 Guest are viewing this topic.

FBleu

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Posts: 133
Missing users
« 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
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Missing users
« Reply #1 on: December 04, 2010, 08:02:48 pm »

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

FBleu

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Posts: 133
Re: Missing users
« Reply #2 on: December 04, 2010, 08:32:03 pm »

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  :)
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Missing users
« Reply #3 on: January 19, 2011, 02:50:58 pm »

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).
« Last Edit: January 19, 2011, 02:56:43 pm by Αndré »
Logged

François Keller

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 9097
  • aka Frantz
    • Ma galerie
Re: Missing users
« Reply #4 on: February 27, 2011, 02:47:22 pm »

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

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Posts: 133
Re: Missing users
« Reply #5 on: August 01, 2011, 06:24:50 pm »

Hello  :)

Up

A solution ? :'(
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Missing users
« Reply #6 on: August 01, 2011, 06:47:31 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).
Logged

FBleu

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Posts: 133
Re: Missing users
« Reply #7 on: August 25, 2013, 10:00:45 am »

Hello André, with some delay ...

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

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Missing users
« Reply #8 on: August 26, 2013, 10:27:43 am »

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

FBleu

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Posts: 133
Re: Missing users
« Reply #9 on: August 26, 2013, 09:25:47 pm »

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

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15765
Re: Missing users
« Reply #10 on: August 26, 2013, 11:23:11 pm »

It's possible via a MySQL query. Something like
Code: [Select]
UPDATE cpg15x_users SET user_group = 2 WHERE user_group = 4should work.
Logged
Pages: [1]   Go Up
 

Page created in 0.033 seconds with 19 queries.