Fatal error: Uncaught exception ... Duplicate entry ... in EXECUTE("insert into CollectionVersionBlockPermissions ...
Permalink
Every time I add a page I get the error below. I have advanced permissions setup and permissions on each block with the page type. Any ideas?
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '85-1-4-1-0' for key 1] in EXECUTE("insert into CollectionVersionBlockPermissions (cID, cvID, bID, gID, uID, cbgPermissions) values ('85', '1', '4', '1', '0', 'r')") ' in /var/www/dms/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/dms/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /var/www/dms/concrete/libraries/3rdparty/adodb/adodb.inc.php(1017): ADOConnection->_Execute('insert into Col...', false) #2 /var/www/dms/concrete/libraries/3rdparty/adodb/adodb.inc.php(766): ADOConnection->Execute('insert into Col...', false) #3 [internal function]: ADOConnection->Query('insert into Col...') #4 /var/www/dms/concrete/libraries/database.php(73): call_user_func_array(Array, Array) #5 [internal function]: Database->__call('query', Array) #6 /var/www/dms/concrete/models/block.p in /var/www/dms/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '85-1-4-1-0' for key 1] in EXECUTE("insert into CollectionVersionBlockPermissions (cID, cvID, bID, gID, uID, cbgPermissions) values ('85', '1', '4', '1', '0', 'r')") ' in /var/www/dms/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/dms/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /var/www/dms/concrete/libraries/3rdparty/adodb/adodb.inc.php(1017): ADOConnection->_Execute('insert into Col...', false) #2 /var/www/dms/concrete/libraries/3rdparty/adodb/adodb.inc.php(766): ADOConnection->Execute('insert into Col...', false) #3 [internal function]: ADOConnection->Query('insert into Col...') #4 /var/www/dms/concrete/libraries/database.php(73): call_user_func_array(Array, Array) #5 [internal function]: Database->__call('query', Array) #6 /var/www/dms/concrete/models/block.p in /var/www/dms/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
If you could provide more details about the steps to reproduce this error and your setup, it will help in solving this issue.
I am unable to reproduce now because I delete the page type and recreated the permissions model from the page type from scratch. Here is what I can tell you:
* Each page type had blocks with permissions set (which differed from the default inherited page permissions).
* I had setup 4 pages before I elected to "Setup on Child Pages".
* After I "Setup on Child Pages" I started receiving the error message when adding a new page, and occasionally when modifying the permissions of blocks within a page.
* I resolved the issue by switching the design of all pages to another page type, deleting the page type, re-creating the page type, deleting the leftover blocks with permissions on pages and finally re-associated the design of pages.
If I see the error again I will reply (and probably send you the database). Thank you for the quick response. I'm sorry that I can no longer reproduce the error.
* Each page type had blocks with permissions set (which differed from the default inherited page permissions).
* I had setup 4 pages before I elected to "Setup on Child Pages".
* After I "Setup on Child Pages" I started receiving the error message when adding a new page, and occasionally when modifying the permissions of blocks within a page.
* I resolved the issue by switching the design of all pages to another page type, deleting the page type, re-creating the page type, deleting the leftover blocks with permissions on pages and finally re-associated the design of pages.
If I see the error again I will reply (and probably send you the database). Thank you for the quick response. I'm sorry that I can no longer reproduce the error.
Im getting this too.
