Domoticz

Hi

I try to put a link into a text-sensor (dummy)
Value of the text sensor
string value

test='<A href="https://google.nl/maps/search/ 51.xxxxx,4.xxxxx" target="_blanc"><font size="3" color="000000">Sometext</font></a>'

code used to put it in the text sensor :

commandArray[#commandArray + 1] = {['UpdateDevice'] = '638'..'|0|'..test}

error in the log :

2017-10-09 19:09:13.456 Error: SQL Query("UPDATE DeviceStatus SET nValue='0',sValue='Sometext ',LastUpdate='2017-10-09 19:09:13' WHERE (ID = '638')") : near "3": syntax error

Does anybody understand why i get these errors ???
(It worked before for months now since update to V3.8552 i see these errors !)
The weird thing is that the text sensor actually is updated.. and the link is working (masked sensitive data with XXXX on above link)
So it is pure SQL driven somehow

Many many thanks in advance

Use a print statement of the exact contents of the text string, I think something goes wrong with quotes or so.