Error: SQL Query (Battery state)', 1, 0, 'medium')") : near ","

Please use template to report bugs and problems. Post here your questions when not sure where else to post
Only for bugs in the Domoticz application! other problems go in different subforums!

Moderators: leecollings, remb0

Forum rules
Before posting here, make sure you are on the latest Beta or Stable version.
If you have problems related to the web gui, clear your browser cache + appcache first.

Use the following template when posting here:

Version: xxxx
Platform: xxxx
Plugin/Hardware: xxxx
Description:
.....

If you are having problems with scripts/blockly, always post the script (in a spoiler or code tag) or screenshots of your blockly

If you are replying, please do not quote images/code from the first post

Please mark your topic as Solved when the problem is solved.
Post Reply
User avatar
Varazir
Posts: 432
Joined: Friday 20 February 2015 22:23
Target OS: Raspberry Pi / ODroid
Domoticz version: Beta
Contact:
Contact Varazir

Error: SQL Query (Battery state)', 1, 0, 'medium')") : near ","

Post by Varazir »

Hello,

I just added 2 Tuya TS0601 Soil sensors.

I'm keep getting the same error on both

Code: Select all

2025-07-03 20:03:05.546 Error: SQL Query("INSERT INTO ID, DeviceStatus (HardwareID, OrgHardwareID, DeviceID, Unit, Type, SubType, SignalLevel, BatteryLevel, Name, Used, nValue, sValue) VALUES (12, 0, '0xa4c138c458e76308_battery_state_zigbee2mqtt', 1, 243, 19, 3, 33, 'Tuya - Soil sensor - Green (Battery state)', 1, 0, 'medium')") : near ",": syntax error

Domoticz 2025.1 (build 16733)
Z2M 2.5.0 commit: c0cd2c6b96c93f4cd520aac5ae0565e08d0af8c7
Raspberry PI 2 with RaZberry Controller 2016 ZWave+ and CC2531(zigbee)
Several IKEA devices/z-wave devices
Top
Post Reply

Return to “Bugs and Problems”

Who is online

Users browsing this forum: No registered users and 1 guest