Draft Protocol: Pruning Outdated Wishlist Tracker Items (Tracker5)
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:
Copy to clipboard
mysql -u root -proot -e "USE tiki_dev; SELECT COUNT(*) FROM tiki_tracker_item_fields WHERE fieldId=47 AND value < 21;"
Questions
- What if the issue has been reported in Tiki 15, but it is not yet resolved?