2

I upgraded to the latest version of playa (unsucessfully with Upgrader then manuallly). The module and field type are showing as 4.4.1 ok but I am getting php errors on all pages that contain playa fileds:

Error Number: 1054

Unknown column 'rel.parent_is_draft' in 'where clause'

SELECT DISTINCT(rel.child_entry_id) AS entry_id FROM exp_playa_relationships     
rel WHERE rel.parent_entry_id = 5416 AND rel.parent_is_draft = 0 AND
rel.parent_field_id = 188 ORDER BY rel.rel_order
Improve this question
1
  • I'm also having this problem. I'm not using Upgrader.
    – foamcow
    Apr 19, 2013 at 11:37

2 Answers 2

Reset to default
2

Did you follow the upgrade instructions and go to the license key setting page? (http://pixelandtonic.com/playa/docs/updating)

Improve this answer
4
  • This should be the fix. As Andris indicates, go to the CP>Add-Ons>Fieldtypes>Playa, and click Submit. This is the part of the Update that causes the field to be added, and you should be ok from there.
    – narration_sd
    Apr 19, 2013 at 18:25
  • that is, 'causes parent_is_draft to be added' -- couldn't edit comment.
    – narration_sd
    Apr 19, 2013 at 18:37
  • No. I'm afraid going to the CP>Add-Ons>Fieldtypes>Playa, and clicking Submit did not sort the issue! I tried this before posting the question.
    – user579984
    Apr 21, 2013 at 17:50
  • Shoot us an email to [email protected] with CP details and referencing this question in that case - let's have a looksies!
    – Andris Sevcenko
    Apr 22, 2013 at 6:20
0

Upgrader may have failed, but it most likely modified a few things in the database making the manual update not right.

I'd try a few things.

1) Re-import database backup from prior to the failed Upgrader attempt.

if you don't have the backup... 2) Backup now, and uninstall Playa module (not extension), then reinstall the module.

if that didn't work... 3) Contact Playa official support at http://pixelandtonic.com/support

Improve this answer
3
  • I'm afraid that has not worked
    – user579984
    Apr 19, 2013 at 15:32
  • I have reinstalled an earlier version of Playa and it is working ok so the issue doesn't seem to be a DB one.
    – user579984
    Apr 19, 2013 at 15:44
  • Good to hear. Thanks for letting us know.
    – Stephen Callender
    Apr 19, 2013 at 15:48

Your Answer

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

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