2

I'm having an issue with Matrix where after upgrading from Matrix 2.4.3 to 2.5.3 I get this error on every page of the site regardless of the content on the page. Any ideas on how to fix this would be greatly appreciated.

Error Number: 1054

Unknown column 'is_draft' in 'where clause'

SELECT row_id, col_id_1, col_id_2, col_id_3 FROM exp_matrix_data WHERE field_id = 17 AND entry_id = 1048 AND is_draft = 0 ORDER BY row_order ASC LIMIT 1

Filename: third_party/matrix/ft.matrix.php

Line Number: 2808

Site specifications

  • EE 2.5.3
  • PHP Version 5.3.20
  • SQL 5.0.77

Plugins

  • Structure
  • Matrix
  • WYGWAM
  • Playa
  • Assets
1
  • Try Ian's suggestion below - if that doesn't fix it, please email super admin details via [email protected] and we can get you fixed up.
    – Lisa
    Commented Apr 15, 2013 at 15:42

1 Answer 1

12

It sounds like Matrix may not have completed it's update routine. Did you go to Add-Ons → Fieldtypes → Matrix to trigger the update script?

3
  • Didn't realize that was part of upgrading instructions, as a fieldtype. Yeah that fixed it. Thank you. Commented Apr 15, 2013 at 15:57
  • No worries. It can be easy to forget.
    – Ian Young
    Commented Apr 15, 2013 at 18:26
  • Actually it's on triggering the update script by method mentioned that I got the error. Something more is afoot here, I think... Commented Sep 25, 2013 at 21:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.