Low Variables broken after switching Matrix to Grid variable
I have been systematically eliminating all Matrix fields (converting to Grid) from my EE v2 website in preparation for the v3 upgrade (yep, we're a little behind). I got all of the channel fields, but I must have missed an important Low Variable field which sets the slider images on the home page. I uninstalled and deleted the Matrix add-on and later realized the home page was broken. When I checked the Low Variable, it had reverted to Unknown Type; when I edited the variable, it became a Textarea with a value of "1" in it. I changed the variable to Grid fieldtype, which caused an error, and then I deleted the variable and tried to recreate it with a Grid fieldtype. Now the whole site is broken, and I can't even access the Low Variables interface. I'm getting:
"A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 0
Filename: models/grid_model.php
Line Number: 496
Error Number: 1054
Unknown column 'col_id_' in 'order clause'
SELECT * FROM ('exp_low_variables_grid_field_96') WHERE 'entry_id' IN ('96') ORDER BY 'col_id_' asc
Filename: models/grid_model.php
Line Number: 413"
Can you please help/advise me? I'm currently trying to restore from backup on my local dev site, but the db is huge and it's been almost an hour already...
Replies
Amy Witty 9 Jan 2018 00:54
Well, it looks like the database restore solved my problem locally, so I'm going to go ahead and do that on the production db as well. Sorry to bother you!
Low 9 Jan 2018 07:40
No worries! Happy it works again.