PiHome community always working very hard to improve your experience of Smart Heating. PiHome version 1.76 is packed with some serious improvements and bug fixes. If you have any feedback or run into any issues you can always find help on PiHome site. This release packed with some serious improvements and bug fixes.
Highlights in This Release
There are over 450 changes to PiHome since Last release version 1.75, to name few of major changes:
#288 Circulation Pump Overrun #263 settings from gui
#274 Backend changes for boiler circulation pump overrun
#289 homelist overrun indication
#245 Add-On: Electrical Immersion Control
#253 Introduce Zone Categories and implement in boiler.php flow control
#256 Improve readability of schedule processing nested if block and fix bug for Cat2 Zone processing
#262 Sync homelist zone status with boiler.php #49
#268 Implement Add-On logging and status indicators for add-ons (status indicator moved to a function for multiple usage)
#272 Delete Nodes/Sensors from Settings
#280 Initial Version of Add-On Controller Sketch
#284 #283 Fix Performance Issue homelist.php
#285 zone fault indication on homelist bugfix
#296 battery chart
#300 Update notice
#304 Update gpio_ds18b20
#306 Update MySensors Gateway python Script
#328 Fix for Add Node GUI plus Virtual Node Type
#329 Sonoff update to gateway script
#341 Process Sonoff ON/OFF Button
#348 GUI for Sonoff HTTP commands
#350 Allow creation of HTTP messages for Tasmota type nodes not yet allocated to a zone
Special thanks to the people who have contributed code and ideas to this release:
Update your PiHome Smart Heating installation even if you do not want to use new features, new release also include some bug fixes.
How To update
Login to your PiHome via ssh and follow these steps to update your PiHome Smart Heating.
Update Raspberry pi
sudo apt update
sudo apt upgrade
Python 3 installation
sudo apt-get install python3-mysqldb
sudo apt-get install python3-pip
sudo pip3 install RPI.GPIO
sudo pip3 install adafruit-blinka
sudo pip3 install pyserial
Set Python 3 as Default
Set python 3 as default:
Add the following after the last line in the file
To implement the change:
Update PiHome Software
git pull origin
Execute the ‘migrate_db.php’ file found in the directory ‘MySQL_Database’, this will update the database structure and migrate the existing ‘zone’ table data, it will also update the views as required.
Update the other files in the normal manner.
Updated PiHome Database
Wiring Pi Deprecated
Wiringpi is deprecated and no longer supported by PiHome, If you are using Raspberry pi GPIO to controller your zone or boiler make sure you update GPIO pin number to physical pin number of your Raspberry pi.
Help for Next PiHome Release
If you’re interested in helping out please checkout GitHub for issue. If you like PiHome Smart Heating Controller please consider starring the project on GitHub and like us on Facebook (https://www.facebook.com/PiHomeHVAC)
Going through the above update steps and after running “php update_db.php”, i get the following error message which is non fatal …
Existing Database Table Structures will be amended.
Are you sure you want to do this? Type ‘yes’ to continue?
2020-08-08 10:19:07 – Creating Dump File for Exiting Database.
2020-08-08 10:19:08 – Compressing Database Dump File pihome_2020-08-08_10-19-07.sql
2020-08-08 10:19:09 – Compressed Database Dump File pihome_2020-08-08_10-19-08.zip
2020-08-08 10:19:09 – Applying Updates to Database.
MySQL Database Error with Query ALTER TABLE
piconnect_logsMODIFY PRIMARY KEY (
: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 ‘PRIMARY KEY (
id)’ at line 1
2020-08-08 10:19:50 – Database Updates Applied
2020-08-08 10:19:50 – Importing SQL Table View File to Database, This could take few minuts.
2020-08-08 10:19:56 – DataBase File /var/www/MySQL_Database/MySQL_View.sql Imported Successfully
2020-08-08 10:19:56 – Update Version: 1.76
2020-08-08 10:19:56 – Update Build: 020820
2020-08-08 10:19:56 – MySQL Update DataBase Script Ended
Hi Ian, you can ignore this error message.
Update from 1.75 to 1.76 went well except for the last 2 commands. Needed to use sudo.
php migrate_db.php need to be sudo php migrate_db.php
php update_db.php need to be sudo php update_db.php