Recovery after bad upgrade : tables with a dot prefix are used instead

eiffell

Hi,

I've been using Zenphoto for several years. Yesterday I tried to upgrade from 1.4.2.4 to 1.4.5. The upgrade failed : I saw a lot of red cross after the process begun.

Then I tried to go back to 1.4.2.4. I bring back the directories and a database backup.

Then zenphoto ask me to run setup again. Ok : I copy setup.php and /setup directory from the sources. Before running setup everything seems to be corect, I only get a warning about the themes files that are not "presents" but they are.

Setup runs and finaly I get my site but with no meta-datas : title, comments, etc.

Looking at the database with phpmyadmin gave me the answer : during the re-setup launched by zenphoto 1.4.2.4 the tables have been prefixed with a dot : I got images and .images, albums and .albums.

The zenphoto site seems to use the dot prefixed tables, wich are empty (I mean, the album's titles are the directory names, etc). And, most amazing : the zenphoto.cfg says : $conf['mysql_prefix'] = ""; (To be honest it was once "." but I removed it and try the whole process again, and the variable remains empty).

What should I do to get my zenphoto using the good tables again ? Because if I delete the dot-prefixed ones, the whole process begins again : re-setup / duplication of tables / site up with no meta-datas.

Any idea or help ?

Thanks a lot.
Francois

Excuse me for my bad english...

eiffell

Breaking news :

I got a zenphoto.cfg in zp-core and one in zp-data.
Removing the dit in $conf['mysql_prefix] in zp-data solves the problem.

I have alose discovered a zenphoto.cfg.php in zp-data wich seems to be corupted. It begins like that :

$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "$conf['db_software'] = "<?php
global $_zp_conf_vars;
$conf = array();
/** Do not edit above this line. **/
/**********************************/

acrylian

Please take a look here as well:
http://www.zenphoto.org/support/topic.php?id=533750#post-725640

We generally recommend step by step upgrades. We primaril test 1.4.4 to 1.4.5 but not from older versions directly (although I did upgrade installs from 1.0.8.2 even successfully directly).

If things fail there should be errors in the logs.

I got a zenphoto.cfg in zp-core and one in zp-data.

The first is the template file to create the actual config file which is why it has a .txt suffix and the real one doesn't.

You should in any case update to 1.4.5.9.

eiffell

Thanks, finaly it's working.

I have removed the zenphoto.cfg.php and made an new update from 1.4.2 to 1.4.5.

This upgrade worked immediately. My feeling is that the first update failed because my web server was running an old php version (5.2). With php 5.4 the update was successful.

Now I can work on my photos and stay zen :-)

Francois