6

I've just upgraded to EE 2.9 and trying to update Playa to 4.5.

When I go to Fieldtypes -> Playa I get this error:

A Database Error Occurred Error Number: 1060

Duplicate column name 'parent_element_id'

ALTER TABLE exp_playa_relationships ADD parent_element_id VARCHAR(255) NULL AFTER parent_var_id

Filename: third_party/playa/ft.playa.php

Line Number: 488

The previous version I had installed was 4.4.5 - I've tried setting it to 4.4.4 in exp_fieldtypes as well but same error.

12

For some reason sometime the update is applied but EE does not change the version number. I'm not even sure on which side the error happens, but setting the version number to 4.5 in exp_fieldtypes should solve your problem.

7
  • Yes, I have this problem a lot with alls kinds of add-ons.
    – Louis K
    Jul 25 '14 at 7:28
  • 1
    I had the same problems, EE2.9, i've just updated from Playa 4.4.5 to 4.5.1. Changing to 4.5.1 in the exp_fieltypes has solved the problem
    – Stéphane
    Aug 7 '14 at 23:21
  • Just adding that I've had this same issue going from 4.4.5 to 4.5.1. Changing the version fixed the error.
    – Jon Horton
    Aug 20 '14 at 22:53
  • 1
    Jon, it's an issue we're aware of - we have ideas on how to fix that, but that requires time and other luxuries, so until we manage to get on top of it, this probably will come up from time to time :( Aug 21 '14 at 6:39
  • 1
    Also hit by this one today, the above solution fixed it. Ran this SQL: UPDATE exp_fieldtypes SET version = '4.5' WHERE name = 'playa' Aug 27 '14 at 6:57

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.