UI delete not working any more - looking for SQL script to delete pages from database directly
Permalink
Hi -
we have concrete5 running beneath a client website automatically importing a great number of pages (about 10.000) based on an XML file every night. Unfortunately there seems to be a bug somewhere, so pages are adding and and don't get deleted anymore. Currently the database is extremely slow and the website crashes after every two clicks.
A quick help would be to delete all pages of this imported page type to clean up the database before getting to bug fixing. But - and this is where I appreciate any help you could give - deletion in the frontend (sitemap) doesn't work. I only get an endless spinning wheel but no pages are getting deleted.
Do you have any ideas how I could delete all pages from one page type (and only these) from the database directly? I'm sure, there has to be an SQL script. Any hints very welcome!
Thank you and best regards,
Nora
we have concrete5 running beneath a client website automatically importing a great number of pages (about 10.000) based on an XML file every night. Unfortunately there seems to be a bug somewhere, so pages are adding and and don't get deleted anymore. Currently the database is extremely slow and the website crashes after every two clicks.
A quick help would be to delete all pages of this imported page type to clean up the database before getting to bug fixing. But - and this is where I appreciate any help you could give - deletion in the frontend (sitemap) doesn't work. I only get an endless spinning wheel but no pages are getting deleted.
Do you have any ideas how I could delete all pages from one page type (and only these) from the database directly? I'm sure, there has to be an SQL script. Any hints very welcome!
Thank you and best regards,
Nora
thank you - that sounds like a start. Does the plugin really just remove old page versions? The currently approved version stays untouched?
Moreover, do you have any idea on how to delete about 7.000 pages at once? I suspect the frontend will never be able to cope with that...
Moreover, do you have any idea on how to delete about 7.000 pages at once? I suspect the frontend will never be able to cope with that...
You may be able to recover by using Extreme Clean to get rid of all old page versions.
http://www.concrete5.org/marketplace/addons/extreme-clean/...
That would also form a basis for development to create a job to actually delete sets of pages.
I did similar a few months ago for an e-shop that needed to clear out about 95% of product pages based on product sets and attributes.