Project

General

Profile

Actions

Bug #8457

open

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

Added by Anchi Cheng over 4 years ago. Updated over 4 years ago.

Status:
New
Priority:
Normal
Assignee:
Category:
-
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 #1

Updated by Anchi Cheng over 4 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

Also available in: Atom PDF