Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.
Ticket: Added new playa field & now receive database errors after submitting new or updated entry
| Status | Resolved |
| Add-on / Version | Publisher |
| Severity | Critical |
| EE Version | 31 |
Tiffany Taunton
Jul 16, 2013I’ve been setting up Publisher in a new site and all has been working great. - I’ve build out my pages with structure and even have language specific navigations with nav-ee.
I added a new Playa field to my existing channel that has 5 or so existing entries. I tried to update an entry and receive this error:
A Database Error Occurred
Error Number: 1054
Unknown column ‘parent_is_draft’ in ‘where clause’
DELETE FROM `ee_playa_relationships` WHERE `parent_entry_id` = ‘9’ AND `parent_field_id` = ‘27’ AND `parent_is_draft` = 0 AND `publisher_status` = ‘open’ AND `publisher_lang_id` = ‘2’
Filename: third_party/playa/ft.playa.php
Line Number: 2541
It doesn’t matter what language, draft or published OR even if I create a new entry. It will not save. Delete the field and all is good.
Playa 4.4.3
Publisher 1.0.2
(Localhost setup for now)
BoldMinded (Brian)
Hi Tiffany. parent_is_draft is a column added to Playa for Better Workflow support. There was a similar error with Matrix awhile back. You’ll need to add the column manually or report the bug with P&T because it sounds like it didn’t run its update routines properly. With that said, make sure you go to the Modules page and click the Run Updates button in the upper right.
Tiffany Taunton
Thanks for the quick reply. I couldn’t get Playa to update for some reason. Good thing it’s a new site, a complete removal of the add-on, including the ee_playa_relationships table and a fresh install triggered the columns to be added.
Thanks again!