Pages

Your Ad Here

This Blog is not to read or go through

because, I have never been such a mess


Search the blog instead

Saturday, December 19, 2009

Zenphoto Version differences




After upgrading from zenphoto 1.2.3 to 1.2.7 through .4,.5,.6 there was a problem.

My Images and Albums tables were gone blank . Thanks to God that I had saved a backup for this.

...

Major Differences are here.

a)
Images table has not lots of modification in its structure. Addition of fields was not a concern. However there was a field which was removed in the latest version. It was ExifValid field. So, to import from the previous version to the current one, I had to remove that field and import.
Query - ALTER TABLE `prefix_images` DROP `EXIFValid`

Yes, it was imported.

b) Albums table was imported easily.

c) Every other tables were OK.

d) There was one thing more added to the zenphoto core, it was zenpage_pages
....

Everything was fine, but still I could not see any albums in the gallery. It showed the number of images, but in Gallery it was 0.

The problem was, it was fetching images from the default albums folder, but not from the custom folder.

And the BULLSHIT Happened..
It removed all the previous information. The description of images, and all.



Findings
a) config file was moved.
One of the reason for not reading from custom folder was that Zenphoto added a new folder zp-data and the config file was there instead of zp-core/zp-config.php

And finally to import the original information.
a) Reconfigured the config file to point to custom album location
b) From Admin Refreshed the Database
c) Emptied albums and images tables from the Database
- this was required to reset the autoincrement
d) Pulled the albums database first
(the original information was restored)
e) Emptied the images table again
(because some images were already cached)
f) restored from the original database removing the field (EXIFValid) from the old table.


YES, It was finally Restored.

Thank you Zenphoto :) lol. (for atleast leaving some clues to fix, but not for anything else. ).

Total time taken - 40 minutes & 2 seconds

Source:
http://blogs.meronepalma.com

No comments:

Your Ad Here