更新时将删除行设置为特定值

Due to poor coding, our site has a heart attack when any user tries to delete a contact category from the back end of Joomla (SQL 5.5). Instead of deleting it, it updates the "published" column to -2 (where 1 is published, and -1 is not published). Unable to find the source that causes this, we've almost imediately moved to trying to create a trigger to delete the category entirely.Due to poor coding, our site has a heart attack