Cannot delete or update a parent row: a foreign key constraint fails

[emmettprexus]

Hashtopolis server: 0.12.0
Hashtopolis client: 0.6.1.6
Hashcat: 6.2.5 (ARM build)

I'm trying to delete a hash-list via the UI and API but get a 500. The following is in the error.log:

[php:error] [pid 137079] [client 192.168.1.49:51129] PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (hashtopolis.AgentZap, CONSTRAINT AgentZap_ibfk_2 FOREIGN KEY (lastZapId) REFERENCES Zap (zapId)) in /var/www/html/dba/AbstractModelFactory.class.php:769\nStack trace:\n#0 /var/www/html/dba/AbstractModelFactory.class.php(769): PDOStatement->execute()\n#1 /var/www/html/inc/utils/HashlistUtils.class.php(510): DBA\\AbstractModelFactory->massDeletion()\n#2 /var/www/html/inc/handlers/HashlistHandler.class.php(65): HashlistUtils::delete()\n#3 /var/www/html/hashlists.php(31): HashlistHandler->handle()\n#4 {main}\n thrown in /var/www/html/dba/AbstractModelFactory.class.php on line 769, referer: http://x/hashlists.php

I was able to reproduce it:

1. Create a hashlist
2. Create a task
3. While task is running, delete the task
4. Delete the hashlist boom

This happens both using the UI and the API.

[s3inlc]

Can you please test if the fix in the issue/747 branch fixes your issue?

[emmettprexus]

Can you please test if the fix in the issue/747 branch fixes your issue?

I have tested the fix and can confirm that it is now working! Great!

[zyronix]

Created pull request for this, tested and can confirm that it is fixed.

[s3inlc]

Thanks for the feedback!