Error when adding a new page:
Permalink
Hello,
--------------
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '2-89' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('89', '2', '2', 'Header Nav', '0')") ' in F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 [internal function]: ADOConnection->Execute('insert into Col...', Array) #3 F:\xampp\htdocs\3dbasis\concrete\libraries\database.php(73): call_user_func_array(Array, Array) #4 [internal function]: Database->__call('Execute', Array) #5 F:\xampp\htdocs\3dbasis\concrete\models\block.php(393): Database->Execute('insert into Col...', Array) #6 F:\xampp\htdo in F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78
----------
Do you have an idea?
Thank you
uli
--------------
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '2-89' for key 'PRIMARY'] in EXECUTE("insert into CollectionVersionBlockStyles (cID, cvID, bID, arHandle, csrID) values ('89', '2', '2', 'Header Nav', '0')") ' in F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb.inc.php(993): ADOConnection->_Execute('insert into Col...') #2 [internal function]: ADOConnection->Execute('insert into Col...', Array) #3 F:\xampp\htdocs\3dbasis\concrete\libraries\database.php(73): call_user_func_array(Array, Array) #4 [internal function]: Database->__call('Execute', Array) #5 F:\xampp\htdocs\3dbasis\concrete\models\block.php(393): Database->Execute('insert into Col...', Array) #6 F:\xampp\htdo in F:\xampp\htdocs\3dbasis\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78
----------
Do you have an idea?
Thank you
uli
There's another thread about this problem:
http://www.concrete5.org/community/forums/installation/error-upgrad...
Solution inside!
http://www.concrete5.org/community/forums/installation/error-upgrad...
Solution inside!
I installed, learned, created templates and theme, updated a site in Concrete5 v5.4.0.1 and left it for months. I'm back on it and having the same issue.
update
unfortunately, I can't help you, because I'm probably having the same problem - at least the symptom is very similar.
Since upgrading from 5.3.3.1 to 5.4, whenever I try to add a new page via the dashboard, I'm getting the following error message:
If I press F5 while on this error page and confirm the "Resend Data"-Message from the browser, the message changes to
So it's counting up from 171 to 172 (in the 'mysql error: [1062: ...]'-part). It must be doing *something* in the database because the new page including its duplicate is being shown in the sitemap - but not on the live site.
Similar errors show up when I change or add content on any page - it has always something to do with the INSERT statement on table 'CollectionVersionBlockStyles'.
Does anybody have an idea? Help would be very much appreciated!
Thanks in advance!