Project

General

Profile

Actions
Copy link

Bug #8457

open

ctfreport fails to show stats for mysql server version 5.7 and above

Added by Anchi Cheng almost 5 years ago. Updated almost 5 years ago.

Status:
New
Priority:
Normal
Assignee:
Anchi Cheng
Category:
-
Target version:
Leginon - Appion/Leginon 3.5
Start date:
01/08/2020
Due date:
% Done:

0%

Estimated time:
Affected Version:
Appion/Leginon 3.4
Show in known bugs:
No
Workaround:

Description

mysql_mode are default to only_full_group_by for these server which is not available in older servers.

Actions
Copy link
 #1

Updated by Anchi Cheng almost 5 years ago

Change the select of nonaggregated column to use any_value() is not back-compatible. Modify the query to select max(c.`REF|leginondata|AcquisitionImageData|image`) in this query to fix it. There will be more of these to fix.

Actions
Copy link

Also available in: Atom PDF