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?


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 '16 at 18:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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