10-16-2021, 03:04 PM
(10-16-2021, 02:41 PM)sjlesq99 Wrote: This morning, my probes were not reading. I had to reboot and everything is working again. Not a big deal. Just thought I’d let you know.
That's not cool, pH or temps? Honestly running this thing almost a year sensors have never stopped, very disappointing, thanks for letting me know, let me know if it happens again, in the meantime I will go over things.
(10-16-2021, 02:41 PM)pwest Wrote: That all works, except there is no 'users' table under 'robotank'. There is a list of 23 tables starting with '3c01..._C' and ending with 'scheduleType'.
-Phil
Brutal, that's not the full database, just checked the file that creates the database and there's a missing comma. I added an extra field to a table and when I updated this file I copied and pasted the line but didn't add the comma so it stopped from there.
Try the following commands in the Pi terminal, this should fix it.
sudo rm Robo-Tank_v6_1.zip
sudo systemctl stop robotank.service
sudo wget -c https://www.robo-tank.ca/app/releases/Robo-Tank_v6_1.zip
sudo unzip -o Robo-Tank_v6_1.zip -d /boot/
sudo mysql --user=root --password=robotank < /boot/robotank/install/robotank_database.sql
sudo rm Robo-Tank_v6_1.zip
sudo rm -r /boot/robotank/
sudo systemctl start robotank.service