Hello,
I am using a sqlite databank to store a few datas in there and getting them into a dashboard.
But after my Pi breakdown and reboot, the data are not store.
There is the following error in Node red: " Error: SQLITE_ERROR: no search table: working values "
Is there any chance to save the datas Crash safely in the databank?
Is that a copy/paste of the error or have you retyped it? If you have retyped can you check it is absolutely correct please, it doesn't look right to me.
Either way what is the query that you are passing in that causes that error?
Interesting, I have never seen that error. “No such table” certainly, but not “No search table” and google doesn’t say anything helpful as far as I can see.
Check using another client (such as command line sqlite) that the table exists. If it does then feed the query into a debug node and paste the result here please (that is actually what I meant by asking what the query is).
okay i got my fault, after I reinstall sqlite, there was this error again, so i checked again my data base and just find a Syntax Problem, one of my names in the database has the same Name than a comand in SQL…