Sqlite3 data insert problem

The issue has been corrected with version 1.0.2:

node-red-stop
cd .node-red
npm install node-red-node-sqlite@1.0.2
node-red-start

Note that when binding a payload the UPDATE also needs to be sent with "$", example:
UPDATE users_connection_data SET connected = $connected, date = $date WHERE ip = $ip;

1 Like