Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.4.0, 4.5.0alpha
-
None
Description
I am upgrading a site form ez4.2.0 to ez4.4.0 on Linux with MYSQL.
the upgrade script
$PHP_CLI update/common/scripts/4.4/updatesectionidentifier.php -s $SITE_ACCESS
does not work. It is not creating the missing section_identifier for existing sections.
Why?
I found out.
After performing the db update script dbupdate-4.3.0-to-4.4.0.sql
The ezsection/identifier values wher NULL not ''
But the updatesectionidentifier.php ask for all value with ''. So the NULL value are not selected for update!
To fix this you can add the sql update script
from
ALTER TABLE ezsection ADD identifier VARCHAR(255);
to
ALTER TABLE ezsection ADD identifier VARCHAR(255) DEFAULT '';
=> the ugradecheck in admin throws than a warning .... the dba file has to be updated, too
or you have to update the php script