I've just changed a rich text field to a number field and am now unable to bring up either the front-end or the dashboard because of multiple CDbException errors. When trying to access /admin
, here's the first line of the error message:
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'content.field_sqFt' in 'field list'
I changed a rich text field named projectDescription
to a number field named sqFt
. I understand that the new column can't be found.
When updating a field type, I know that there's a chance for data loss. Data loss would be ok for the entries that this change would affect. But I've made other changes since my last backup that I'd like to retain if possible.
I'm running the latest Craft Pro.
CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '<p>A three-story office building, 123 East Pine Street boasts move-in-ready, furnished executive suites on the first floor a' for column 'field_sqFt' at row 160. The SQL statement executed was: ALTER TABLE
craft_content` CHANGEfield_projectDescription
field_sqFt
INT(10) UNSIGNED NULL DEFAULT 0` – plaintxt Oct 21 '15 at 19:50