coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: harmanhoog on April 09, 2008, 05:35:40 AM

Title: Users missing from user list! Urgent!
Post by: harmanhoog on April 09, 2008, 05:35:40 AM
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
Title: Re: Users missing from user list! Urgent!
Post by: Joachim Müller on April 09, 2008, 07:58:34 AM
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.
Title: Re: Users missing from user list! Urgent!
Post by: Nibbler on April 09, 2008, 10:36:29 AM
Make sure any custom groups you have created are still there.
Title: Re: Users missing from user list! Urgent!
Post by: harmanhoog on April 09, 2008, 07:02:21 PM
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
Title: Re: Users missing from user list! Urgent!
Post by: Nibbler on April 09, 2008, 07:07:45 PM
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.
Title: Re: Users missing from user list! Urgent!
Post by: harmanhoog on April 09, 2008, 07:57:24 PM
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.
Title: Re: Users missing from user list! Urgent!
Post by: Nibbler on April 09, 2008, 07:59:39 PM
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.
Title: Re: Users missing from user list! Urgent!
Post by: harmanhoog on April 09, 2008, 08:34:48 PM
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
Title: Re: Users missing from user list! Urgent!
Post by: harmanhoog on April 09, 2008, 08:45:18 PM
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.
Title: Re: Users missing from user list! Urgent!
Post by: maxymalny on April 09, 2008, 09:36:25 PM
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...
Title: Re: Users missing from user list! Urgent!
Post by: harmanhoog on April 10, 2008, 12:07:40 AM
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
Title: Re: Users missing from user list! Urgent!
Post by: topmmc on December 11, 2008, 07:21:33 PM
Quote from: Nibbler on April 09, 2008, 07:07:45 PM
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
Title: Re: Users missing from user list! Urgent!
Post by: Joachim Müller on December 18, 2008, 10:21:28 AM
Locking