Can you please identify the issue?
Permalink
When I upgraded one of my c5 websites to 5.4.0.3, and tried to edit it, i got the following message. Can anyone please identify the issue behind?
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '614-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '325', '614', 'SubArea_40', 0)") ' in /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 [internal function]: Database->__call(Array, Array) #4 /home2/normacoi/public_html/choondi/ in /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '614-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '325', '614', 'SubArea_40', 0)") ' in /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 [internal function]: Database->__call(Array, Array) #4 /home2/normacoi/public_html/choondi/ in /home2/normacoi/public_html/choondi/updates/concrete5.4.0.3/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I'm getting a similar error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '1030-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '154', '1030', 'Sidebar', '0')") ' in /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2
/home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 [internal function]: Database->__call(Array, Array) #4 /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/models in /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
The referenced thread does seem to help others who have experienced the problem, but I don't know enough to find where to make the prescribed changes.
Can someone provide more detailed help for those of us who don't know what "executing the following SQL statement in your db" means??? Help!
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '1030-1' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('1', '154', '1030', 'Sidebar', '0')") ' in /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2
/home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/database.php(73): ADOConnection->Execute('insert into Col...', Array) #3 [internal function]: Database->__call(Array, Array) #4 /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/models in /home6/lunaeria/public_html/updates/concrete5.4.0.5/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
The referenced thread does seem to help others who have experienced the problem, but I don't know enough to find where to make the prescribed changes.
Can someone provide more detailed help for those of us who don't know what "executing the following SQL statement in your db" means??? Help!
This still appears to be a problem. Do you know if it's in Bugtracker? I couldn't find it.
http://www.concrete5.org/community/forums/installation/error-upgrad...