I have not a testing environment where put this to the test:

delete from k2_items where trash = 1

Of course this will remove everything that is marked as trash, but is there any other table that has data linked to this one creating relational integrity that i can damage by doing this?

1 Answer 1


K2 is not using cascade delete : http://www.mysqltutorial.org/mysql-on-delete-cascade/

It's is safe to run your query. Only trashed articles will be delete.

You can and should do a backup of your table. This is a good practice.

  • I did a backup of the table first just in case something went wrong; it worked perfectly. Thanks!
    – Israelm
    Mar 17, 2016 at 18:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.