Devices are not showing up in Cacti Windows

[soniya]

Seeing below errors , how to fix this :
2024-05-02 15:29:38 - CMDPHP SQL Backtrace: (C:\xampp\htdocs\cacti\clog.php[27]:include(), C:\xampp\htdocs\cacti\include\auth.php[27]:require_once(), C:\xampp\htdocs\cacti\include\global.php[548]:include_once(), C:\xampp\htdocs\cacti\include\global_settings.php[59]:db_fetch_assoc(), C:\xampp\htdocs\cacti\lib\database.php[707]:db_fetch_assoc_prepared(), C:\xampp\htdocs\cacti\lib\database.php[727]:db_execute_prepared())
2024-05-02 15:29:38 - CMDPHP ERROR: A DB Row Failed!, Error: Out of sort memory, consider increasing server sort buffer size
2024-05-02 15:29:38 - CMDPHP SQL Backtrace: (C:\xampp\htdocs\cacti\clog.php[27]:include(), C:\xampp\htdocs\cacti\include\auth.php[27]:require_once(), C:\xampp\htdocs\cacti\include\global.php[547]:include_once(), C:\xampp\htdocs\cacti\include\global_arrays.php[2926]:api_plugin_hook(), C:\xampp\htdocs\cacti\lib\plugins.php[89]:api_plugin_run_plugin_hook(), C:\xampp\htdocs\cacti\lib\plugins.php[231]:plugin_config_arrays(), C:\xampp\htdocs\cacti\lib\plugins.php[1254]:api_plugin_load_realms(), C:\xampp\htdocs\cacti\lib\plugins.php[1217]:db_fetch_assoc(), C:\xampp\htdocs\cacti\lib\database.php[707]:db_fetch_assoc_prepared(), C:\xampp\htdocs\cacti\lib\database.php[727]:db_execute_prepared())
2024-05-02 15:29:38 - CMDPHP ERROR: A DB Row Failed!, Error: Out of sort memory, consider increasing server sort buffer size
2024-05-02 15:29:38 - CMDPHP SQL Backtrace: (C:\xampp\htdocs\cacti\clog.php[27]:include(), C:\xampp\htdocs\cacti\include\auth.php[27]:require_once(), C:\xampp\htdocs\cacti\include\global.php[547]:include_once(), C:\xampp\htdocs\cacti\include\global_arrays.php[1106]:db_fetch_assoc(), C:\xampp\htdocs\cacti\lib\database.php[707]:db_fetch_assoc_prepared(), C:\xampp\htdocs\cacti\lib\database.php[727]:db_execute_prepared())
2024-05-02 15:29:38 - CMDPHP ERROR: A DB Row Failed!, Error: Out of sort memory, consider increasing server sort buffer size
2024-05-02 15:29:25 - CMDPHP SQL Backtrace: (C:\xampp\htdocs\cacti\clog.php[27]:include(), C:\xampp\htdocs\cacti\include\auth.php[27]:require_once(), C:\xampp\htdocs\cacti\include\global.php[548]:include_once(), C:\xampp\htdocs\cacti\include\global_settings.php[59]:db_fetch_assoc(), C:\xampp\htdocs\cacti\lib\database.php[707]:db_fetch_assoc_prepared(), C:\xampp\htdocs\cacti\lib\database.php[727]:db_execute_prepared())
2024-05-02 15:29:25 - CMDPHP ERROR: A DB Row Failed!, Error: Out of sort memory, consider increasing server sort buffer size

[macan]

show variables like 'sort_buffer_size';
SET GLOBAL sort_buffer_size = <higher than returned value>

If error disappeared, save this value in your mysql config:
sort_buffer_size = xxxxx

[TheWitness]

If the server is real small, you need to pay real good attention to the Tech Support page and tune the database properly. Our recommendations are a little aggressive, designed for larger installs. So, just be careful.

[soniya]

Thanks all for the inputs !

Unfortunately could not get this working on Windows

Switched to Linux box ,setup Cacti from scratch and everything is working like a charm .

[TheWitness]

I prefer Linux myself too.