Closed Susanin63 closed 4 years ago
mac_track_devices and mac_track_device_types don't have unique index on device_id and device_type_id columns. When you edit any device type and change any of (sysDescr_match, sysObjectID_match, `device_type') this will dubl row in table. Need add unique index OR don't use device_type_id on save sql https://github.com/Cacti/plugin_mactrack/blob/77bff4acf78386854ff5f1705b159ce98d2ab115/mactrack_device_types.php#L167
sysDescr_match
sysObjectID_match
Creating an index is better.
Also this fix #82
Thanks for keeping this baby alive!
mac_track_devices and mac_track_device_types don't have unique index on device_id and device_type_id columns. When you edit any device type and change any of (
sysDescr_match
,sysObjectID_match
, `device_type') this will dubl row in table. Need add unique index OR don't use device_type_id on save sql https://github.com/Cacti/plugin_mactrack/blob/77bff4acf78386854ff5f1705b159ce98d2ab115/mactrack_device_types.php#L167Creating an index is better.
Also this fix #82