Closed bitchcrazy1 closed 1 day ago
That error means that you already have torrents in that category. Move all torrents in that category to another category first.
hi i have just checked and there is no torrents in that category that i want to delete
I originally forgot about requests, you'll have to check no requests of that category exist as well. After that, you might have some soft-deleted torrents still in that category.
Also, this is a dupe of #3970.
ive used them fixes and still nothing; i have just checked and there is no requests on site either
This has been fixed, there was a torrent in the database for this category but i've found it and deleted it. thank you for your help :)
UNIT3D Version
v8.2.0
PHP & Platform
8.3.12 & Ubuntu 22.04.5 LTS
Laravel verion
11.19.0
Have you done this?
Expectation
I expect when to delete a torrent category it removes it from site
Description
This does not happen because of the following error that the site provides to us:
SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (
unit3d
.torrents
, CONSTRAINTtorrents_category_id_foreign
FOREIGN KEY (category_id
) REFERENCEScategories
(id
) ON DELETE RESTRICT) (Connection: mysql, SQL: delete fromcategories
whereid
= 4)Stack trace & logs
Upvote & Fund