Touch site crashing

tsue921i8wljb3

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

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

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

Gatling

Getting the same as above

Boards.ie: Mark

Hey folks, sorry for the disruption. It seems there was an issue with a webnode, but should be rectified now.

tsue921i8wljb3

Boards.ie: Mark wrote: »

Hey folks, sorry for the disruption. It seems there was an issue with a webnode, but should be rectified now.

Yep. Seems back to normal over the past while. Thanks Mark.