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

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.