After a long search and a reinstall of Mariadb and PHPMyAdmin, I finally found the cause of the trouble.
My iSpindles run on firmware 6.2.0 released at 17-11-2019 in the log below you can see the message what is coming from the iSpindle and that is meshing up the data table. They did work OK in the previous version before the database changes. Please have good look at the log below and see what the message from the iSpindle is doing with the Data Table. Special at 'token' and 'temp_units'
Code: Alles auswählen
pi@mcmellow-pi:/usr/local/bin $ python iSpindle.py
waiting for connection... listening on port: 9501
...connected from: ('192.168.99.92', 43706)
waiting for connection... listening on port: 9501
Data for all Spindels is older than 3 days
...connected from: ('192.168.99.93', 60800)
waiting for connection... listening on port: 9501
('192.168.99.93', 60800) received:'{'
('192.168.99.93', 60800) Input Str is now:{
('192.168.99.93', 60800) received:'"name":"iSpindel-Zwart","ID":6450943,"token":"BBFF-PiYIGdh8CJAcswM4p2Xbggsv9kgq32","angle":68.47326,"temperature":22.25,"temp_units":"C","battery":4.139729,"gravity":32.404,"interval":20,"RSSI":-52}\r\n'
('192.168.99.93', 60800) Input Str is now:{"name":"iSpindel-Zwart","ID":6450943,"token":"BBFF-PiYIGdh8CJAcswM4p2Xbggsv9kgq32","angle":68.47326,"temperature":22.25,"temp_units":"C","battery":4.139729,"gravity":32.404,"interval":20,"RSSI":-52}
('192.168.99.93', 60800) Sent ACK.
('192.168.99.93', 60800) Time elapsed: 0.002262
('192.168.99.93', 60800) iSpindel-Zwart (ID:6450943) : Data Transfer OK.
('192.168.99.93', 60800) - closed connection
('192.168.99.93', 60800) Reading last recipe name for corresponding SpindeliSpindel-Zwart
('192.168.99.93', 60800) Recipe Name not found - Database Error: 'NoneType' object has no attribute '__getitem__'
('192.168.99.93', 60800) Reading last recipe_id value for corresponding SpindeliSpindel-Zwart
Recipe_ID: Done. None
('192.168.99.93', 60800) - writing to database
('192.168.99.93', 60800) - key 'angle is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'angle': adding to database.
('192.168.99.93', 60800) - key 'angle': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) - key 'name is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'name': adding to database.
('192.168.99.93', 60800) - key 'name': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) - key 'battery is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'battery': adding to database.
('192.168.99.93', 60800) - key 'battery': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) - key 'interval is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'interval': adding to database.
('192.168.99.93', 60800) - key 'interval': Error: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'interval double' at line 1
('192.168.99.93', 60800) - key 'gravity is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'gravity': adding to database.
('192.168.99.93', 60800) - key 'gravity': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) - key 'token is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'token': adding to database.
('192.168.99.93', 60800) - key 'token': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) - key 'temp_units is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'temp_units': adding to database.
('192.168.99.93', 60800) - key 'temp_units': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) - key 'temperature is not yet listed, adding it now...
('192.168.99.93', 60800) - key 'temperature': adding to database.
('192.168.99.93', 60800) - key 'temperature': exists. Consider adding it to defaults list if you want to keep it.
('192.168.99.93', 60800) Database Error: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'interval, gravity, token, temp_units, temperature) VALUES ('2020-04-10 22:42:32.' at line 1
Did you update your database?
Data for all Spindels is older than 3 days
^CTraceback (most recent call last):
File "iSpindle.py", line 844, in <module>
main()
File "iSpindle.py", line 838, in main
clientsock, addr = serversock.accept()
File "/usr/lib/python2.7/socket.py", line 206, in accept
sock, addr = self._sock.accept()
KeyboardInterrupt
pi@mcmellow-pi:/usr/local/bin $
I hope you can follow me. Can you tell me what firmware version your iSindle is at.