Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
An error with Conversations
#6
I created a test thread which generated the error with the modification. I will drop sql_mode restrictions and test again.

Code:
Type: 20
File:  (Line no. 0)
Message
SQL Error: 1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlf_dbHLFv2.c.uid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT * FROM (
               SELECT           p.cid,
                                c.uid,
                                GROUP_CONCAT(p.uid) AS puids,
                                c.subject
               FROM            mybb_cnv_conversations c
               LEFT OUTER JOIN mybb_cnv_participants p
               ON              p.cid = c.cid
               WHERE           c.subject = 'New Reply to thread subscription test 4'
                               AND
                               c.uid IS NULL
               GROUP BY p.cid
              ) innerqry
WHERE puids = '1384'
ORDER BY cid DESC
LIMIT 1
Reply


Messages In This Thread
An error with Conversations - by birdfeedr - 2021-10-20, 10:26 AM
RE: An error with Conversations - by Laird - 2021-10-20, 10:42 AM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 10:47 AM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 10:56 AM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 11:30 AM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 12:20 PM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 01:23 PM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 01:37 PM
RE: An error with Conversations - by birdfeedr - 2021-10-20, 09:57 PM
RE: An error with Conversations - by Laird - 2021-10-21, 03:59 AM
RE: An error with Conversations - by birdfeedr - 2021-10-21, 10:18 AM
RE: An error with Conversations - by birdfeedr - 2021-10-21, 10:36 AM
RE: An error with Conversations - by Laird - 2021-10-21, 04:19 PM

Forum Jump:


Users browsing this thread: 6 Guest(s)