Touch site crashing

tsue921i8wljb3 · 19-02-2019 3:56pm #1

I'm sure you aware of the issue but in case not the touch site is currently having issues with most page loads returning an "exception occurred while executing" error.

gctest50 · 19-02-2019 4:00pm

same :

GROUP BY p.threadid': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.postid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

An exception occurred while executing ' -- Find sequential order of a list of posts (independent of the user) SELECT p.threadid , t.postid -- The provided postid , count(p.threadid) AS seq_order FROM ( -- Find the thread(s) the provided postid(s) belong to SELECT threadid , postid , dateline FROM post WHERE postid IN (101701673,82502464,81590413,68216515,109417722,109324870,109346563,109361335,109274381,109231646,109199359,109199247,109066384,108622735,108612360) ) AS t JOIN post AS p USING (threadid) WHERE -- With '<=' we get the actual seq number of that post p.dateline <= t.dateline -- Make sure the post is visible AND visible = 1 GROUP BY p.threadid': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.postid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
© 2019 Boards.ie Ltd. | Terms | Full Site | Responsive Site

gctest50 · 19-02-2019 4:01pm

GROUP BY p.threadid': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.postid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

An exception occurred while executing ' -- Find sequential order of a list of posts (independent of the user) SELECT p.threadid , t.postid -- The provided postid , count(p.threadid) AS seq_order FROM ( -- Find the thread(s) the provided postid(s) belong to SELECT threadid , postid , dateline FROM post WHERE postid IN (101701673,82502464,81590413,68216515,109417722,109324870,109346563,109361335,109274381,109231646,109199359,109199247,109066384,108622735,108612360) ) AS t JOIN post AS p USING (threadid) WHERE -- With '<=' we get the actual seq number of that post p.dateline <= t.dateline -- Make sure the post is visible AND visible = 1 GROUP BY p.threadid': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 't.postid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by