Using Grid Field type EE Issues Error when saving Data (only happens if you set it searchable)
When I add the data I get the following error.
A Database Error Occurred
Error Number: 1054
Unknown column 'field_id_8' in 'field list'
UPDATE 'exp_channel_data' SET 'field_id_8' = 'SU-000BG' WHERE 'entry_id' = 8
Filename: fieldtypes/grid/libraries/Grid_lib.php
Line Number: 276
It seems that even though you make the table for the grid values,
the grid component want that field id to exist in channel data and on my table those field id are missing from an old deleted channel field group.
Is there anyway to use no results if the grid is empty?
Or can I use the count?
here is my template
- {lv_subscription_apps:app_title} {lv_subscription_apps:app_sku}
{exp:low_variables:pair var="lv_subscription_apps" search:app_sku="SU-000BG" orderby="app_title"}
{if no_results}No values found{/if}
{/exp:low_variables:pair}
Replies
Low 14 Jan 2014 07:18
I'm afraid this looks like an issue with Grid itself. LV just calls native Grid methods to handle stuff, and since Grid is the first native fieldtype that can be used outside of a channel context, there are a couple of bugs in it.
This most likely isn't something I can solve from within LV, but rather should be fixed by EllisLab in Grid itself. I'll check if I can locate the issue within Grid so you might have a temporary fix, if EllisLab can't provide it themselves.
Jon Alberghini 14 Jan 2014 18:27
Also If I delete the variable or change type from grid the low variable grid table is left in the DB.
Low 14 Jan 2014 19:10
Indeed it does. Currently, Low Variables doesn't trigger delete-actions when deleting a variable. I'll add it to my list of things to investigate.