Page Type: Which Database Table?

Permalink
Hello,

I have a custom page type I created, and in the "output" section I added a block which has broken my page. I can't remove it in C5, but can't find the table in the database where I can delete the block there. Can anyone tell me which table contains the blocks in the page type outputs?

Thanks for your help.

DeviantDeer
 
PineCreativeLabs replied on at Permalink Reply
PineCreativeLabs
Do you know what the block table was that you added? You could just find that table, and delete the row that has it.

Another thing you could do would be to revert back to an earlier version of the page. You could do this by going to the Sitemap, and select the versions option and approve an earlier version (before you added the block).
DeviantDeer replied on at Permalink Reply 1 Attachment
DeviantDeer
Thanks for your response. I don't know how to get to the versioning for a page type. I've added a screenshot. My custom page is called recipe_entry. But I still can't find where the page type blocks are stored in my database.
PineCreativeLabs replied on at Permalink Best Answer Reply
PineCreativeLabs
There is no versioning for custom page types.

When adding a new block to a custom page type, it gets treated the same as you would add a block to any regular page.

So, it will be in the table for that block. For example, if the block added was the core Feature block, it would be in the btFeature table.

If you know the name of the table for the block you added, simply go to that table, and delete the row that might be causing the issue.