schollz / find3

High-precision indoor positioning framework, version 3.
https://www.internalpositioning.com/doc
MIT License
4.63k stars 364 forks source link

Could not get devices error when device name has apostrophe #134

Open svarcoe opened 5 years ago

svarcoe commented 5 years ago

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