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
Actions