All add-ons currently require PHP 7.4 or greater.

On July 4th 2024 PHP 8.2 will be the new minimum requirement for all add-ons. Expect any add-on released after that date to require 8.2 or greater. Some releases may not immediately take advantage of 8.x specific features in PHP, which means you might, be able to continue using new releases in PHP 7.4, however, if you experience an error the first thing you should do is update to PHP 8.2 then create a support ticket if the error persists.

Please read about the changes to BoldMinded add-on licensing.

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!