PHP error when saving Low Variables in Grid, set as 'searchable'
I'm getting a PHP error when I try to save my Grid in Low Variables. I'm using Low Variables 2.6.1, and EE 2.11.2.
I have a Grid as a Low Variable, and the grid contains an Assets field and a Wygwam field, but from my testing, that's not relevant to this issue. I've tested with just a single Text Input field. The issue happens when I set that field as 'searchable'.
When I go to save my data in Low Variables, I get a PHP error. It says
'
A Database Error Occurred
Error Number: 1054
Unknown column 'field_id_32' in 'field list'
UPDATE 'exp_channel_data' SET 'field_id_32' = 'test1|test2' WHERE 'entry_id' = 32
Filename: fieldtypes/grid/libraries/Grid_lib.php
Line Number: 331
'
My 'variable_id' in exp_low_variables is 32, and there is a table 'exp_low_variables_grid_field_32'. However, there is no field 'field_id_32' in 'exp_channel_data'. I'm not sure why this action is even touching 'exp_channel_data'.
Any ideas? For now, I'll just mark my fields as not 'searchable'...
Replies
Low 9 Jul 2016 09:39
This is actually a bug in Grid which I reported a while back: https://support.ellislab.com/bugs/det...
FWIW, making columns searchable in LV doesn't really have any effect, as vars aren't searchable anyway.
Gary Reckard 9 Jul 2016 16:20
AHA!
Good to know. Thanks, Low! Way to go. The more you know...