ZoneMinder Forums

ZoneMinder Forums
https://forums.zoneminder.com/

Is there a way to import events?

https://forums.zoneminder.com/viewtopic.php?t=33973

Page 1 of 1

Is there a way to import events?

Posted: Tue Jun 17, 2025 2:49 pm
by eldertoon
Hi,

Well, question a bit strange. I believe we had a mounting issue on the event folder and the system decided to cleanup the database with all events that were not on the disk anymore. I corrected the mount, but now I have a lot of events that fill up the space and the system deletes all new events (it considers that the disk space limit is reached and delete the events it knows about).

My question: is there a way to reimport all those events? The workaround is to delete them but I would loose two months.

Thanks

Re: Is there a way to import events?

Posted: Wed Jun 18, 2025 12:15 pm
by iconnor
zmrecover.pl

Re: Is there a way to import events?

Posted: Sat Jun 21, 2025 7:32 am
by eldertoon
Well, I'm too dumb. I did not try to have a look at the included scripts. I confirm, I tested a couple of them and that's OK. Still, it produces a lot of sql errors? See below. But anyway, that was not the subject and topic is now closed. Thank you a lot for your fast answer!

For dumb people as me, as I have a lot to recover and do not care a lot about what is recovered, I need to type Y or ENTER at the prompt, so I used:

Code: Select all

yes | zmrecover.pl

Code: Select all

 
06/21/2025 08:24:08.040088 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (FrameId,Delta,Score,Type,Id,EventId,TimeStamp) VALUES (00259,128.917081594467,0,Normal,undef,2438632,2025-03-30 03:42:19)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.040560 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (TimeStamp,EventId,Type,Id,Score,Delta,FrameId) VALUES (2025-03-30 03:42:19,2438632,Normal,undef,0,129.66508769989,00260)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.041032 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Type,Id,TimeStamp,EventId,FrameId,Delta,Score) VALUES (Normal,undef,2025-03-30 03:42:20,2438632,00261,129.917089939117,0)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.041504 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Delta,Score,FrameId,TimeStamp,EventId,Type,Id) VALUES (130.641095876694,0,00262,2025-03-30 03:42:20,2438632,Normal,undef)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.041981 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (FrameId,Delta,Score,Type,Id,EventId,TimeStamp) VALUES (00263,131.673104524612,0,Normal,undef,2438632,2025-03-30 03:42:21)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.042458 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (EventId,TimeStamp,Type,Id,Delta,Score,FrameId) VALUES (2438632,2025-03-30 03:42:21,Normal,undef,131.685104608536,0,00264)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.043391 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (FrameId,Delta,Score,Id,Type,EventId,TimeStamp) VALUES (00265,132.165108680725,0,undef,Normal,2438632,2025-03-30 03:42:22)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.044368 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (TimeStamp,EventId,Id,Type,Delta,Score,FrameId) VALUES (2025-03-30 03:42:22,2438632,undef,Normal,132.649112701416,0,00266)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.045150 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Score,Delta,FrameId,EventId,TimeStamp,Type,Id) VALUES (0,133.145117044449,00267,2438632,2025-03-30 03:42:23,Normal,undef)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.045910 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Type,Id,EventId,TimeStamp,FrameId,Delta,Score) VALUES (Normal,undef,2438632,2025-03-30 03:42:23,00268,133.429119348526,0)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE) at /usr/share/perl5/ZoneMinder/Object.pm line 267, <> line 14.
06/21/2025 08:24:08.046605 zmrecover[868141].ERR [ZoneMinder::Object:270] [SQL statement execution failed: (INSERT INTO `Frames` (Type,Id,EventId,TimeStamp,FrameId,Score,Delta) VALUES (Normal,undef,2438632,2025-03-30 03:42:24,00269,0,133.917123317719)):Cannot add or update a child row: a foreign key constraint fails (`zm`.`Frames`, CONSTRAINT `Frames_ibfk_1` FOREIGN KEY (`EventId`) REFERENCES `Events` (`Id`) ON DELETE CASCADE)]

Re: Is there a way to import events?

Posted: Sat Jun 21, 2025 6:31 pm
by iconnor
There is -i=0 for turning off interactivity, THe yes | is another good way to do it.

Those errors means that the Event doesn't exist in the db, but it should have been just added. SOmething must have gone wrong inserting the event record.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited