![]() |
|
Recovery after bad upgrade : tables with a dot prefix are used instead - Printable Version +- ZenphotoCMS Forum (https://forum.zenphoto.org) +-- Forum: Support (https://forum.zenphoto.org/forum-1.html) +--- Forum: General support (https://forum.zenphoto.org/forum-4.html) +--- Thread: Recovery after bad upgrade : tables with a dot prefix are used instead (/thread-11665.html) |
Recovery after bad upgrade : tables with a dot prefix are used instead - eiffell - 2014-03-02 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. Excuse me for my bad english... Recovery after bad upgrade : tables with a dot prefix are used instead - eiffell - 2014-03-02 Breaking news : I got a zenphoto.cfg in zp-core and one in zp-data. 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'] = " Recovery after bad upgrade : tables with a dot prefix are used instead - acrylian - 2014-03-02 Please take a look here as well: 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. Quote:I got a zenphoto.cfg in zp-core and one in zp-data. You should in any case update to 1.4.5.9. Recovery after bad upgrade : tables with a dot prefix are used instead - eiffell - 2014-03-02 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 |