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: Relationship field not work in control panel
| Status | Resolved |
| Add-on / Version | Publisher 3.1.2 |
| Severity | |
| EE Version | 5.3.0 |
Riccardo Melzi
Feb 24, 2020Hello Brian,
I receive the following error in CP publish page when there is a relationship field for the entry:
Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘fluid_field_data_id’ in ‘where clause’:
SELECT `child_id`, `order` FROM (`exp_publisher_relationships`) WHERE publisher_status = “open” AND publisher_lang_id = 2 AND `parent_id` = ‘270’ AND `field_id` = ‘134’ AND `grid_col_id` = 0 AND `grid_field_id` = 0 AND `grid_row_id` = 0 AND `fluid_field_data_id` = 0
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117
Stack Trace: Please include when reporting this error
let me know if you need other infos.
Thank you!
Regards
Riccardo
BoldMinded (Brian)
Feb 24, 2020
Hi, Riccardo. Is this a new Publisher install or an upgrade from a previous version? If it’s an upgrade, which version are you upgrading from?
Riccardo Melzi
Feb 24, 2020
It’s an upgrade. Looking at the release dates of the module I think I have updated from 2.10.8 or a more recent one.
BoldMinded (Brian)
Feb 24, 2020
Riccardo, not sure why but it sounds like a query didn’t get run in the 2.7 update. Try running this query.
Riccardo Melzi
Feb 25, 2020
Thanks Brian, it worked!