Be sure to checkout our newest add-on Speedy!

EE compatibility updates:

  • Publisher is EE5 compatible, but it does not currently support the Fluid field.

ExpressionEngine.com licenses:

  • 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

#1

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?

#2

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.

#3

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.

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

Riccardo Melzi

Feb 25, 2020

Thanks Brian, it worked!

Login to reply

Contact

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.