Hi, I couldn't even backup my sql database anymore because there are large pages (with attachments) in the recycle bin -- at least thats what I gathered from the mysqldump error message: mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `xwikirecyclebin` at row: 45
I will have to adjust the max package size (again), but I want to move to file-system attachments. So, I thought I'd try and empty the recycle bin... I found the "Deleted Documents" list in the Document Index, but I have over 5 pages of them. Do I seriously have to click delete and Yes on every single one of these individually? I found this extension: http://extensions.xwiki.org/xwiki/bin/view/Extension/Empty+Trash+Bin I installed the Groovy Console and copy-pasted the code into the box, and clicked Execute... and nothing happened. I looked at the code, and executed the sql command directly in mysql: select distinct ddoc.fullName from XWikiDeletedDocument as ddoc where not exists (from XWikiDocument as doc where doc.fullName=ddoc.fullName); But it doesn't work - invalid SQL. I adjusted it to: select distinct ddoc.fullName from XWikiDeletedDocument as ddoc where not exists (select doc.fullName from XWikiDocument as doc where doc.fullName=ddoc.fullName); but it says XWikiDeletedDocument doesn't exist anymore. So, how am I supposed to delete things from the recycle bin? The only thing useful I can find is this: http://markmail.org/message/6yxwwczjk7pwowbd Which seems to suggest I do: delete from xwikirecyclebin; But, will that stuff something up? The extension is out of date, so I can only assume that this advice might be too. cheers Paul _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
