SQL "ORDER BY" Errors

[rbu]

Hi

We today updated from 1.34.16 to 1.34.17 and now we get SQL errors when accessing a camera (to see the events):

SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC limit 20' at line 1', statement was 'SELECT `Id`, `MonitorId`, `Name`, `Cause`, `Notes`, `StartTime`, date_format( StartTime, '%y/%m/%d %H:%i:%S' ) as StartTimeShort, `EndTime`, `Width`, `Height`, `Length`, `Frames`, `AlarmFrames`, `TotScore`, `AvgScore`, `MaxScore` FROM Events WHERE Events.MonitorId = :selector0 ORDER BY DESC limit 20' params:26

According to me: The ORDER BY <field> is missing

DB Update is done...

Any idea?

-Reto

[iconnor]

Fix in 1.34.18. Packages building.

[rbu]

Thanks - looks good for me!