HomeAutomation v3.2 released

http://karpero.mine.nu/ha

Moderators: Daniel, tom_rosenback, Telldus

Post Reply
tom_rosenback
Posts: 779
Joined: Fri Mar 17, 2023 9:45 am
Contact:

HomeAutomation v3.2 released

Post by tom_rosenback »

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: 317
Joined: Fri Mar 17, 2023 9:45 am

Re: HomeAutomation v3.2 released

Post by Daniel »

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: Fri Mar 17, 2023 9:45 am

Re: HomeAutomation v3.2 released

Post by jesperl »

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: 779
Joined: Fri Mar 17, 2023 9:45 am
Contact:

Re: HomeAutomation v3.2 released

Post by tom_rosenback »

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