Cannot Add new Device

[patricksiu]

Hi Everyone,

I am newbie in Cacti, although my system has been running for 2 year, and updated twice by following guideline in this forum. it was working very well before.
but recently, I found that I cannot add new device, and I found below error message.
please help, and thank you so much.

2021/06/07 14:29:18 - DBCALL ERROR: SQL Save Failed for Table 'host'. SQL:'INSERT INTO host (`id`, `host_template_id`, `poller_id`, `site_id`, `external_id`, `description`, `hostname`, `notes`, `location`, `snmp_version`, `snmp_community`, `snmp_username`, `snmp_password`, `snmp_auth_protocol`, `snmp_priv_passphrase`, `snmp_priv_protocol`, `snmp_context`, `snmp_engine_id`, `snmp_port`, `snmp_timeout`, `disabled`, `availability_method`, `ping_method`, `ping_port`, `ping_timeout`, `ping_retries`, `max_oids`, `bulk_walk_size`, `device_threads`, `monitor`, `monitor_text`, `monitor_criticality`, `monitor_warn`, `monitor_alert`) VALUES (0, 2, 1, 1, '', 'CNSGH300SWI06', '10.86.91.2', '', '', 2, 'WSPV2-RO', '', '', '', '', '', '', '', 161, 500, '', 2, 1, 23, 400, 1, 10, -1, 1, NULL, '', 0, 0, 0) ON DUPLICATE KEY UPDATE `host_template_id`=VALUES(`host_template_id`), `poller_id`=VALUES(`poller_id`), `site_id`=VALUES(`site_id`), `external_id`=VALUES(`external_id`), `description`=VALUES(`description`), `hostname`=VALUES(`hostname`), `notes`=VALUES(`notes`), `location`=VALUES(`location`), `snmp_version`=VALUES(`snmp_version`), `snmp_community`=VALUES(`snmp_community`), `snmp_username`=VALUES(`snmp_username`), `snmp_password`=VALUES(`snmp_password`), `snmp_auth_protocol`=VALUES(`snmp_auth_protocol`), `snmp_priv_passphrase`=VALUES(`snmp_priv_passphrase`), `snmp_priv_protocol`=VALUES(`snmp_priv_protocol`), `snmp_context`=VALUES(`snmp_context`), `snmp_engine_id`=VALUES(`snmp_engine_id`), `snmp_port`=VALUES(`snmp_port`), `snmp_timeout`=VALUES(`snmp_timeout`), `disabled`=VALUES(`disabled`), `availability_method`=VALUES(`availability_method`), `ping_method`=VALUES(`ping_method`), `ping_port`=VALUES(`ping_port`), `ping_timeout`=VALUES(`ping_timeout`), `ping_retries`=VALUES(`ping_retries`), `max_oids`=VALUES(`max_oids`), `bulk_walk_size`=VALUES(`bulk_walk_size`), `device_threads`=VALUES(`device_threads`), `monitor`=VALUES(`monitor`), `monitor_text`=VALUES(`monitor_text`), `monitor_criticality`=VALUES(`monitor_criticality`), `monitor_warn`=VALUES(`monitor_warn`), `monitor_alert`=VALUES(`monitor_alert`)'

2021/06/07 14:29:18 - CMDPHP SQL Backtrace: (C:\inetpub\wwwroot\cacti\host.php[60]:form_save(), C:\inetpub\wwwroot\cacti\host.php[270]:api_device_save(), C:\inetpub\wwwroot\cacti\lib\api_device.php[749]:sql_save(), C:\inetpub\wwwroot\cacti\lib\database.php[1472]:_db_replace(), C:\inetpub\wwwroot\cacti\lib\database.php[1402]:db_execute(), C:\inetpub\wwwroot\cacti\lib\database.php[238]:db_execute_prepared())

2021/06/07 14:29:18 - CMDPHP ERROR: A DB Exec Failed!, Error: Column 'monitor' cannot be null

[patricksiu]

Hello,

Anyone can kindly help?
thank you so much.

[cigamit]

You don't tell us anything pertinent to be able to help you. What Cacti version? What Monitor plugin version?

Your problem seems to be with the monitor plugin, I would try uninstalling it or making sure you are running the latest for your version of Cacti.
It may also be an issue with your MySQL running in strict mode? Hard to tell.

[patricksiu]

Thanks a lot for your comment!!!
I am now using Version 1.2.17
you make me realize that I have force to ENABLE monitor setting to during add new device.
it is now working. by the way, how to remove those "monitor plug-in"? I dont remember I have install it.
Thanks again!