Cannot delete block and error when changing settings
Permalink 1 user found helpful
Hi,
This is a Concrete 5.3.3 install (so I'm aware I may need to upgrade the site to fix this). I have two blocks that I can't delete - a content block and a page list block. Every time I try to delete them, they disappear in edit mode, but when I publish my changes, they reappear again. It's only with these two blocks, the rest are fine.
If I try to change the settings of the pagelist block, I get this error:
Anyone know what's going on? Looks like a duplicate entry in the database based on the error, so is it a matter of going in to the database and removing it manually? If so, where would do I that?
Thanks,
osu
This is a Concrete 5.3.3 install (so I'm aware I may need to upgrade the site to fix this). I have two blocks that I can't delete - a content block and a page list block. Every time I try to delete them, they disappear in edit mode, but when I publish my changes, they reappear again. It's only with these two blocks, the rest are fine.
If I try to change the settings of the pagelist block, I get this error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1062: Duplicate entry '66-11-1-102' for key 'PRIMARY'] in EXECUTE("insert into CollectionAttributeValues (cID, cvID, akID, avID) values ('66', 11, '1', '102')") ' in /home/user/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /home/user/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1062, 'Duplicate entry...', 'insert into Col...', false, Object(ADODB_mysql)) #1 /home/user/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(998): ADOConnection->_Execute('insert into Col...') #2 /home/user/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(766): ADOConnection->Execute('insert into Col...', Array) #3 /home/user/public_html/concrete/libraries/database.php(73): ADOConnection->Query('insert into Col...', Array) #4 [internal function]: Database->__call(Array, Array) #5 /home/user/public_html/concrete/models/collection_v in /home/user/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Anyone know what's going on? Looks like a duplicate entry in the database based on the error, so is it a matter of going in to the database and removing it manually? If so, where would do I that?
Thanks,
osu
You might just try deleting the page and recreating it. I haven't run into this problem before.
i had the same problem today. recreating the page was going to take too much time. my problem happened to be with a scrapbook block. however, i am sure this will work for any block. if for any other block style, disregard steps 2 and 3. this is what i did to fix:
BACK UP YOUR DATA BEFORE TRYING THIS!!! i am using c5 3.3.1.
goals:
- remove old versions and backups of original scrapbook block
- remove entry trying to be duplicated in db table
the steps i took:
- disabled and cleared cache (sitewide settings -> debug) not sure if this really matters. i did this as a precaution.
- backup (copy/paste) the contents of your scrapbook entry somewhere
- delete scrapbook entry in dashboard
- get cID from page(s) you wish to remove the scrapbook block from (if you click to edit a page in question, it will show in the url)
- goto btContentLocal table of db, do a search based on the "content" field that includes text from your scrapbook entry
- write down the bID(s)
- delete those entries (make sure they contain the same info as your scrapbook entry.)
- lookup records in the CollectionVersionBlocks table that have cID of the page(s) you are wanting to remove the scrapbook block from
- delete the records
- go to CollectionAttributeValues table and remove the original record that is attempting to be duplicated. the field values should be in the output of the debug messsage on the page that will not allow you to remove the block.
cheers...
BACK UP YOUR DATA BEFORE TRYING THIS!!! i am using c5 3.3.1.
goals:
- remove old versions and backups of original scrapbook block
- remove entry trying to be duplicated in db table
the steps i took:
- disabled and cleared cache (sitewide settings -> debug) not sure if this really matters. i did this as a precaution.
- backup (copy/paste) the contents of your scrapbook entry somewhere
- delete scrapbook entry in dashboard
- get cID from page(s) you wish to remove the scrapbook block from (if you click to edit a page in question, it will show in the url)
- goto btContentLocal table of db, do a search based on the "content" field that includes text from your scrapbook entry
- write down the bID(s)
- delete those entries (make sure they contain the same info as your scrapbook entry.)
- lookup records in the CollectionVersionBlocks table that have cID of the page(s) you are wanting to remove the scrapbook block from
- delete the records
- go to CollectionAttributeValues table and remove the original record that is attempting to be duplicated. the field values should be in the output of the debug messsage on the page that will not allow you to remove the block.
cheers...
Bit stuck on what to do.
Thanks,
osu