After upgrade Cacti from 1.2.18 to 1.2.27 getting error in PHP

[Soumik]

HI Team,


After upgrade Cacti from 1.2.18 to 1.2.27 getting error in PHP.
Please check below,

2024-08-30 15:12:43 - CMDPHP ERROR: A DB Row Failed!, Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a.`ifIP` NOT LIKE '57.200%'' at line 1
2024-08-30 15:12:40 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller_commands.php[228]:run_data_query(), /lib/data_query.php[144]:update_data_query_sort_cache(), /lib/data_query.php[2241]:get_ordered_index_type_list(), /lib/data_query.php[2122]:CactiErrorHandler())
2024-08-30 15:12:40 - ERROR PHP NOTICE: Undefined index: direction in file: /var/www/html/cacti-1.2.27/lib/data_query.php on line: 2122
2024-08-30 15:12:40 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller_commands.php[228]:run_data_query(), /lib/data_query.php[144]:update_data_query_sort_cache(), /lib/data_query.php[2241]:get_ordered_index_type_list(), /lib/data_query.php[2122]:CactiErrorHandler())
2024-08-30 15:12:40 - ERROR PHP NOTICE: Undefined index: direction in file: /var/www/html/cacti-1.2.27/lib/data_query.php on line: 2122
2024-08-30 15:12:40 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller_commands.php[228]:run_data_query(), /lib/data_query.php[106]:query_snmp_host(), /lib/data_query.php[1204]:CactiErrorHandler())
2024-08-30 15:12:40 - ERROR PHP NOTICE: Undefined index: direction in file: /var/www/html/cacti-1.2.27/lib/data_query.php on line: 1204
2024-08-30 15:12:40 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller_commands.php[228]:run_data_query(), /lib/data_query.php[106]:query_snmp_host(), /lib/data_query.php[1204]:CactiErrorHandler())
2024-08-30 15:12:40 - ERROR PHP NOTICE: Undefined index: direction in file: /var/www/html/cacti-1.2.27/lib/data_query.php on line: 1204
2024-08-30 15:12:40 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller_commands.php[228]:run_data_query(), /lib/data_query.php[106]:query_snmp_host(), /lib/data_query.php[985]:CactiErrorHandler())
2024-08-30 15:12:40 - ERROR PHP NOTICE: Undefined index: direction in file: /var/www/html/cacti-1.2.27/lib/data_query.php on line: 985
2024-08-30 15:12:40 - CMDPHP PHP ERROR NOTICE Backtrace: (/poller_commands.php[228]:run_data_query(), /lib/data_query.php[106]:query_snmp_host(), /lib/data_query.php[985]:CactiErrorHandler())
2024-08-30 15:12:40 - ERROR PHP NOTICE: Undefined index: direction in file: /var/www/html/cacti-1.2.27/lib/data_query.php on line: 985



But we haven't changed anything in script. Could you please tell me solution for this.

Br
Soumik