Suddenly Broken Database
Permalink
Hi All,
I am getting errors when trying to edit a block like below:
An unexpected error occurred. mysqlt error: [1146: Table 'concrete.collectionversionblocksoutputcache' doesn't exist] in EXECUTE("update CollectionVersionBlocksOutputCache set btCachedBlockOutputExpires = 0 where cID = '2862' and cvID = '7' and arHandle = 'Main' and bID = '27228'") < Back to Home
I also get the same db error when I try to go Clear Cache or change Cache and Speed Settings from the Systems & Services menu.
I went into phpmyadmin to check my database, and its true, there is no CollectionVersionBlocksOutputCache table in the db.
I'm not sure what happened, but I really don't need that table I don't think (I would be clearing the cache anyways). However, to remake an empty OutputCache table to enable C5 functionality I need to know its structure. Does anyone have any resources on the structure of C5 db tables - so that I might recreate it?
Thanks for any help you can provide.
I am getting errors when trying to edit a block like below:
An unexpected error occurred. mysqlt error: [1146: Table 'concrete.collectionversionblocksoutputcache' doesn't exist] in EXECUTE("update CollectionVersionBlocksOutputCache set btCachedBlockOutputExpires = 0 where cID = '2862' and cvID = '7' and arHandle = 'Main' and bID = '27228'") < Back to Home
I also get the same db error when I try to go Clear Cache or change Cache and Speed Settings from the Systems & Services menu.
I went into phpmyadmin to check my database, and its true, there is no CollectionVersionBlocksOutputCache table in the db.
I'm not sure what happened, but I really don't need that table I don't think (I would be clearing the cache anyways). However, to remake an empty OutputCache table to enable C5 functionality I need to know its structure. Does anyone have any resources on the structure of C5 db tables - so that I might recreate it?
Thanks for any help you can provide.
If you are using 5.6 you can go into your Dashboard -> System & Settings -> Database XML and check the box for "Refresh core database tables and blocks." and click Refresh Databases, it will re-create any missing core tables. Make sure you do a backup before you do this, but that should solve your problem.
Did you transfer your site to a new domain?
Just checking to see what's causing the table to be missing.
Grafoman