Deprecation warnings when attempting real-time Graphs with PHP8.1

[manhvu1997]

I installed cacti 1.2.20. I created a graph and device success, but when I viewed the graph in realtime, I faced the issue below:

The log file said:
2022-07-01 12:44:11 - ERROR PHP DEPRECATED: Implicit conversion from float 35.4375 to int loses precision in file: /var/www/html/cacti/lib/rrd.php on line: 3670
2022-07-01 12:44:11 - CMDPHP PHP ERROR Backtrace: (/graph_realtime.php[244]:rrdtool_create_error_image(), /lib/rrd.php[3670]:wordwrap(), CactiErrorHandler())

Can you help me to fix that?

[netniV]

This bug still exists under v1.2.22, what PHP version are you running?

[manhvu1997]

Thanks for your reply
My PHP version is 8.1

[TheWitness]

I saw this the other day and neglected to look into it.

[manhvu1997]

How can I change the PHP core from PHP 8.1 to PHP 7.4 on cacti?

[TheWitness]

You should not need to downgrade as this is a very narrowly defined error and only happens when your Data Sources have not had their RRDfiles created. But if you still want to do it, you need to do it through aptitude (apt).

[manhvu1997]

I fixed it, but I faced new issue, can you help me to fix this:

[TheWitness]

Closing this one now as the first bug was fixed.

This second issue is better served on the forums as its not a bug.

Basically, you database is setup using one collation/charset and was not fully migrated.

Best thing to do is go to Console > System Utilities > Technical Support then scroll to the bottom to see how wrong your charset and collation are from the database side.

Then make the required changes and restart the database. After that, reverify from that page, and if all is good, run the CLI script convert_tables.php using the utf8 option and innodb options.

[manhvu1997]

Thank you theWitness
All proplems were solved by running command "/usr/bin/php /var/www/html/cacti/cli/convert_tables.php --debug --innodb --utf8"