Error Msg (txt version)

We encountered a problem. The reason reported was
Script: /users/oakmediacreations.com/htdocs/forums/libs/ubbthreads.inc.php
Line#: 1111
SQL Error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_ubb.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 = 31 and wl.WATCH_TYPE = 'f') OR (wl.WATCH_ID = 2 and wl.WATCH_TYPE = 'u') OR (wl.WATCH_ID = 37323 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 <> 2 AND ug.GROUP_ID IN ( 1, 3, 2 ) AND u.USER_IS_BANNED <> 1 GROUP BY up.USER_ID ORDER BY up.USER_LANGUAGE

Please click [ Back ] to return to the previous page.


I am a Superstar! Testing signature here