All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

SQLSTATE[42S22]: Column not found: 1054 EE v3.5.2 LV v3.0.4

JB 7 Feb 2017 21:49 problem, complete

Low variables v3.0.4 and EE 3.5.2 I receive an error when saving variables...
I have two grids only one succeeds in saving and I get the error no matter what I am saving...

this is the error...
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_id_1' in 'field list':
UPDATE 'exp_channel_data' SET 'field_id_1' = Facebook|facebook.com|Linkedin|linkedin.com' WHERE 'entry_id' = '1'

ee/legacy/database/drivers/mysqli/mysqli_connection.php:122

Replies

  1. Low 8 Feb 2017 10:04

    This actually looks like an issue with Grid itself, and a conflict with content types.

    Do you, by any chance, have any of the Grid columns in LV set as searchable? If so, can you try and untick those checkboxes?

  2. Low 8 Feb 2017 13:56

    Okay, then it looks like this bug report is still valid: https://expressionengine.com/support/...

  3. JB 8 Feb 2017 13:58

    The search issue was the issue I overlooked a field in the last grid I had... your work is done :D thanks again for your help...