failure upgrading 4.0.0 to 4.0.1 (postgresql)

Friday 28 November 2008 8:15:50 am

I <i>think</i> I have found a fix for this problem.

The last lines of the update/database/postgresql/4.0/dbupdate-4.0.0-to-4.0.1.sql script are:

ALTER TABLE ezurlalias_ml ADD COLUMN alias_redirects INT;
ALTER TABLE ezurlalias_ml ALTER COLUMN alias_redirects SET default 1;
ALTER TABLE ezurlalias_ml ALTER COLUMN alias_redirects SET NOT NULL;

This cannot work, since SET DEFAULT does not apply to existing rows.
So it should be:

ALTER TABLE ezurlalias_ml ADD COLUMN alias_redirects INT;
ALTER TABLE ezurlalias_ml ALTER COLUMN alias_redirects SET default 1;
UPDATE ezurlalias_ml SET alias_redirects=1;
ALTER TABLE ezurlalias_ml ALTER COLUMN alias_redirects SET NOT NULL;

...Still the fun (?) is not over. Arriving at step 5 of the upgrade procedure, this is what I get:

$ php extension/ezurlaliasmigration/scripts/migrate.php

The number of custom url aliases are:
The number of history entries are:

Segmentation fault

now I am really stuck...

Friday 28 November 2008 10:44:12 am

Ok, that's for the first problem. But what about the second one?

The segfault seem to happen at the

$script->shutdown();

line of the script extension/ezurlaliasmigration/scripts/migrate.php

(Running on php 5.2.4)