Ylianst / MeshCentral

A complete web-based remote monitoring and management web site. Once setup you can install agents and perform remote desktop session to devices on the local network or over the Internet.
https://meshcentral.com
Apache License 2.0
4.3k stars 574 forks source link

Fix quoting of string literals from double to single #6530

Closed PTR-inc closed 1 week ago

PTR-inc commented 1 week ago

See: https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted

The function to create a string of an array puts double quotes around the literals used in the sql statements. This is tolerated as explained in the article, but should be corrected to single quotes.

This is only used in the sqlite functions.

It generates a log warning for now, but maybe an error in the future.