Error Number: 1054
Hi Low,
EE 2.4.0
LV 2.3.1
Matrix 2.4.3
I've got an issue where when I enable matrix inside of LV I get the following error when editing any variable.
A Database Error Occurred
Error Number: 1054
Unknown column 'var_id' in 'where clause'
SELECT 'col_id', 'col_type', 'col_label', 'col_name', 'col_instructions', 'col_width', 'col_required', 'col_search', 'col_settings' FROM ('exp_matrix_cols') WHERE 'var_id' = '11' ORDER BY 'col_order'
Filename: third_party/matrix/ft.matrix.php
Line Number: 602
Interstingly inside the LV extension settings it lists Matrix as 2.4.1 but I have 2.4.3 installed and have triple checked that.
Everything else is working great.
Replies
Low 23 Aug 2012 14:15
Hi Sean,
Looks like Matrix wasn't updated properly. Follow all 3 of these steps, including (most importantly) the third step:
...which should create the missing var_id column.
Sean 23 Aug 2012 14:27
Done and problem still exists. I checked the version in the extensions page for matrix and it's 2.4.3 and it does no reflect that in the LV extension settings page.
Low 23 Aug 2012 14:31
Well, it's still a Matrix issue. Try and apply the fix Brandon mentions here.
Sean 23 Aug 2012 14:36
Low - thanks. Should've checked matrix support before bothering you. Sorry aobut that, anyhow thanks for the top notch, super speedy answers.
Low 23 Aug 2012 14:36
No probs, mate. :)