History: Draft Protocol: Pruning Outdated Wishlist Tracker Items (Tracker5)
Source of version: 3 (current)
Copy to clipboard
__Background:__
To improve performance and reduce server load, we propose deleting tracker items from the Wishlist (tracker5) that were reported for Tiki versions 21.x and below. This follows the suggestion to prune old data, with careful consideration for data integrity and SEO.
__Criteria for Deletion:__
* Tracker: Wishlist (tracker5)
* Field: Version (permName: ''version'')
* Condition: Items where version < 21
* Count: 2,497 items identified (as of 2025-11-20)
__Note:__ count was found with the following query:
{CODE()}mysql -u root -proot -e "USE tiki_dev; SELECT COUNT(*) FROM tiki_tracker_item_fields WHERE fieldId=47 AND value < 21;"{CODE}
!! Questions
* What if the issue has been reported in Tiki 15, but it is not yet resolved?