Since v5.7.5 MySQL returns errors for certain badly formed SQL statements. As such Playa v4.5.2 will throw errors.

2 Answers 2


So far I've discovered and fixed one case and will add more here if discovered.

File: mod.playa.php
Line: 550


$sql = 'SELECT DISTINCT(rel.child_entry_id) AS entry_id


$sql = 'SELECT DISTINCT rel.child_entry_id AS entry_id, rel.parent_entry_id, rel.parent_field_id, rel.parent_row_id, rel.parent_col_id, rel.parent_var_id, rel.rel_order

I've encountered errors trying to open Playa fields due to the stricter group by rules (https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by)

In ft.playa.php I changed line 1406 from

GROUP BY m.member_id


GROUP BY m.member_id, m.screen_name, mg.group_title

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.