Sitemap.xml still includes deleted pages after re-indexing1 user found helpful
I'm running 22.214.171.124 and a number of add-ons. Many of the deleted pages were from the forum add-on (which I uninstalled, then deleted all the pages).
Anyone know how to correct this?
The deleted pages are still in the database (collections table). Is there a way to purge deleted pages? Optimize the tables?
in the collections table.
Can anyone else reproduce this?
CEO - concrete5.org
Actually, we shut the forums down because they were being auto-spammed. There were so many pages -- I didn't want to have to delete thousands of them one by one, so I deleted their parent page (the forums page) to remove them quickly.
My experience is when you delete a parent page in the sitemap, the child pages also get deleted:
"Are you sure you wish to delete this page?
This will remove 2 child page(s).
Deleted pages are moved to the trash can in the sitemap."
I added a page to the root (same level as home), then added two sub-pages directly below that page. Viewed the pages to see if they looked okay, everything is fine.
Then I went back into the dashboard to the sitemap and deleted the first page, got the message about "this will remove 2 child pages(s)." I removed all three and none are visible in the sitemap.
Logged into PHPMyAdmin, looked at the collections table, and all three are still there, the last records in the table.
Hope this helps you pinpoint the source of the problem. I don't know the inner workings of Concrete5 well enough to know where to begin, but it appears the code to remove the pages from the database isn't doing what it's supposed to?
I upgraded the site to 5.5 and beyond while all the unwanted forums posts were still in there, then deleted after the upgrade. Everything appears to be working well except the site is running very slowly, that's when I investigated and found the old forum posts still in the database and sitemap.xml file.