find3
find3 copied to clipboard
Could not get devices error when device name has apostrophe
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