Forums

Upgrade to 5.6.1 causing blocks to disappear, MySQL error

Permalink
I am having trouble getting COncrete5 to upgrade to 5.6.1. I am getting the following MySQL error after running the script:

An Unexpected Error occurred while upgrading: mysql error: [1048: Column 'cID' cannot be null] in EXECUTE("INSERT INTO PagePermissionAssignments (cID,paID,pkID) VALUES (NULL,'728','1')")


I had advanced permissions on prior to the upgrade.

I also am experiencing issues with blocks disappearing on sub pages, and some blocks duplicating. I can roll back to 5.6.0.2 with no issues and everything appear. to go back to normal.

Also, either I am missing something, or something dramatic changed. I used to be able to go into page types, select defaults, edit global areas, and update on child pages. Where did all that go? Clueless!!

I am definitely noticing a huge speed improvement on 5.6.1, but obviously have to deal with some fixes before I can roll it out.
shondy
 
furehead replied on at Permalink Reply
furehead
I changed file
updates\concrete5.6.0.2\concrete\helpers\concrete\upgrade\version_560.php
and added a check for missing cIDs... around line 680:

$permissions = $this->getPermissionsArray($row['cgPermissions']);
         $co = Page::getByID($row['cID']);
         if(empty($co->cID)) continue;


After that I was possible to upgrade to 5.6.0.2 from 5.5.2.1