Trash spinning

Permalink
I'm new to C5 and it's been great so far but I've encountered one issue. The trash in the sitemap just spins and never deletes anything. Any advice on how to manage/resolve this?

Thanks

 
adajad replied on at Permalink Reply
adajad
Try to clear your site cache and empty the trash again. If the spinner gets stuck again, then start delete the pages one by one until trash is empty. Once the trash is empty you can create some dummy pages and delete those, then try to empty the whole trash again.

This has happened to me too, but I never looked into it any deeper.

What version of c5 are you on?
CDMadmin replied on at Permalink Reply
I'm having the same problem, and I have 74 pages to delete. It takes 5 minutes just to delete 1 page. I cleared the cache already, and that doesn't seem to help. Has anyone been able to fix this issue? I haven't installed the latest upgrade because I've read too many horror stories about upgrading, so I'm not sure if this has been fixed in the newer version.

Would love it if someone with the latest version could test it - delete something from your trash bin and let me know how long it takes. Thanks!
spooker replied on at Permalink Reply
spooker
With the 5.6.2.1 version I am using for development I am able to empty the trash without a problem. Can you firebug the request and see if anything is being returned by the server? The spinner will stay if the request was never really sent, if the server never replied or if the response was invalid.

If you can supply that information we might be able to help out more
CDMadmin replied on at Permalink Reply
Thanks Spooker. I installed Firebug and then deleted a page from the trash, but I'm not sure what to look for in Firebug that I can send to you. Should I be viewing the console or a different panel? Also I'm using C5 version 5.5.2.1
CDMadmin replied on at Permalink Reply
I've been deleting the pages and watching the response time - it varies from 2 seconds (very rare) to 5 minutes. Most common is 2 minutes. I'm starting to wonder if it's related to the amount of content on the page. Some pages have A LOT of stacks, images, etc. Then again there was one page that just had an embedded Google Calendar, and it took 5 minutes to delete.

The response is: {"message":"Page deleted."} so I know it's working correctly, it's just taking a very long time. 61 pages to go.

Let me know if there is anything in the "Headers" or "Cookies" tab that would be helpful to you.
CDMadmin replied on at Permalink Reply
I just got my first error when trying to delete a page, and the icon is still spinning.

TypeError: resp is null

But when I reloaded the Full Sitemap page, it looks like the page was deleted.
spooker replied on at Permalink Reply
spooker
Yes, it is the 'console' pane that you want to be watching ...

Depending on the load on the db server it could take that long ... with table locking and all the number of delete queries can spike the load on the machine ... especially with the complex relationships that C5 with the collection attributes ...

Can you see if PHP is throwing a "max execution time" error in the log? You might check the 'log' in the dashboard and also the webserver error log ...
CDMadmin replied on at Permalink Reply
I checked both logs, and there are no errors in the last few days that I've been deleting pages. It's a shared server, so that probably makes it run slower. The run time is the same today as it was yesterday - average of 2 minutes, and a range from 2 seconds to 5 minutes.

I also have the Multiple Domains add-on installed, so I'm not sure if that would affect things.

Akodde on this forum post said that when he upgraded, the deletes went faster.
http://www.concrete5.org/community/forums/usage/pages-and-page-type...

Maybe I need to bite the bullet and upgrade then. I'm just concerned with the all the intricacies of this site, that something will break. And if something does go wrong, I've never reverted to a database backup before, so I'm not confident about it.
spooker replied on at Permalink Reply
spooker
No, I wouldn't expect Multiple Domains to affect it ...

Since you're on a shared server that would complicate trying to figure things out sadly ... for the moment I'd suggest just trying to empty your trash often enough that you keep the response time short enough you'll see it work ... I'd be worried that if you're getting empty responses that the script might be leaving data orphans

Wish I had a more complete answer for you
CDMadmin replied on at Permalink Reply
No problem, and thanks for your suggestions! I will upgrade soon, so hopefully that improves it. First I have to check all my modifications to make sure I have them ready for the upgrade.