View Full Version : PP_photos record got deleted during upgrade
February 26th, 2012, 11:38 AM
hi , i upgraded from 7.0 to 8.01 when i upgraded i had the 8.01 directory has different and that had gone as the directory for the data where the photo will be stored , what happened is when i did scan database , it went and looked for the photos in those directory and it was not found as the orginal directory was under gallery , so all the record under pp_photos got deleted , but the photo under data directory in the original gallery is there , now think i need to have all the records in pp_photos for the image to show in the website , is there any way i can rebuild the pp-photos table through script or anything , i fixed everything now its in 8.01 and i uploaded a new photos its working now , but old photos have to be showed now , please help here.
February 26th, 2012, 03:09 PM
An upgrade has nothing to do with photos disappearing at all.
Your issue is you yourself moved directories so in essence you changed the data directory where your photos are stored and never updated your actual photopost to the new changed paths. Therefore when you ran a scan database without fixing your path you where telling the program wrong server pathing and since it did not find the photos it correctly deleted any entries it could not find from the database. That is proper program operation.
We all learn from mistakes and its an easy fix. The correct action would have been correct and verify any server paths before you ran a scan database. If that had been done your photos would have shown.
The way to fix your issue would be to simply restore a backup of your pp_photos table from an sql backup you have done. All your photos would then show.
February 26th, 2012, 09:52 PM
ya i understand , i verified all path through the admin screen but there was 2 field which was showing only in Table and i have to go and update it thr which i did and then the path [problem got fixed , anyway got the backup from the providers will try to restore the table and see.
February 27th, 2012, 06:23 AM
Not a problem pretty cut and dry issue.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.