Reinstall and keep albums?

klikini

My ZenPhoto installation is *seriously* corrupted (files in the wrong places, 404s and 500s, etc) and I need to uninstall and start over. However, I don't have copies of my photos anywhere else, and I have too many to upload and sort again anyway. Is there a way to save my photos/albums/photo names/etc and use it in a new installation on the same server? I'm going to uninstall ZP and all ZP files, then reinstall.

What do I need to do to save this (download SQL databases, folders, etc)? I have both FTP and SSH access to this HostGator server.

Thanks!

sbillard

If you are going to re-install in the same folder structure as before things are quite simple. Leave your albums folder intact.

Make careful note of all the MySQL details from your configuration file--these are how you connect back to the database without loosing any data. You will provide this information to the setup program when you re-install Zenphoto.

If anything in your file or WEB structure is changing your best bet is to create a Zenphoto backup of your site database via the backup/restore utility. Use FTP to download that and the content of your albums folder. You will still need the above MySQL information for later application. But note that the setting for `mysql_host` may need to be changed if the server configuration is different from the old install location. Ask your host provider.

Install Zenphoto in the new location then FTP your saved albums content back to the albums folder and your saved backup to the backup folder. Run the restore function on the saved backup.

Please note that we recommend that you use the same version of Zenphoto for the re-install as you had when you made the backup. If you intend to upgrade, do that as a later step.

klikini

I cannot access the ZenPhoto interface (that's where the backup option is?) because of the corruption. I will copy the albums folder and database instead, because it will be in the same place (site root).

klikini

I moved the albums folder and saved the database, deleted all ZP files, and reinstalled. Then I put the folder back in. Now I'm having cache and file permission issues (database is corrupted because the album and image IDs changed). Is there a way to purge the database and start completely over? I don't want to reupload everything, so can I copy the albums folder to a new location (outside the www folder) and then put the images back with FTP? This will remake the database, right? I though that you could upload images with FTP and it would make DB entries, correct?

acrylian

Yes, Zenphoto will create database entries if uploading via FTP on discovery. If you don't use the db backup tool to re-setup your database you will not get all data you may have entered like titles. Those will be lost. See the installation page on the user guide about that.

Zenphoto will sync the database with the filesystem. You can request that by using the "refresh database" button on the admin overview.

The database has nothing to do with your file/folder permission issues.

klikini

The titles and such were already lost in the reinstall. The permissions were because I had been working on another site with full access defaults, so I set FileZilla to default to full permission, and then the error log said it couldn't access some cache files after I fixed it.

I have already tried refreshing the database. I'll try zipping up each album's images and moving them somewhere else, and then FTPing them back.

Here goes.

klikini

More permission problems. What should the chmod values on photos/cache be? Right now they're 644, and all that shows up on the site is the link to the photo. This is what is in the error log (for all of the photos):

`[Sat Aug 03 16:30:03 2013] [error] [client ***.***.***.***] (13)Permission denied: file permissions deny server access: /home3/klikini/public_html/cache/around-the-house/pianohammers_100_cw100_ch100_thumb.png, referer: http://www.snaperturephotos.com/index.php?album=around-the-house/`

Also, my albums keep going away! I check the permissions and nobody has read access. What's up with this?

fretzl

http://www.zenphoto.org/news/permissions-for-zenphoto-files-and-folders

klikini

Here's my site: http://www.snaperturephotos.com/

The pictures don't show up. Clicking on the individual image page doesn't work, either.

Gallery (Broken) http://www.snaperturephotos.com/

Album (Broken) http://www.snaperturephotos.com/index.php?album=around-the-house/

Image (Broken) http://www.snaperturephotos.com/index.php?album=around-the-house&image=12ball.jpg

Unrelated but true: I used to be able to use jQuery upload with PHP 5.2.17, but now I can't because it requires a newer PHP version. What changed, and can I get the old version?

acrylian

Well, as your error above indicates file/folder permission issues. Fretzl above posted what they should be. But that does not mean those work on all servers. You might have to lower the rights.

You should not mix issues within one topic (same for tickets on the issue tracker). I was not aware that the php requirements changes. But if you have permission issues you likely cannot use the upload as well.
You can try to use the old version from an older Zenphoto. But that is not tested and can cause other issues.

klikini

I upgraded PHP to 5.3 and now it works. I opened a new thread for the images not working. Thanks all for the help with the website being down!

Now to get it fixed.

acrylian

I had looked on its page and could not find anything regarding php 5.3 only. But since that is the current version and 5.2 reached end of support (and most hosts switching) that is most likely to happen soon anyway.

sbillard

There are some bugs in PHP 5.2 that prevent some plugins from defining filters.