Unable to delete items from Clipboard

Permalink
On my 5.7 sites I hit a problem with a clipboard that will not allow me to delete any of the contents. I suspect the cause is copying a pdf display block there which might be trying to display and freezing up the clipboard operation.
Can someone tell me where/how i can flush all of the clipboard contents in one hit so as to be able to use it again?

 
Gondwana replied on at Permalink Reply
Gondwana
If you're courageous, you could try deleting the contents of the Piles and PileContents database tables. Back up first, of course.
mcekl replied on at Permalink Reply
Thanks, IF there was an easy backup facility in ver 5.7 (like 5.6) then i would be tempted.
If that's where the clipboard is stored then might have a go once i have done an SQL backup
JohntheFish replied on at Permalink Reply
JohntheFish
My usual trick when a block breaks the clipboard is to (temporarily) hack the view.php of the offending block (or block template) to be "XXX", clear the cache, then delete the "XXX" from the clipboard and hack the view.php back to the original.
mcekl replied on at Permalink Reply
i dont know which block has locked it up so easier to clear the lot out. Wish there was a simple 'purge clipboard' function for this as it must happen often.
JohntheFish replied on at Permalink Reply
JohntheFish
If you look at the browser dev console network tab, you will likely see a 500 error for the ajax load of the clipboard. If you have debug to browser enabled, that should contain a whoops trace telling you what happened and the offending file.
JohntheFish replied on at Permalink Reply
JohntheFish
If not, start with your suspect pdf block, then work through them. Its unlikely to be a simple block, so focus on the more complex ones.
mcekl replied on at Permalink Reply
I dont know where the view.php files are and worried about hunting down the correct ones. Would the table clear for Piles & PilesContent work to clear all the clipboard? I feel a lot happier working with SQL tables.
JohntheFish replied on at Permalink Reply
JohntheFish
It all depends on what/if anything else in the core uses those tables... I suspect you would never be sure unless you get a response from Andrew or Korvin or one of the other core experts.
mcekl replied on at Permalink Reply
Well, i took the plunge, after backing up AND exporting the whole SQL database, of deleting the contents of the PILES and PILECONTENTS tables and it did clear the clipboard contents, whch now works as it should. So far no other adverse impact on the Foundation template.
It would seem to be a useful addition to the admin options to be able to run a simple purge table script to clear out the clipboard. It would seem that it is NOT a good idea to save to clipboard the PDF viewer add-on block though... or maybe it should have its view in clipboard option muted.
Thanks to all for their kind assistance.