So we have a recycle bin with a lot of nodes in it (2000+), whenever we "empty recycle bin" we just get an error about the SQL transaction no longer useable. Any ideas how to manually remove all items in db via SQL rather than Umbraco interface?
You could use SQL Profiler to inspect the queries Umbraco is attempting to run when you try to empty the recycle bin. You can then tweak as necessary to ensure it works.
Even better would be if you could submit a bug report to http://issues.umbraco.org/issues with details so the core team can hopefully reproduce it and fix it.
I will have a look in more detail later in the week, seemed to be complaining about foreign keys so as though references hadn't been deleted first. Will see if I can get it to work.
We had this problem in Azure with a lot of recycled nodes due to the limits imposed on the lower database tiers.
When doing an upgrade we cleared the database locally before resyncing.
May be a similar problem? Worth noticing that increasing our database tier in Azure from Basic to Standard has corrected this problem for us although the recycle bin has never reached the same size.
Anyone know if there is a SQL query we can run directly against the database to delete items out of the media recycle bin? I have over 50K nodes I need deleting...
Empty Recycle Bin
So we have a recycle bin with a lot of nodes in it (2000+), whenever we "empty recycle bin" we just get an error about the SQL transaction no longer useable. Any ideas how to manually remove all items in db via SQL rather than Umbraco interface?
This works for old builds but we are on 7.3.1 http://www.spyriadis.net/2012/06/umbraco-fix-empty-recycle-bin-using-sql-if-backend-fails/
Any help appreciated.
You could use SQL Profiler to inspect the queries Umbraco is attempting to run when you try to empty the recycle bin. You can then tweak as necessary to ensure it works.
Even better would be if you could submit a bug report to http://issues.umbraco.org/issues with details so the core team can hopefully reproduce it and fix it.
Hi Tim,
I was wondering why the script you mentioned didn't work? I use almost the exact same script and I think it works for all our versions.
Do you have any error messages?
Jeffrey
I will have a look in more detail later in the week, seemed to be complaining about foreign keys so as though references hadn't been deleted first. Will see if I can get it to work.
We had this problem in Azure with a lot of recycled nodes due to the limits imposed on the lower database tiers.
When doing an upgrade we cleared the database locally before resyncing.
May be a similar problem? Worth noticing that increasing our database tier in Azure from Basic to Standard has corrected this problem for us although the recycle bin has never reached the same size.
Anyone know if there is a SQL query we can run directly against the database to delete items out of the media recycle bin? I have over 50K nodes I need deleting...
is working on a reply...