On Tue, Feb 21, 2012 at 01:18:43PM +0200, Sergey Karelin wrote: > trying to create the very first host I'm getting error: > 13:13:20 db_ping(mysql) Connection to DB Restored... Query failed - > db_update(hosts) - UPDATE hosts SET name = 'xxxxx',zone = '2',ip = > 'xxx.xxx.xxx.xxx',rocommunity = 'v1:xxx',rwcommunity = '',autodiscovery = > '1',autodiscovery_default_customer = '2',show_host = '1',poll = '1',dmii = > '1',tftp = '',config_type = '1',ip_tacacs = '',sysobjectid = > '',poll_interval = '60',creation_date = '',modification_date = > '1329822795',last_poll_date = '',last_poll_time = ''WHERE hosts.id = '2' - > Incorrect integer value: '' for column 'creation_date' at row 1 Is that happening all the time or is it a one-off? The reason is that the creation_date is set once the host is created and then you update it with the details etc. The code there is pretty simple so I cannot see why it would fail.
Where did this happen? I imagine you went to the hosts table, clicked add, entered stuff and then clicked submit? I just tried that myself in case something got introduced and its working fine. - Craig -- Craig Small VK2XLZ http://enc.com.au/ csmall at : enc.com.au Debian GNU/Linux http://www.debian.org/ csmall at : debian.org GPG fingerprint: 5D2F B320 B825 D939 04D2 0519 3938 F96B DF50 FEA5 ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
