Wiki Page Edit History Posted by John Morris 15 Nov 2022 03:06 GMT-0000 posts: 758 Good day folks, I was curious if there is a way to limit the time frame of edits the history feature is keeping track of. The "History" is keeping pages over 3 years old, can I limit the history to 180 days for example? Thanks John
Posted by Bernard Sfez / Tiki Specialist 15 Nov 2022 05:23 GMT-0000 posts: 8654 John Morris wrote: Good day folks, I was curious if there is a way to limit the time frame of edits the history feature is keeping track of. The "History" is keeping pages over 3 years old, can I limit the history to 180 days for example? Thanks John Hi John, I support John's suggestion ! 👍🏼 I have seen some Tiki where the wiki pages history table was quite big. Emptying the table mean loosing it all. Where "Flagged Revision" has been turned on I kind of remember it is even bigger and can't be emptied. Bsfez | Bernard Sfez | Tiki Express Tutorials | me at bsfez.com | https://www.bsfez.com
Posted by John Morris 15 Nov 2022 08:36 GMT-0000 posts: 758 Thanks Bernard for confirming, so there is no way to do it at this point. Then should I make a feature suggestion? I guess the terminology I was looking for in my original topic was "Prune". It seems there should be away to "Prune" history older than a designated time period. The UI would be "Prune history older than". Thanks Bernard
Posted by Rick Sapir / Tiki for Smarties 15 Nov 2022 12:13 GMT-0000 posts: 3665 John Morris wrote: Good day folks, I was curious if there is a way to limit the time frame of edits the history feature is keeping track of. The "History" is keeping pages over 3 years old, can I limit the history to 180 days for example? Thanks John isn't this what the history options are for? HTH, - Rick | My Tiki Blog | My Tiki UserPage Why be a dummy? Get smarty! TikiForSmarties.com Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials.
Posted by John Morris 15 Nov 2022 12:18 GMT-0000 posts: 758 Rick Sapir / Tiki for Smarties wrote: isn't this what the history options are for? HTH, - Rick | My Tiki Blog | My Tiki UserPage Why be a dummy? Get smarty! TikiForSmarties.com Tiki for Smarties, your source for the best (and only) Tiki books, guides, and tutorials. Why yes! Thanks Rick! I could not find it, even with a search in admin panel for "history". Thanks again!
Posted by John Morris 15 Nov 2022 12:22 GMT-0000 posts: 758 I found it, did a search for "version" and found the settings, thanks again Rick, and thanks Bernard.
Posted by Jonny Bradley 15 Nov 2022 12:40 GMT-0000 posts: 126892 I added wiki and history as keywords for these prefs in 612cfa9d in trunk and 25.x so this should be better in the future - thanks all!
Posted by John Morris 15 Nov 2022 12:56 GMT-0000 posts: 758 Jonny Bradley wrote: I added wiki and history as keywords for these prefs in 612cfa9d in trunk and 25.x so this should be better in the future - thanks all! Thank you Sir Bradley!
Posted by Bernard Sfez / Tiki Specialist 15 Nov 2022 13:30 GMT-0000 posts: 8654 Hi, I though this was effective for "future" created pages as when I tested previously it never reduce existing history. 🤷🏻♂️ I just re-tested with a fat Tiki24 where I have a DB with 506mb for the table "tiki_history". At tiki-admin.php?page=wiki I have Maximum number of versions: 0 (unlimited) Keep versions for: 7 days (keep version younger than 7 days) At tiki-listpages.php I can see pages with a lot of versions (200+) If I change the Maximum number of versions to 10 (versions) and apply it take a refresh to display the same page and nothings happen, I still have 506mb and pages with 200+ number of versions. Can someone confirm it should prune ?
Posted by Jonny Bradley 15 Nov 2022 14:02 GMT-0000 posts: 126892 Hi @Bernard Sfez / Tiki Specialist Bernard Sfez / Tiki Specialist wrote: Can someone confirm it should prune ? No, i don't think changing a pref should delete data 😬, but there should/could be a button on the history list page to enable the pruning. (warning, feature creep) Maybe even export and prune, would be nice! (and even more) The action log could do with this too, that table gets huge over time...
Posted by Marc Laporte 15 Nov 2022 15:38 GMT-0000 posts: 1644 Bernard Sfez / Tiki Specialist wrote: Can someone confirm it should prune ? What happens if you edit a page after changing the setting?
Posted by John Morris 16 Nov 2022 03:15 GMT-0000 posts: 758 There is a "Remove" action in the History of each page, but really that is just selecting and deleting the revisions. I am not a dev, but in using software from other applications, there is typically a "Rebuild" action to take, when and if you decide to activate the "Prune" feature. So if you have 200 revisions for a wiki page and you decide you want to turn on the prune feature, you can set it to store 15 revisions, or prune content older than (days), once you configure it to where you want it, you click on a button "Rebuild" and it goes back to all the revisions and prunes per the settings. This could take seconds or it could take minutes, or even hours depending on the amount of wiki pages in the database.
Posted by Bernard Sfez / Tiki Specialist 16 Nov 2022 06:40 GMT-0000 posts: 8654 Marc, I will answer in a day or two as I set the pref "Keep version for" (not to delete version younger than). About this setting in general; First and essentials, we don't want to introduce a dangerous deletion action. Second, for real life usage, the actual look to me quite ineffective as it is. If you have a big Tiki you will not open each page, go to history and delete versions or edit/save page by page to validate the actual settings (if this is how it works). If you are fresh (and even less fresher) Tiki admin you will certainly not think or be aware that keeping history or using revisions stagging may create such issue. (you have usually enough things to understand in Tiki before getting to that) I see this problem as similar as was the file gallery storage choice in the past. To manage the problem we added MANY warnings and informations (from installation to admin screens) about not using the Database to store too many files + we added a way to reverse a past selected setting (move to directory / move to database). It is hard to foreseen results of some admin settings and choice like this one, like keep files archives (default) and like action logs. Each issue should have a specific answer based on the issue. (like we have tools for forum, logs, statistics, etc) For Wiki Page history (and I include what is needed for revision), I think Jonny gave us a good recipes.👏 Prune option (days or numbers of version) Additional option to export the pruned data. (re-importing the pruned data allowing revert will be awesome but may be one step too far) It require investment (development, testing, documentation, etc) but with time more and more active Tiki admin will face the issue.
