turned of the STRICT setting like a previous post, now getting
[2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','') [2016/02/08 12:41:08 +1100] poller.php(32679): Failed dbQuery (#1062 - Duplicate entry '473-' for key 'unique_index'), Query: INSERT INTO `ipsec_tunnels` (`device_id` ,`peer_addr`,`local_addr`,`tunnel_name`) VALUES ('473','','','')
device_id appears to be a unique index but it appears multiple times in the table. (Embedded image moved to file: pic25943.gif) (Embedded image moved to file: pic03133.gif)
thanks
Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine@familycourt.gov.au
********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************
