Open-AudIT https://www.open-audit.org/phpBB3/ |
|
How to remove all printers from Open-AudIT v2.0 https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=5809 |
Page 1 of 1 |
Author: | rawnet [ Thu Dec 15, 2011 12:20 am ] |
Post subject: | How to remove all printers from Open-AudIT v2.0 |
Is it possible to remove all scanned printers from OAv2 database? |
Author: | rawnet [ Thu Dec 15, 2011 10:31 pm ] |
Post subject: | Re: How to remove all printers from Open-AudIT v2.0 |
When I'm trying it to remove directly from database I'm getting such an error: [code]Error SQL query: DELETE FROM `audit`.`system` WHERE `system`.`system_id` =1024 MySQL said: #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`audit`.`oa_group_sys`, CONSTRAINT `oa_group_sys_system_id` FOREIGN KEY (`system_id`) REFERENCES `system` (`system_id`)) [/code] Any suggestions? |
Author: | rawnet [ Thu Dec 15, 2011 10:56 pm ] |
Post subject: | Re: How to remove all printers from Open-AudIT v2.0 |
I found a solution! We have to remove all printer records from 'oa_audit_log' and 'oa_group_sys' tables |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |