HomeAutomation v3.2 released

http://karpero.mine.nu/ha

Moderators: tom_rosenback, Daniel, Telldus

Post Reply
tom_rosenback
Posts: 778
Joined: Thu Jan 18, 2018 11:08 am
Contact:

HomeAutomation v3.2 released

Post by tom_rosenback » Thu Jan 18, 2018 11:08 am

Hi,

Even thou it is 1st of april this isn´t a joke, HomeAutomation v3.2 is now released. Biggest change in this version is that the communication with the database has been completely rewritten to use Mysqli instead of Mysql. Main reason for the rewrite is that PHP7 no longer support Mysql. One other thing which has been done is optimization of database queries so now the whole system is much faster than previous versions. At the same a complete check for PHP7 support has been made so now it is safe to use PHP7 too.

To update to this version it is recommended that you rename / move the old installation to another location, unzip this version to the desired location and then copy config.php and system/mysql_settings.php from the old installation to the new.

Also please check that you have mysqlnd installed and active in your PHP installation.

v3.2 2016-04-01
- [General] Fully PHP7 compatible
- [General] Completely rewritten database handling, now uses mysqli. Much faster.
- [General] Now compatible and tested with PHP 7
- [General] Refactored code to use object oriented php

Download here http://karpero.mine.nu/ha

Please report any issues if you encounter any!!
//Tom

Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha

Daniel
Posts: 315
Joined: Thu Jan 18, 2018 11:08 am

Re: HomeAutomation v3.2 released

Post by Daniel » Thu Jan 18, 2018 11:08 am

Wehehey!

Just for the record for all Linux users: To check which php mysql extensions you have, just run "php -m|grep mysql" and check so that you have both mysqli and mysqlnd in the list you get. If not, install it. If you are living in Ubuntu/Debian land, it's just a "apt-get install php5-mysqlnd".

If you are a Windows user, I don't think you need to worry about this.

/Daniel
Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha

jesperl
Posts: 6
Joined: Thu Jan 18, 2018 11:08 am

Re: HomeAutomation v3.2 released

Post by jesperl » Thu Jan 18, 2018 11:08 am

I've got problems with the 30 min reading on the sensor page. I looked at the code and found an error in the sql query.

Correct query, there was a missing column header in the ROUND(temp_c, 1) column

Code: Select all

SELECT s.name, st.unit, ROUND(temp_c, 1) AS actual FROM temps t INNER JOIN tempsensors s ON t.sensor_serial = s.serial INNER JOIN sensortypes st ON st.id = s.sensortype WHERE date > DATE_SUB(NOW(), INTERVAL 1800 SECOND) GROUP BY t.sensor_serial ORDER BY date DESC

tom_rosenback
Posts: 778
Joined: Thu Jan 18, 2018 11:08 am
Contact:

Re: HomeAutomation v3.2 released

Post by tom_rosenback » Thu Jan 18, 2018 11:08 am

jesperl wrote:I've got problems with the 30 min reading on the sensor page. I looked at the code and found an error in the sql query.

Correct query, there was a missing column header in the ROUND(temp_c, 1) column

Code: Select all

SELECT s.name, st.unit, ROUND(temp_c, 1) AS actual FROM temps t INNER JOIN tempsensors s ON t.sensor_serial = s.serial INNER JOIN sensortypes st ON st.id = s.sensortype WHERE date > DATE_SUB(NOW(), INTERVAL 1800 SECOND) GROUP BY t.sensor_serial ORDER BY date DESC
Thank you, added to code too will be releasing a new version here soon.
//Tom

Senaste info och release om/av HomeAutomation hittas här http://karpero.mine.nu/ha
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha

Post Reply