Grid field PHP error in Low Variables
EE v2.9.0
LV v2.5.0
I added a grid field to low variables and I think I saved it without giving the grid column a name (stupid, stupid, stupid).
I now can't access Low Variables at all. I just get this error.
============================
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Filename: models/grid_model.php
Line Number: 496
A PHP Error was encountered
Severity: Warning
Message: Cannot modify header information - headers already sent by (output started at /Users/timprint/Dropbox/Sites/jpm-ee/system-FVMTN6uReHVBU7bjtB5hYOTe/codeigniter/system/core/Exceptions.php:170)
Filename: core/Common.php
Line Number: 446
A Database Error Occurred
Error Number: 1054
Unknown column 'col_id_' in 'order clause'
SELECT * FROM ('exp_low_variables_grid_field_22') WHERE 'entry_id' IN ('22') ORDER BY 'col_id_' asc
Filename: models/grid_model.php
Line Number: 413
============================
Any idea how I can clean this up and get low variables working again?
Replies
Low 21 Sep 2014 16:36
You should be able to access the extension settings via Add-ons -> Extensions. Then you can either disable the Grid variable type, or just give the Grid var the correct column names via Manage variables.
Tim Print 21 Sep 2014 17:39
All working. Thanks.
Loughlin McSweeney 29 Sep 2016 10:42
Phew! Nice tip, I did the exact same thing :) This fixed my problem.