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?

1 Answer 1


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. Commented Jul 18, 2013 at 3:37
  • No problem, Andris was quick on that one ;o) Commented Jul 18, 2013 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
    Commented Jul 18, 2013 at 12:42
  • Hey Rob! Glad it helped! Commented Jul 22, 2013 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. Commented Mar 31, 2015 at 8:20

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.