I'm trying to set up a SQLite database for DHT22 sensor readings. I seem to be able to create the DB and set up the DB table OK. The issue is that when I attempt to insert values into the table I get a Error: no such column: 'foo'. I also tried a alternate method and the same thing happened. Then it refused to let me quit or get help. Finally had to crash out of SQLite.
Had to reboot and then it did the same. Tried reinstalling SQLite3 and no help. I would like to make this work but I'm out of options.
Any thoughts?
Thanks
Apple Mac Book
Raspi 2b
Raspbain Jessie, Updated Upgraded
Adafruit_Python_DHT.git setup and tested
I2S setup and tested
SQLite3
I see unicode U2018 ‘ and U2019 ’ left quote and right quotes.
When I should be seeing two U0027 ' at either end of the string.
From Mac term, seems to work ok from Pi term
Had to reboot and then it did the same. Tried reinstalling SQLite3 and no help. I would like to make this work but I'm out of options.
Any thoughts?
Thanks
Apple Mac Book
Raspi 2b
Raspbain Jessie, Updated Upgraded
Adafruit_Python_DHT.git setup and tested
I2S setup and tested
SQLite3
I see unicode U2018 ‘ and U2019 ’ left quote and right quotes.
When I should be seeing two U0027 ' at either end of the string.
From Mac term, seems to work ok from Pi term