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!!
HomeAutomation v3.2 released
Moderators: Daniel, tom_rosenback, Telldus
-
- Posts: 779
- Joined: Fri Mar 17, 2023 9:45 am
- Contact:
HomeAutomation v3.2 released
//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
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
Re: HomeAutomation v3.2 released
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
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
Latest info and release of HomeAutomation can be found here http://karpero.mine.nu/ha
Re: HomeAutomation v3.2 released
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
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
-
- Posts: 779
- Joined: Fri Mar 17, 2023 9:45 am
- Contact:
Re: HomeAutomation v3.2 released
Thank you, added to code too will be releasing a new version here soon.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) columnCode: 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
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
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