Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2011
Posts: 6
E
Stranger
Stranger
E Offline
Joined: Dec 2011
Posts: 6
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?

Last edited by ehill; 04/23/2023 1:17 PM.
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145
your error says
Quote
incompatible with sql_mode=only_full_group_by

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


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
1 member likes this: Gizmo
Joined: Dec 2011
Posts: 6
E
Stranger
Stranger
E Offline
Joined: Dec 2011
Posts: 6
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.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Upgrading supporting apps (mysql, php)
by Baldeagle - 06/09/2024 8:39 AM
Questions re: forum layout and site issues
by domspeak - 06/03/2024 1:49 AM
Test
by Phun - 05/28/2024 7:31 PM
Who's Online Now
0 members (), 407 guests, and 166 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)