Quote Originally Posted by twitchtoo View Post
Running SQL 5.6 this mod works great.

5.7 and this lookup is no longer supported:
i'm sorry, i just do not agree with that statement....

Quote Originally Posted by twitchtoo View Post
Logs error looks like:
PHP Fatal error: 1055:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'njpbusin_155f_2018.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ::
as you can see from the error log, you no doubt have a different setting for mysql 5.6 v mysql 5.7. these setting do not carry over from version to version.

you can change this mode from the mysql console:

Code:
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
you can read a bit about it here:

https://goo.gl/pnB1HW

else, you can make the change suggested by swguy... although you may have other mysql queries that could fail, as you have different settings in the versions.

best.