Apparently we have lost all of our photos...???

[Sonnie]

On March 16, I upgraded to 6.02 and reviewed our Photopost Image Gallery. All was well with the photos and thumbnails.

Today I get several members asking me where their photos are. There was showing the NO THUMBNAIL image for all of the images and none of the large images were showing at all.

I go into the Admin area and decide to Scan the Database as follows:

• Check for and create missing thumbnails.
• Rebuild all thumbnails.
• Rebuild all medium images.

After it finishes, this is what I got a page full of... this is merely the last line:

Checking photo #1108: image /home/homethea/public_html/photopost/data/500/11879theatersetupnew.jpg not found, removing from database... done.

Now we do not even have the NO THUMBNAILS image in the gallery... it appears all photos are gone.

Although it shows on the Home page there are 921 photos, I do not see any.

What could possibly be happening? Where are our images?

I can still see images under the Data folder on our ftp server. The image above that states it is not found is listed on the server under the 500 folder, just like it is supposed to be.

[Chuck S]

Posting a link would help but I would think possibly your host changed server paths and you did not update the paths in global and storage options in admin.
If you ran scan database with a bad path entered you would essentially delete all photo entries in the database

Correct you path as noted above then restore a backup of the photos table and you should be fine.

[Sonnie]

Here is a link to our Image Gallery.

Our server path is as follows:

/home/xxxxxxxxxxxxx/public_html/photopost/data/

This does not appear to have changed.

As stated previously... I still see images under our data folder. Most of them are in the data/500 folder.

[Sonnie]

No paths have been changed. I just uploaded an image and it shows fine.

I just need to figure out how to get all those images in the data folder back into our photopost Image Gallery and under the appropriate user names.

Can this be done?

[Chuck S]

You path had to be wrong for them to be deleted using the admin tool.

To get images back you would need to restore a backup of your photos table from your photopost database.

[Sonnie]

Like I said... the path has not changed. It has been the same since day one. There must be a glitch in the software.

Does Photopost create a backup somewhere?

We do not have a separate database specifically for Photopost... we use the forum database and I am not about to restore it to a previous date.

[Chuck S]

Part of normal site maintenance is backups you would make. If you have a backup of the database all you need to do is restore the photos table if you pm me the correct server login and location of a database backup I can try and assist.

[Sonnie]

Yes... we make daily backups of the entire forum.... actually our entire site of which the forum is a part of. This is backed up off site by our dedicated server management support. It looks something like...

/backup/cpbackup/daily/homethea.tar.gz

I know it grabs the database in the process.

I will have to find out where it is located, but I do know it does it daily because I get an email confirming it is done.

Can you tell me exactly what we are looking for and I can get them to send me what we need. Maybe they can extract that particular tables part for us.

[Sonnie]

Hey Chuck...

Our management team has extracted the database from our forum, but it was from 3/30/08. I wanted to go back to about the 28th, which is when the last photo was uploaded and I am fairly certain all was okay at that time. So I have asked them to extract that date for us. I will let you know once this is done and get with you on login details to see if you can extract the photo tables from that database. The main thing is I do not want to restore the entire forum database and lose all of our posts for the last few days.

Thanks!

[Chuck S]

Yeah thats why I said you only want to restore the entries to the photos table. Simply put you just take the inserts from the photos table in your database backup and use phpmyadmin in your control panel of the server to reinsert them. Really thats all their is to it. There is a way to do it via ssh but alot of people dont have shell access so most all people have a database viewer via their web control panel.

[Sonnie]

I am still waiting on my server techs to extract the backup. All we had was the 30th for a daily backup, which I am not sure if the problem existed at that time, so I would rather use one a few days older. We have a weekly backup from 3/27 that they are going to extract the MySQL from and place it on the server.

[Chuck S]

Okay no problem yeah as noted they can reinsert the photos table inserts or you can send me the access to try

[Sonnie]

Just sent you a PM with the info if you would please help us.

Thanks!

[Chuck S]

I sent you a reply that you need to address. I see no photopost database backups where you say they are hense there is no way to restore anything.