ExpressionEngine 2.5.3 now erroring on SQL 5.7

Hi Guys,

I’ve just upgraded a local MAMP installation for developing my EE sites, and it’s now running on MYSQL 5.7.

I have a site running EE 2.5.3 and it’s quite large with lots of add-ons/external PHP scripting etc (hence a nightmare to upgrade!).

The error is:

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column ‘cornucopia_mobile.t.sticky’ which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT(t.entry_id) FROM exp_channel_titles AS t LEFT JOIN exp_channels ON t.channel_id = exp_channels.channel_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id INNER JOIN exp_category_posts ON t.entry_id = exp_category_posts.entry_id INNER JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id WHERE t.entry_id !=” AND t.site_id IN (‘1’) AND t.entry_date < 1536310376 AND (t.expiration_date = 0 OR t.expiration_date > 1536310376) AND t.channel_id = ‘2’ AND exp_categories.cat_id = ‘84’ AND t.status = ‘open’ ORDER BY t.sticky desc, t.entry_date desc, t.entry_id desc LIMIT 0, 3

Filename: modules/channel/mod.channel.php

Line Number: 2736

I noticed you guys applied a fix/patch for EE 2.10.x onwards a long time ago!

I’m just wondering if there is a quick fix for my 2.5 installation?

Like I say the site is way too complicated to upgrade to the last version of 2.x because of external custom scripting etc.

Any quick fixes to my 2.5.3 installation would be really appreciated if possible?

Kind Regards

Karl