8 update failure
Permalink
Update help please - and info for the developers.
1. Successfully updated to 5.7.5.10
2. Downloaded 8 Zip and uploaded to server. Extracted file and went to Dashboard / Update.
3. Update to 8 showed as ready to install and all add-ons green ticked as compatible. Clicked to proceed and came up with screen ( see attached) where salient message is as follows:
4. Now the site is broken, and even though I had kept and renamed the previous version of the concrete file (5.7.5.10) I can't rename the new one and the old one so as to get myself back up and running.
Any advice please?
Separately I'll post this in GitHub
1. Successfully updated to 5.7.5.10
2. Downloaded 8 Zip and uploaded to server. Extracted file and went to Dashboard / Update.
3. Update to 8 showed as ready to install and all add-ons green ticked as compatible. Clicked to proceed and came up with screen ( see attached) where salient message is as follows:
Doctrine\DBAL\Exception\NotNullConstraintViolationException thrown with message "An exception occurred while executing 'INSERT INTO AttributeKeys (akID, akName, akHandle, akIsSearchable, akIsSearchableIndexed, atID, akIsInternal, pkgID, akCategory) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["28", "Email", "email", "0", "0", "1", "0", "12", null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'akCategory' cannot be null" Stacktrace: #18 Doctrine\DBAL\Exception\NotNullConstraintViolationException in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112 #17 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:116 #16 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:996 #15 Doctrine\DBAL\Driver\PDOException in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93 #14 PDOException in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91 #13 PDOStatement:execute in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91 #12 Doctrine\DBAL\Driver\PDOStatement:execute in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:989 #11 Doctrine\DBAL\Connection:executeUpdate in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:696 #10 Doctrine\DBAL\Connection:insert in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/src/Updater/Migrations/Migrations/Version20160725000000.php:291 #9 Concrete\Core\Updater\Migrations\Migrations\Version20160725000000:importAttributeKeys in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/src/Updater/Migrations/Migrations/Version20160725000000.php:1184 #8 Concrete\Core\Updater\Migrations\Migrations\Version20160725000000:up in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/vendor/doctrine/migrations/lib/Doctrine/DBAL/Migrations/Version.php:290 #7 Doctrine\DBAL\Migrations\Version:execute in /home/adabbdcb/public_html/updates/concrete5-8.0.0/concrete/src/Updater/Update.php:208
Viewing 15 lines of 22 lines. View entire code block.
4. Now the site is broken, and even though I had kept and renamed the previous version of the concrete file (5.7.5.10) I can't rename the new one and the old one so as to get myself back up and running.
Any advice please?
Separately I'll post this in GitHub
This is probably due to blocks (e.g. in packages you are using) which contain db.xlm files which are still based on AXMLS XML. It seems that these files need to be converted to Doctrine XML before the upgrade to version 8 is done (in my case at least this resolved the problem). An online tool to convert db.xml files based on AXMLS XML to Doctrine XML you find here:http://concrete5.github.io/doctrine-xml/...
In 5.7.5.10, before you upgrade to 5.8, make sure every attribute is assigned to a category.
