database upgrade still says no

[wiliamL]

Upgraded from 4.2.7 to 5.0.23
MySQL - 5.7.28

Ran the double.sql and the site is stating No for Database history tables upgraded.

https://git.zabbix.com/projects/ZBX/...sql/double.sql

mysql> ALTER TABLE trends
-> MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
-> MODIFY value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
-> MODIFY value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Duplicates: 0 Warnings: 0


Any help greatly appreciated

[Markku]

See the documentation: https://www.zabbix.com/documentation...c-float-values

After upgrading database tables, please also set or update $DB['DOUBLE_IEEE754'] value to true in /ui/conf/zabbix.conf.php.

Usual location for the file is /etc/zabbix/web/zabbix.conf.php.

Markku

[Markku]

See the documentation: https://www.zabbix.com/documentation...c-float-values

After upgrading database tables, please also set or update $DB['DOUBLE_IEEE754'] value to true in /ui/conf/zabbix.conf.php.

Usual location for the file is /etc/zabbix/web/zabbix.conf.php.

Markku

[wiliamL]

Thank you. Not sure how I overlooked that.