drawing a blank here. Obviously the mysql schema is missing, but I don't have anything in my code about "Tanks_log". I have no idea where that is coming from
Tanks_log is a table in a custom database the I use in the system that logs more info than the original version that ties into a program with multiple sensors running on a mega2560.
You can follow the latest issues thread on my github for a conversation about the database structure.
if anyone wants to use my code with the enviro1 custom database i have attached a phpMyadmin dump of entire database structure less the data to this message that can be used to import the enviro1 database into your Mysql server.
To use the code i have on github as is one would need to import the enviro1 database and have the original skyweather data base on your mysql server.
The skyweather is only one point of data collection in my system i have custom code based on and old system called "yieldbuddy" running on a mega2560 that directly sends greenhouse controller data and relay control to the enviro1 database that has a custom webpage that interacts with the mega260 code.
I am currently slowly porting it all to ESP32 din rail setup with 3d printed mounts for all the boards, i am working on the mega2560 code now and will eventually get the skyweather board also running on the ESP32 instead of the Pi since I am doing control and would prefer real time processing.
I am moving towards OpenHab 3 integration and have it reporting BMP280, AHT20, Water Flow rate sensor, 3 cap soil moisture sensor readings via MQTT to things in Openhab.
My port is going well. Albeit with my hardware. I can currently run as python 2.7.16 or Python 3.7.3 and get the same results from the same sets of code from the same hardware. My goal is to not only convert to python3 but support any existing python2 platforms with the same code base.
I am going through hardware code that I don't have using pylance linter for python 3.7.3 to identify any visible issue in the code, but I won't be able to test.
Finally after a lot of promises, I was finally able to get into my weather station to get this file. Download, change the extension to .py and place it into the SDL_Pi_SkyWeather directory.
What I did was changed the original directory from SDL_Pi_SkyWeather to SDL_Pi_SkyWeather2. Then go to github.com/ve3sjk/SkyWeather-Python-3 and follow the instructions on the page. There are numerous sensors in this compilation and SDL nor I use these. The above script is for the original equipment which was shipped from SDL in the original SkyWeather project. Download, change the extension to .py and place it into the new (python3) SDL_Pi_SkyWeather directory. Over write the SkyWeather.py file with my changes.
If any one can test to see if there are any problems, please do.
SkyWeather Station running Python3 Script SunControl DIY Solar, Thunderboard IOT, BC24 and many more.