Upgrading to EE4 from EE3? EE throws a database error referencing low variables in one of its tables.
The background on the issue can be found here: https://expressionengine.com/forums/t...
Here's a screenshot of the issue on hand:
https://imgur.com/vMmyhEh
Has anyone encountered this before?
Replies
Low 27 Nov 2018 07:27
Haven't seen this particular MySQL error before, but it looks like Grid might be looking in the wrong place.
For a Grid variable, Low Variables calls the Grid fieldtype with the 'low_variables' content type, making Grid target different tables and columns. The default and most used content type would be 'channel'. By the looks of it, the 'fluid_field_data_id' column is not present in the Grid-table-with-low-variables-content-type: exp_low_variables_grid_field_33.
This isn't something LV can fix itself, because LV just calls the Grid fieldtype and lets it do its thing. It's therefore looking like an issue with the Grid fieldtype. Sorry to be bouncing you back and forth, but you'd need input from EllisLab about this.