UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support Error after upgrade to mysql 5.7

Script: /home/traveltalkonline/public_html/libs/ubbthreads.inc.php
Line#: 1134
SQL Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'travelta_forums.wl.WATCH_TYPE' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL Error #: 1055
Query: SELECT up.USER_REAL_EMAIL, up.USER_LANGUAGE, wl.WATCH_TYPE, u.USER_DISPLAY_NAME, up.USER_TIME_OFFSET, up.USER_TIME_FORMAT FROM ubbt_USER_PROFILE up, ubbt_WATCH_LISTS wl, ubbt_USER_GROUPS ug, ubbt_USERS u WHERE ((wl.WATCH_ID = 11 and wl.WATCH_TYPE = 'f') OR (wl.WATCH_ID = 3 and wl.WATCH_TYPE = 'u') OR (wl.WATCH_ID = 40132 and wl.WATCH_TYPE = 't')) AND up.USER_ID = wl.USER_ID AND ug.USER_ID = up.USER_ID AND up.USER_ID = u.USER_ID AND (wl.WATCH_NOTIFY_IMMEDIATE = 1 OR wl.WATCH_NOTIFY_IMMEDIATE = 2 ) AND up.USER_ID <> 3 AND ug.GROUP_ID IN ( 1, 2, 3 ) AND u.USER_IS_BANNED <> 1 GROUP BY up.USER_ID ORDER BY up.USER_LANGUAGE

the new post is there and looks fine?

your error says

A quick google search provides the solution to correct your SQL configuration
https://stackoverflow.com/questions/23921117/disable-only-full-group-by

Thanks, that did the trick for me.

Seems that the provider wants me to go to mysql 5.8 before long. Any issues? Running 7.6.1

Probably ought to get to the current release at some point before long.