find3 icon indicating copy to clipboard operation
find3 copied to clipboard

Could not get devices error when device name has apostrophe

Open svarcoe opened this issue 6 years ago • 0 comments

I get the following database errors on the dashboard page:

could not get devices: select devices.name,count(sensors.timestamp) as num from sensors inner join devices on sensors.deviceid=devices.id WHERE devices.name in ('scott's phone','scott') group by sensors.deviceid: near "s": syntax error

svarcoe avatar Jan 23 '19 23:01 svarcoe