Actions
Bug #5205
closedpreset selection in myamiweb could not get the presets in leginon
Start date:
09/11/2017
Due date:
% Done:
0%
Estimated time:
Affected Version:
Appion/Leginon 3.3
Show in known bugs:
No
Workaround:
Description
mysql 5.6 query error
select distinct name FROM AcquisitionImageData a left join PresetData p on (p.DEF_id=a.`REF|PresetData|preset`) where a.`REF|SessionData|session` = 42 order by magnification;
Gives error
ERROR 3065 (HY000): Expression #1 of ORDER BY clause is not in SELECT list, references column 'leginondb.p.magnification' which is not in SELECT list; this is incompatible with DISTINCT
Updated by Anchi Cheng over 7 years ago
Fixed it, but there may be more places where order by is not selected.
Updated by Anchi Cheng over 6 years ago
- Status changed from New to Closed
check all queries in myamiweb searched by distinct. All should function fine.
Updated by Anchi Cheng over 6 years ago
- Target version changed from Appion/Leginon Future Version to Appion/Leginon 3.3
Actions