Exception Caught SQLSTATE[42S22]: Column not found
Development and Programming
Hello! I am hoping someone can help me with this. It appears my EE database may be corrupt. I am receiving the following error when trying to access a template from the front-end on a site in development:
Exception Caught SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘field_id_11’ in ‘field list’:
I have attached a screenshot with the error message and stack trace.
For background: The template in question holds the code for Solspace Calendar ics_subscription.
Can anyone guide me in how to fix this? I have database backups, but not exactly sure when this started happening.
Thank you! -JP
OK, it looks like I found and fixed the issue:
As part of the Solspace Calendar Fieldtype settings, we select which fields to use for ICS Description and ICS Location. We had set Location to “Do not use this field” but left an older field selection for ICS Description. I more than likely changed/removed the description field, but had not updated the ICS Description Field selection in the Calendar Fieldtype Settings.
All appears to be working well for now.