|
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...
|