Error after upgrade

ehm · June 8th, 2005, 11:42 PM

I upgrade from 5.1 to 5.11
But any photo/tumbnail is showing up.
All still on the folders, but there is none on the forum.
I SCAN DATABASE using all options there but no sucess.
Any idea?

When try to run the SCAN got like it:
Processing may take a while... please be patient and wait the for FINISHED message...

Finished!

click here to return to admin

Meaning it didn't find any photo.
I returned to 5.1 .php files but the same missing photos, so I re-upgrade to 5.11 again and the situation now is that there is no photos at all on the PhotoPost, but all picctures still on my server.

Chuck S · June 9th, 2005, 05:40 AM

This means that in the upgrade to 486 to 5 when picture names are rewritten step 3 was ran twice resulting in the userid being prepended twice since that step was ran more than once.

You would need to restore a backup of the photos table and run through the upgrade process again to get those photos back up

ehm · June 9th, 2005, 12:54 PM

Thank you Omegatron,
Now, I do have a backup I did before the upgrade, but I have no idea how to use it.
Which file is the one I have to restore, and how do I do it?
Below is the file list from my backup:
06/08/2005 08:38 PM <DIR> .
06/08/2005 08:38 PM <DIR> ..
06/08/2005 11:20 PM 160 pi_admingroups.sql
06/08/2005 11:20 PM 155 pi_admlog.sql
06/08/2005 11:20 PM 159 pi_categories.sql
06/08/2005 11:20 PM 157 pi_comments.sql
06/08/2005 11:20 PM 155 pi_ecards.sql
06/08/2005 11:20 PM 153 pi_exif.sql
06/08/2005 11:20 PM 160 pi_extrafields.sql
06/08/2005 11:20 PM 158 pi_favorites.sql
06/08/2005 11:20 PM 156 pi_ipcache.sql
06/08/2005 11:20 PM 157 pi_iponline.sql
06/08/2005 11:20 PM 155 pi_laston.sql
06/08/2005 11:20 PM 155 pi_notify.sql
06/08/2005 11:20 PM 160 pi_photoextras.sql
06/08/2005 11:20 PM 155 pi_photos.sql
06/08/2005 11:20 PM 159 pi_photoviews.sql
06/08/2005 11:20 PM 157 pi_settings.sql
06/08/2005 11:20 PM 153 pi_sort.sql
06/08/2005 11:20 PM 157 pi_sortmemb.sql
06/08/2005 11:20 PM 159 pi_usergroups.sql
06/08/2005 11:20 PM 154 pi_users.sql
20 File(s) 3,134 bytes
2 Dir(s) 4,791,255,040 bytes free

Thank you

Chuck S · June 9th, 2005, 02:04 PM

Okay you would drop the pi_photos table in the database and restore this backed up table

pi_photos.sql

ehm · June 9th, 2005, 04:05 PM

Would you mind to give me a longer 'step by step' on how to do it?
I do have 'MyPHP' software installed and working. But I don't know how to do the instructions you post here... sorry

I will learn if you give some more help.

Thank you
Elton

Chuck S · June 10th, 2005, 08:59 AM

I dont know how much longer to explain it. Use the steps I noted above.

To drop a table you check it and down the bottom under the checks is a select box and you can select drop.

Then when viewing the database there is a link up top that says sql. FROM there you would enter the contents of the sql or there is a browse and submit button on the sql page to upload an sql file. You would update just the photos one.

ehm · June 10th, 2005, 09:15 PM

OK. Got it, but now there is an error and the table is not created:

pi_photos restore error Failed copying .frm file

?

Chuck S · June 10th, 2005, 09:16 PM

A backup of the mysql table is an sql file not frm file. frm seems like a file directly on the server. You can try copying that to the mysql directory on the server but doubt that would work as it is going to need the associated files that goes with it

They would be pi_photos.MYD and pi_photos.MYI

So you would copy all 3 of those tables to the database area on the server

ehm · June 10th, 2005, 09:48 PM

I'm giving up on the backup...

I installed the new version 5.11, and try to do a backup again, since I start suspection that the 'backup' function is not working (never worked here as far as I can guess).

Then, I click on the BACKUP link to backup on file, and nothing happens. The screen flick like reloading but nothing happens. File does't goes to the directory.
This is te path:
/usr/local/etc/httpd/htdocs/imigrar/photo/backup/bkp2/
I also used
/usr/local/etc/httpd/htdocs/imigrar/photo/backup/bkp2

the directory has rwrwrw all way down.

The directory to mysqldump is right too.

What could be wrong?

ehm · June 10th, 2005, 09:52 PM

Complement the previus post:
I try to backup the pi_comments table mannualy, and received this error:
pi_comments backup error Failed copying .frm file: errno = 2
photoIM.pi_comments backup status Operation failed

Chuck S · June 11th, 2005, 09:05 AM

first off the backup program will create sql files.

The backup program lists the database tables and we create a backup sql file of that table.

You would create a backup directory and make it 777. Then the full server path to mysqldump which resides on the same server as photopost and you should be able to use backup. Otherwise PM me admin login so I can see exact error or list here.

Your more looking like you have a corrupted database more and more each time.

ehm · June 14th, 2005, 12:22 PM

I gave up Omegatron.
Just erased all data and I'm installing it again...
I hope it will work today.