Announcement

#1 2020-02-15 16:36:29

ecphotographer
Member
USA
1970-01-01
4

Accidentally deleting *All Users*

Hello/Hi/Greetings,

I was getting spam from the registration form and populating my user list. I went to filter the spam users in the following manner: 1) Selected the view to 25 users. 2) Selected all visible on the page (spam users), and delete all users. Somehow, ALL of my users other than my own account was deleted.

How might I restore the users so that I can try again? If not on piwigo, can I restore a php file or something?

Kind Regards,

Eric


Piwigo version: 2.9.5
PHP version: 5.6.40
MySQL version: 5.7.29-percona-sure1-log
Piwigo URL: http://photo.ericcurley.com

Offline

 

#2 2020-02-16 12:39:41

erAck
Only trying to help
2015-09-06
2026

Re: Accidentally deleting *All Users*

Restore the database from the last known good backup.


Running Piwigo at https://erack.net/gallery/

Offline

 

#3 2020-02-16 14:35:51

ecphotographer
Member
USA
1970-01-01
4

Re: Accidentally deleting *All Users*

Can we recommend are more specific restore?

I don't want to mess up a recent album upload of over 150 images.

E

Offline

 

#4 2020-02-17 02:25:37

erAck
Only trying to help
2015-09-06
2026

Re: Accidentally deleting *All Users*

Users are stored in the piwigo_users table (or with the prefix you chose during installation).


Running Piwigo at https://erack.net/gallery/

Offline

 

#5 2020-02-20 05:46:03

ecphotographer
Member
USA
1970-01-01
4

Re: Accidentally deleting *All Users*

Excellent! Thank you. That worked.

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact