All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

Low variables + Matrix database error

Lu 18 May 2012 15:06 problem, complete

Hi,
I'm using low variables 2.2.1 and matrix 2.3.

I've created a new variable with a matrix field and when I clicked on save a database error appears:

[code]
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' = '18' ORDER BY 'col_order'

Filename: third_party/matrix/ft.matrix.php

Line Number: 551

[/code]

Now whenever I access the module that error shows up.

Any ideas?

Replies

  1. Low 18 May 2012 15:08

    Hi Lu,

    Looks like Matrix was not updated properly. Make sure you followed Matrix' upgrade instructions to the letter.

  2. Lu 18 May 2012 15:13

    Hi!
    Thanks for your answer.
    I've update from Matrix 2.2 to 2.3, and according to the docs it is just copying the files.

    What should I do to fix this problem now?

  3. Low 18 May 2012 15:15

    Have you done step 3 as well?

    Go to Add-Ons → Fieldtypes → Matrix to trigger Matrix’s update script. (No action is necessary.)

  4. Lu 18 May 2012 15:21

    Such a dumb error!
    Thank you!

  5. Low 18 May 2012 15:42

    No probs! Glad it's working. :)

  6. e-man 26 Jun 2012 22:34

    Had a similar error - this solved it for me too.

  7. stevieg_83 15 Dec 2013 22:06

    Hey Low, I'm getting this as well although Matrix has definitely been upgraded as detailed.

    Any ideas?

  8. Low 16 Dec 2013 07:36

    Well, Matrix's update script wasn't triggered fully, 'cause it needs to add the var_id column. Try executing this query manually: 

    ALTER TABLE exp_matrix_cols ADD var_id INT(6) UNSIGNED AFTER field_id, ADD INDEX (var_id)

  9. stevieg_83 16 Dec 2013 14:11

    Awesome. Wonder why that didn't trigger in the first instance.

  10. stevieg_83 17 Dec 2013 23:04

    Found out why this failed. The client had renamed their db prefixes to pfra_ and seems Matrix is set to add var_id col to exp_

  11. maodiddy 29 Jul 2014 21:16

    I am getting this problem and none of the above has worked for me. Actually, the manual update query seemed to work initially, but now I can't get to the low variables module without it throwing this error...

  12. Low 30 Jul 2014 07:15

    The error is thrown by Matrix when an update isn't done properly. If it still occurs even after you've added the column to the Matrix table manually, then either you've added the column to the wrong table, or something else is going on. I'd also suggest asking Pixel & Tonic, as it's essentially their add-on that's throwing the error.

  13. maodiddy 7 Aug 2014 02:49

    thanks, I just saw your reply. You can ignore the reply I just posted on stackechange, then... I'll reach out to P&T - I tried re-updating both add-ons with no success... :(