Database Error with Grid Field and Low Variables 2.5.0 EE 2.8.1
I"m getting the following error when adding a variable with Grid. Using LV 2.5.0 and EE 2.8.1 I've uninstalled and reinstalled Low Variables. I've also completed deleted the Low Variable files and redownloaded the zip from devot:ee and tried again. Same problem.
Please advise
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Filename: models/grid_model.php
Line Number: 479
A Database Error Occurred
Error Number: 1054
Unknown column 'col_id_' in 'order clause'
SELECT * FROM ('exp_low_variables_grid_field_1') WHERE 'entry_id' IN ('1') ORDER BY 'col_id_' asc
Filename: D:\xampp\htdocs\mccrum\crumsys\codeigniter\system\database\DB_driver.php
Line Number: 382
Replies
Low 3 Jun 2014 18:53
What exactly do you mean with "when adding a variable with Grid"? Can you describe the exact actions you're taking?
Sean 3 Jun 2014 19:44
Low.
create new variable > Name it, label it, > choose grid > 1 cell or more doesn't matter. Save and get this error.
Afterwords unable to access the LV control panel until I uninstall and reinstall it.
Sean 3 Jun 2014 19:53
Low,
I did a fresh install (new EE database) and have the same error. There were no other addons installed in the fresh EE install.
Low 3 Jun 2014 19:58
This looks similar. Can you verify you're giving the Grid columns names?