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: Fatal MySQL error after upgrading MySQL

Status	Resolved
Add-on / Version	Publisher 1.6.8
Severity
EE Version	2.10.1

Fred Beeler

Jan 04, 2016

After updating MySQL from 5.6.x to 5.7.x, I am getting a fatal error related to the Publisher add-on. Below is the error I get. I appears that some SQL syntax has been deprecated.

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'mydatabase_ee.rel.parent_entry_id' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT(rel.child_entry_id) AS entry_id FROM exp_playa_relationships rel INNER JOIN exp_channel_titles AS ct ON ct.entry_id = rel.child_entry_id AND ct.`entry_date` < "1451943601" WHERE rel.publisher_lang_id = 1 AND rel.publisher_status = "open" AND rel.parent_entry_id = 200 AND rel.parent_is_draft = 0 AND rel.parent_field_id = 11 ORDER BY rel.parent_entry_id, rel.parent_field_id, rel.parent_row_id, rel.parent_col_id, rel.parent_var_id, rel.rel_order

Filename: third_party/publisher/models/publisher_query.php

Line Number: 110

BoldMinded (Brian)

Did you try disabling Publisher to see if the error still occurs or try a clean EE site using 5.7 and relationship fields? Although that error is from a Publisher file, Publisher is simply modifying the query string to add the lang_id and status columns to the query. Its not changing any ORDER BY, SELECT DISTINCT operators or anything. Basically I’d be surprised if this is a Publisher bug. That is basically 95% a native EE query… this is the only part of it that is not a native Relationship query: rel.publisher_lang_id = 1 AND rel.publisher_status = “open”

Fred Beeler

Ok, that makes sense. I just found 2 related bug reports with Ellis Labs. Unfortunately there is no response at this point.

https://support.ellislab.com/bugs/detail/21444/bugs/detail/21444 https://support.ellislab.com/bugs/detail/21452/relationships-incompatibility-with-mysql-5.7.x

Thanks for your quick response. I will follow-up with Ellis Labs.