Piwigo.org

lcavalie · 2010-07-13 22:03:01

I was upgrading from 2.0.3 to 2.1.2 and I got a bad crash.
I did the auto upgrade and during step 3 I got a message

your MySQL version is too old, you have "4.1.25-Debian_mt1" and you need at least "5.0.0"

#1 pwg_db_check_version /nfs/c03/h03/mnt/54220/domains/mindworkscreation.com/html/galleries/admin/include/functions_upgrade.php(255)
#2 upgrade_db_connect /nfs/c03/h03/mnt/54220/domains/mindworkscreation.com/html/galleries/upgrade.php(207)

Now my installation is screwed up which is not good as it is the production one.

What can I do?

Thanks for the rescue.

plg · 2010-07-13 22:17:48

very easy fix but then Piwigo is not supposed to work perfectly (because you don't have the requirements):

open include/dblayer/function_mysql.inc.php, line 25, replace

Code:

define('REQUIRED_MYSQL_VERSION', '5.0.0');

by

Code:

define('REQUIRED_MYSQL_VERSION', '4.1.0');

and reopen upgrade.php in your web browser

lcavalie · 2010-07-13 22:28:31

Quite easy indeed.
I try that.
What kind of problem may I anticipate ?

plg · 2010-07-13 22:31:25

lcavalie wrote:
What kind of problem may I anticipate ?

We now consider MySQL 5.0 as a minimum requirement. Some SQL requests may not work with MySQL 4.1 (or work differently). You should not encounter many problems but ask your web hosting provider to upgrade to a recent MySQL version if possible.

lcavalie · 2010-07-13 22:37:48

Just hangup with them and they are starting the upgrade.
I should have MySQL 5 very soon.

Can I just resume the upgrade of piwigo at step 3 of the auto-upgrade?

L

plg · 2010-07-13 22:38:47

lcavalie wrote:
Can I just resume the upgrade of piwigo at step 3 of the auto-upgrade?

Yes, open upgrade.php in your web browser.

lcavalie · 2010-07-13 23:44:35

all right!
I completed the upgrade to MySQL 5 and the upgrade to 2.1.2
Reinstalled my old theme modified to work with 2.1.x
and everything is fine.

Just a few plugins details but it works fine.

May I suggest testing the requirements like MySQL 5 before starting to do something.

Silly stuff is that installed another instance of piwigo to test live before the upgrade but I installed it on another hosting environment which had MySQL 5 already.

Anyway, great support agaiin, much appreciated.

L

Piwigo.org

Announcement

#1 2010-07-13 22:03:01

[resolved] Crash during autoupgrade

#2 2010-07-13 22:17:48

Re: [resolved] Crash during autoupgrade

Code:

Code:

#3 2010-07-13 22:28:31

Re: [resolved] Crash during autoupgrade

#4 2010-07-13 22:31:25

Re: [resolved] Crash during autoupgrade

lcavalie wrote:

#5 2010-07-13 22:37:48

Re: [resolved] Crash during autoupgrade

#6 2010-07-13 22:38:47

Re: [resolved] Crash during autoupgrade

lcavalie wrote:

#7 2010-07-13 23:44:35

Re: [resolved] Crash during autoupgrade

Board footer