CACTI version [1.3.0 Dev]; poller ERROR: CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost_arch_1724899893' doesn't exist

[MSS970]

OS: Windows 2019 CACTI version [1.3.0 Dev]

2024-08-29 06:51:44 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost_arch_1724899893' doesn't exist 2024-08-29 06:51:44 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'po' from one of the SELECTs cannot be used in global ORDER clause

2024-08-29 06:51:44 - SQL Backtrace: (D:\cacti\apache\htdocs\cacti\poller.php[960]:api_plugin_hook(), D:\cacti\apache\htdocs\cacti\lib\plugins.php[96]:api_plugin_run_plugin_hook(), D:\cacti\apache\htdocs\cacti\lib\plugins.php[242]:weathermap_poller_bottom(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\setup.php[1169]:weathermap_run_maps(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\lib\poller-common.php[430]:WeatherMap->ReadData(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\lib\WeatherMap.class.php[1058]:WeatherMapDataSource_rrd->ReadData(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\lib\datasources\WeatherMapDataSource_rrd.php[647]:rrdtool_function_fetch(), D:\cacti\apache\htdocs\cacti\lib\rrd.php[1063]:boost_fetch_cache_check(), D:\cacti\apache\htdocs\cacti\lib\boost.php[306]:boost_process_poller_output(), D:\cacti\apache\htdocs\cacti\lib\boost.php[780]:db_execute_prepared())

2024-08-29 06:51:44 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti.poller_output_boost_arch_1724899893' doesn't exist

2024-08-29 06:51:44 - SQL Backtrace: (D:\cacti\apache\htdocs\cacti\poller.php[960]:api_plugin_hook(), D:\cacti\apache\htdocs\cacti\lib\plugins.php[96]:api_plugin_run_plugin_hook(), D:\cacti\apache\htdocs\cacti\lib\plugins.php[242]:weathermap_poller_bottom(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\setup.php[1169]:weathermap_run_maps(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\lib\poller-common.php[430]:WeatherMap->ReadData(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\lib\WeatherMap.class.php[1058]:WeatherMapDataSource_rrd->ReadData(), D:\cacti\apache\htdocs\cacti\plugins\weathermap\lib\datasources\WeatherMapDataSource_rrd.php[647]:rrdtool_function_fetch(), D:\cacti\apache\htdocs\cacti\lib\rrd.php[1063]:boost_fetch_cache_check(), D:\cacti\apache\htdocs\cacti\lib\boost.php[306]:boost_process_poller_output(), D:\cacti\apache\htdocs\cacti\lib\boost.php[768]:db_fetch_assoc_prepared(), D:\cacti\apache\htdocs\cacti\lib\database.php[909]:db_execute_prepared())

2024-08-29 06:51:44 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'po' from one of the SELECTs cannot be used in global ORDER clause

[MSS970]

I've checked the database, these tables do not exist: Table 'cacti.poller_output_boost_arch_1724899893' Table 'po' (which is an alias to table!)

[WirthmU]

Same here using v1.2.27 and spine: 10-09-2024 09:47:01 - CMDPHP ERROR: A DB Row Failed!, Error: Table 'po' from one of the SELECTs cannot be used in ORDER clause

[TheWitness]

This is fixed in the latest lib/boost.php in the 1.2.x branch. Will be in develop shortly.

Related to #5771

[TheWitness]

Okay, this is fixed now. Please test.

[MSS970]

Much appreciated @TheWitness 👍