Created a ticket with a primary asset and several additional assets. Went back to change the primary asset and move the old primary to additional. Received a post.php 500 internal server error
Log captured:
[Mon May 19 10:36:14.726387 2025] [php:error] [pid 2393904:tid 2393904] [client w.x.y.z:44360] PHP Fatal error: Uncaught mysqli_sql_exception: Cannot add or update a child row: a foreign key constraint fails (`itflow`.`ticket_assets`, CONSTRAINT `ticket_assets_ibfk_1` FOREIGN KEY (`asset_id`) REFERENCES `assets` (`asset_id`) ON DELETE CASCADE) in /var/www/html/post/user/ticket.php:204
\nStack trace:\n#0 /var/www/html/post/user/ticket.php(204): mysqli_query()
\n#1 /var/www/html/post.php(49): require_once('...')
\n#2 {main}
\n thrown in /var/www/html/post/user/ticket.php on line 204, referer: https://itflow.server.domain/ticket.php?ticket_id=4516