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, 2020

Hello 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)

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

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)

Riccardo, not sure why but it sounds like a query didn’t get run in the 2.7 update. Try running this query.

ALTER TABLE `exp_publisher_relationships` ADD `fluid_field_data_id` int(10) DEFAULT 0 AFTER `grid_row_id`

Riccardo Melzi

Thanks Brian, it worked!