An exception occurred while executing 'delete
Permalink
Can someone help me with the below error... I am getting this since I changed my Host company.
"An exception occurred while executing 'delete from CollectionVersionBlocksCacheSettings where cID = ? and cvID = ? and bID = ? and arHandle = ?' with params ["135", "31", "846", "Main"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cID' in 'where clause'"
"An exception occurred while executing 'delete from CollectionVersionBlocksCacheSettings where cID = ? and cvID = ? and bID = ? and arHandle = ?' with params ["135", "31", "846", "Main"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'cID' in 'where clause'"
Looks like your database didn't get transferred properly.
Probably yes, but is there a way to manually fix this?
Do you still have access to the old host and/or a database backup from the working site? Otherwise I'm not sure how to fix missing columns because even if you re-add the column back into the table all of the data will be corrupt.
