[BUG]: Deleting access group while still files are inside access group causes PDO exception

[zyronix]

Version Information

0.14.3

Hashcat

No response

Description

1. Create new accessgroup
2. Add user to access group
3. Create file (add to access_group)
4. Delete access group

Get error:

[client:39332] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`hashtopolis`.`File`, CONSTRAINT `File_ibfk_1` FOREIGN KEY (`accessGroupId`) REFERENCES `AccessGroup` (`accessGroupId`)) in /var/www/html/src/dba/AbstractModelFactory.class.php:747\nStack trace:\n#0 /var/www/html/src/dba/AbstractModelFactory.class.php(747): PDOStatement->execute()\n#1 /var/www/html/src/inc/utils/AccessGroupUtils.class.php(188): DBA\\AbstractModelFactory->delete()\n#2 /var/www/html/src/inc/handlers/AccessGroupHandler.class.php(18): AccessGroupUtils::deleteGroup()\n#3 /var/www/html/src/groups.php(28): AccessGroupHandler->handle()\n#4 {main}\n  thrown in /var/www/html/src/dba/AbstractModelFactory.class.php on line 747,