Upgrade to 5.6.0.2 fails with MySQL error 1048

Permalink
This is the message I get when attempting to upgrade from 5.5.2.1 to 5.6.0.2
An Unexpected Error occurred while upgrading: mysql error: [1048: Column 'cvID' cannot be null] in EXECUTE("INSERT INTO CollectionAttributeValues (cID,cvID,akID,avID) VALUES (185,NULL,3,1593)")
Any Ideas guys..

ConcreteOwl
 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Anyone?
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Bump....
russellfeeed replied on at Permalink Reply
russellfeeed
Hi

I think I got that or something similar.
Solved it by dropping my database and recreating it using a pre 5.6.0.2 (i.e. 5.5.2.1) database backup. Then I downloaded 5.6.0.2 manually and put that under updates/. Finally I went to index.php/dashboard/system/backup_restore/update/ and ran the update. I think I had a corrupt or incomplete download of 5.6.0.2.

Unfortunately now I'm getting another error: seehttp://www.concrete5.org/index.php?cID=393151...

Hope that helps.

Russell
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Nope, tried all of that and more besides...
Reading your post I tend to agree with you that it is a mismatch between the new permissions system and the existing advanced permissions (which cannot be changed back to simple permissions)