Forums

crash after upgrade from 3.3.1 to 3.4.1

Permalink
After upgrading a vanilla website with the green salad theme then attempting to add a page I get the following errors

Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '3-77' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('77', '2', '3', 'Header Nav', '0')")
' in /home/xxx/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace:
#0 /home/xxx/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql))
#1 /home/xxx/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...')
#2 [internal function]: ADOConnection->Execute('insert into Col...', Array)
#3 /home/xxx/public_html/concrete/libraries/database.php(73): call_user_func_array(Array, Array)
#4 /home/xxx/public_html/concrete/models/block.php(404): Database->__call('Execute', Array)
#5 /home/xxx/public_html/concrete/models/block.php(404): Data in <b>/home/xxx/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php</b> on line <b>78</b>


Any Ideas as to the cause?

DC

UPDATE:
The page is created. then it appears to try and create it again.

I can find the page and edit it as per normal from the dashboard sitemap

DC
 
adamjohnson replied on at Permalink Reply
adamjohnson
Upgrading from 5.3.3.1 to 5.4.1 does cause errors. People have talked about it here in the forums. General consensus was to upgrade version by version, and it fixes it. Although, I'm pretty sure someone found the root of the problem as well.

Bug Tracker:
http://www.concrete5.org/developers/bugs/5-4-1-1/...
DeveloperChris replied on at Permalink Reply
Thanks.

I have downgraded back to my original version.

I'll upgrade step by step when I get a chance.

I made a mistake on my original post I meant to say I had version 5.3.3.1. not 3.3.1 but of course you worked it out :)

I did take note of the warning on the download page
"Upgrading note: You need to be running version 5.3.2 or later to upgrade gracefully. If you're before that version, first upgrade to 5.3.2."

It should be changed to say upgrade one at a time till you reach the latest version.
DeveloperChris replied on at Permalink Reply
I just went through the version by version upgrade. sadly the problem persists. It appears to be a bug. I'll file a report.
stromberg replied on at Permalink Reply
stromberg
Hello,

this sounds like my favorite problem... there's a possible solution in this thread: http://www.concrete5.org/community/forums/installation/error-upgrad...

Cheers,
stromberg
DeveloperChris replied on at Permalink Reply
Thanks. I managed to find the thread and it worked well for me.