Users missing from user list! Urgent!

[harmanhoog]

My classes are about to start so I must get this fixed. Some time today, my user list shrunk from showing a hundred or more users to showing only a half dozen. It shows that there are about 10 pages but no other names pull up or are returned on a search and yet if I try entering a username that used to be listed, I get an error message that the username already exists. I have the latest version. Most of the albums that were there are also missing. It is the usernames I was most concerned about as I am setting up new albums anyway,

Thanks Diane

[Joachim Müller]

Post a link to your gallery for a start. Attach a screenshot of the memberlist to your posting. Use a third-party tool like phpMyAdmin, browser the users table and make sure that the table is populated as expected.

[Nibbler]

Make sure any custom groups you have created are still there.

[harmanhoog]

All the custom groups are also missing as suggested.

link http://www.quilterskeeplearning.com/public_html/index.php
login mycolors password rpassing

I am just FTPing PhpAdmin to my server now. I do not know how to use it or what to look for.

I have attached a screen cap of all I see when I call up user

Thanks,

Diane

[Nibbler]

You need to recreate the groups. If you have a backup of the groups table then great. If not, re-create them in the same order as before, otherwise you'll need to play about in phpmyadmin. You haven't lost anything important though.

[harmanhoog]

I have a back up of the whole directory, but I cannot find instructions on how to restore the application from a backup. Or even a table. Thanks so much for reminding me.

[Nibbler]

It's not in the Coppermine directory; it's in the database. You need to have a database backup to be able to restore the groups table.

[harmanhoog]

I do not have that backup. i do have a list of the groups, but  I choose Add a New Group and type in the name and then the modification disappears after I try to add it. Can I just nuke the data and start over. That seems like the fastest repair at this point

[harmanhoog]

I was just able to get into PHPadmin. All my users (172) are there. All my albums are there. Groups are missing, although I know what they were as they were the same as the album names.

[maxymalny]

Check this out: http://forum.coppermine-gallery.net/index.php/topic,31456.msg246710.html#msg246710 - I had a similar problem, but if you have 172 users, my solution can be to havy for you...

[harmanhoog]

Thanks very much. I discovered that the user table has the number of the group in it and I am able to identify the group name by that so I am going to insert records for the groups and see how it goes. I have only lost a little data entry time if it does not work.

I appreciate all the help

[topmmc]

You need to recreate the groups. If you have a backup of the groups table then great. If not, re-create them in the same order as before, otherwise you'll need to play about in phpmyadmin. You haven't lost anything important though.

Nibbler, thanks....I had this same issue and this post corrected it.  Thanks again

[Joachim Müller]

Locking