Website suddenly broken with SQL error
Permalink
Hi, any help would be appreciated. My website mysteriously broke with a database error showing up on the front page. I can't login to the backend of the site. When I do, it simply returns to the error page.
mysqlt error: [1146: Table 'northg10_concrete5.CollectionVersionBlocksOutputCache' doesn't exist] in EXECUTE("select btCachedBlockOutput, btCachedBlockOutputExpires from CollectionVersionBlocksOutputCache where cID = '1' and cvID = '61' and bID = '181' and arHandle = 'Main' ")
I have no idea what this means, whether someone hacked my site, or how to fix it. My server is Web Hosting Hub, and I worked with them to restore an older database file, to no avail. They said they made no changes to their servers aside from a DNS update. I did not touch the site when the error occurred.
mysqlt error: [1146: Table 'northg10_concrete5.CollectionVersionBlocksOutputCache' doesn't exist] in EXECUTE("select btCachedBlockOutput, btCachedBlockOutputExpires from CollectionVersionBlocksOutputCache where cID = '1' and cvID = '61' and bID = '181' and arHandle = 'Main' ")
I have no idea what this means, whether someone hacked my site, or how to fix it. My server is Web Hosting Hub, and I worked with them to restore an older database file, to no avail. They said they made no changes to their servers aside from a DNS update. I did not touch the site when the error occurred.
Thank you John. I changed the ENABLE_CACHE entry in the Config table to 0, to no avail.
There are other errors showing up as well on my login page, separate from the index page where my original error is still in effect.
Warning: Cannot modify header information - headers already sent by (output started at /home/northg10/public_html/updates/concrete5.6.2.1_updater/concrete/core/libraries/view.php:978) in /home/northg10/public_html/updates/concrete5.6.2.1_updater/concrete/core/libraries/view.php on line 653
and
mysqlt error: [1146: Table 'northg10_concrete5.JobSets' doesn't exist] in EXECUTE("select jsID, pkgID, jsName, jDateLastRun, isScheduled, scheduledInterval, scheduledValue from JobSets order by jsName asc")
I had problems updating C5 to the latest version a few months ago, with the Jobs area. I managed to resolve those issues with a little help. The website has been working fine since January.
There are other errors showing up as well on my login page, separate from the index page where my original error is still in effect.
Warning: Cannot modify header information - headers already sent by (output started at /home/northg10/public_html/updates/concrete5.6.2.1_updater/concrete/core/libraries/view.php:978) in /home/northg10/public_html/updates/concrete5.6.2.1_updater/concrete/core/libraries/view.php on line 653
and
mysqlt error: [1146: Table 'northg10_concrete5.JobSets' doesn't exist] in EXECUTE("select jsID, pkgID, jsName, jDateLastRun, isScheduled, scheduledInterval, scheduledValue from JobSets order by jsName asc")
I had problems updating C5 to the latest version a few months ago, with the Jobs area. I managed to resolve those issues with a little help. The website has been working fine since January.
My web hosting provider had data corruption issues, and deleted several files in my database. Ugh. So I am working with them to restore the site.
Because this is the block cache table, you could try disabling the cache by hacking the Config table of the database via phpMyAdmin.
If you change ENABLE_BLOCK_CACHE to 0, that should switch off the block cache.
It may make a difference. It may not. If you get in, you should then clear all the caches, switch them all off, then clear again just to be 100% sure. Then when running smoothly you could enable them again.