7

After updating an EE 2.5.5 site to the latest playa 4.4.4., an error showed up when trying to access the FieldType settings screen.

A Database Error Occurred

Error Number: 1060

Duplicate column name 'parent_var_id'

ALTER TABLE exp_playa_relationships ADD parent_var_id INT(6) UNSIGNED AFTER parent_row_id, ADD INDEX (parent_var_id)

Filename: [redacted]/playa/ft.playa.php

Line Number: 423

I was in the process of upgrading the site to EE 2.6.1. so I carried on and the error still shows after performing the upgrade. It seems that the site is still functional, I see no error when accessing pages making use of playa or when using the fieldtype in the CP.

Anyone experienced this? P&T guys?

21

The guys at P&T did come back to me in less than 24 hours with a fix. I'll post it here in case someone runs into the same problem.

Take a look at the columns in exp_playa_relationships table in the database.

  • Does it have a field parent_var_id? If no, then the version you should set is 4.1.
  • If yes, does it have a field parent_is_draft? If no, then the version you should set is 4.3
  • If yes, then the version you should set is 4.4.4

Now, set the version number we determined in the previous three steps for the Playa field in the exp_fieldtypes table and go visit the Add-ons -> Fieldtypes -> Playa page and hit submit.

Everything should be all working now.

  • Just got hit with this as well, thanks for posting the solution. – Iain Urquhart Jul 18 '13 at 3:37
  • No problem, Andris was quick on that one ;o) – Jérôme Coupé Jul 18 '13 at 8:00
  • I just got this too, upgrading from 4.0.5 -> 4.4.4 so I got worried before I saw this :) – Rob Hodges Jul 18 '13 at 12:42
  • Hey Rob! Glad it helped! – Jérôme Coupé Jul 22 '13 at 7:43
  • 3
    Happened to me again upgrading to EE 2.9.3 and Playa 4.5.2. I just manually updated the "exp_fieldtype" table "version" column to 4.5.2 and refreshed the CP page, the hit submit and everything is fine. – Jérôme Coupé Mar 31 '15 at 8:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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