MokoConsulting/MokoWaaS
0
0
Fork 0
Code Issues 71 Pull Requests Releases 1 Wiki Activity

fix: preserve download keys (dlid) across Joomla extension updates #187

New Issue
Open
opened 2026-06-06 12:02:10 +00:00 by jmiller · 1 comment
jmiller commented 2026-06-06 12:02:10 +00:00
Owner
Copy Link
Copy Source

Summary

Joomla's extension installer can wipe the extra_query column in #__update_sites when rebuilding or reinstalling update sites. This column stores download keys (dlid) needed for commercial extension updates. This is a known Joomla bug that affects all extensions, not just MokoWaaS.

Root Cause

Joomla's installer recreates update site rows from manifest XML during install/upgrade. Since the dlid is user-entered data not present in the manifest, the extra_query value is lost. The "Rebuild" button in Update Sites also clears it silently.

References:

Solution

Added preserveDownloadKeys() to the core plugin. On every admin page load it:

  1. Reads all extra_query values from #__update_sites
  2. Backs up non-empty values to administrator/cache/mokowaas_dlkeys.json
  3. If any previously-backed-up keys are now empty, restores them automatically
  4. Cleans up backup entries for deleted update sites

Lightweight check -- single SELECT query per page load, writes only when changes detected.

Files Changed

  • Extension/MokoWaaS.php -- added preserveDownloadKeys() method, called from onAfterInitialise (admin only)
## Summary Joomla's extension installer can wipe the extra_query column in #__update_sites when rebuilding or reinstalling update sites. This column stores download keys (dlid) needed for commercial extension updates. This is a known Joomla bug that affects all extensions, not just MokoWaaS. ## Root Cause Joomla's installer recreates update site rows from manifest XML during install/upgrade. Since the dlid is user-entered data not present in the manifest, the extra_query value is lost. The "Rebuild" button in Update Sites also clears it silently. References: - https://github.com/joomla/joomla-cms/issues/32592 - https://github.com/joomla/joomla-cms/issues/37204 - https://www.akeeba.com/news/1746-working-around-joomla-s-broken-extensions-updater.html ## Solution Added preserveDownloadKeys() to the core plugin. On every admin page load it: 1. Reads all extra_query values from #__update_sites 2. Backs up non-empty values to administrator/cache/mokowaas_dlkeys.json 3. If any previously-backed-up keys are now empty, restores them automatically 4. Cleans up backup entries for deleted update sites Lightweight check -- single SELECT query per page load, writes only when changes detected. ## Files Changed - Extension/MokoWaaS.php -- added preserveDownloadKeys() method, called from onAfterInitialise (admin only)
jmiller commented 2026-06-06 12:02:12 +00:00
Author
Owner
Copy Link
Copy Source

Branch created: feature/187-fix-preserve-download-keys-dlid-across-j

git fetch origin
git checkout feature/187-fix-preserve-download-keys-dlid-across-j
Branch created: [`feature/187-fix-preserve-download-keys-dlid-across-j`](https://git.mokoconsulting.tech/MokoConsulting/MokoWaaS/src/branch/feature/187-fix-preserve-download-keys-dlid-across-j) ```bash git fetch origin git checkout feature/187-fix-preserve-download-keys-dlid-across-j ```
Sign in to join this conversation.
Labels
Clear labels
automation
Automated processes or scripts
 breaking-change
Breaking API or functionality change
 build
Build system changes
 ci-cd
CI/CD pipeline changes
 config
Configuration file changes
 css
CSS/styling changes
 dependencies
Dependency updates
 deploy-failure
Automated deploy failure tracking
 docker
Docker configuration changes
 documentation
Documentation changes
 dolibarr
Dolibarr module or extension
 generic
Generic project or library
 good first issue
Good for newcomers
 health-check
Repository health check results
 health: excellent
Health score 90-100
 health: fair
Health score 50-69
 health: good
Health score 70-89
 health: poor
Health score below 50
 help wanted
Extra attention needed
 html
HTML template changes
 javascript
JavaScript code changes
 joomla
Joomla extension or component
 major-release
Major version release (breaking changes)
 minor-release
Minor version release (XX.YY.00)
 mokostandards
MokoStandards compliance
 needs-review
Awaiting code review
 needs-testing
Requires manual or automated testing
 patch-release
Patch version release (XX.YY.ZZ)
 php
PHP code changes
 push-failure
File push failure requiring attention
 python
Python code changes
 regression
Regression from a previous working state
 release-candidate
Release candidate build
 security
Security-related changes
 size/l
Large change (101-300 lines)
 size/m
Medium change (31-100 lines)
 size/s
Small change (11-30 lines)
 size/xl
Extra large change (301-1000 lines)
 size/xs
Extra small change (1-10 lines)
 size/xxl
Extremely large change (1000+ lines)
 standards-drift
Repository drifted from MokoStandards
 standards-update
MokoStandards sync update
 standards-violation
Standards compliance failure
 status: on-hold
Temporarily on hold
 status: pending
Pending action or decision
 status: wontfix
This will not be worked on
 sync-failure
Bulk sync failure requiring attention
 sync-report
Bulk sync run report
 template-validation-failure
Template workflow validation failure
 test-failure
Automated test failure
 tests
Test suite changes
 type: bug
Something isn't working
 type: chore
Maintenance tasks
 type: enhancement
Enhancement to existing feature
 type: feature
New feature or request
 type: refactor
Code refactoring
 type: release
Release preparation or tracking
 type: test
Test suite additions or changes
 type: version
Version-related change
 typescript
TypeScript code changes
 version
Version bump or release
 version-branch
Version branch related
 version-drift
Version mismatch detected
 work-in-progress
Work in progress, not ready for merge
bug
Something is not working
 chore
Maintenance and housekeeping
 documentation
Documentation improvements
 enhancement
Improvement to existing functionality
 feature
New feature or request
 pending: dependency
Blocked by another issue or external dependency
 pending: deployment
Tested and approved, awaiting deployment to production
 pending: design
Needs UI/UX or architecture design before implementation
 pending: documentation
Feature works, needs documentation/wiki update
 pending: feedback
Awaiting feedback or decision from stakeholder
 pending: review
Implementation complete, awaiting code review
 pending: testing
Feature implemented but not yet tested
 priority: critical
Must fix immediately
 priority: high
Should fix soon
 priority: low
Nice to have
 priority: medium
Fix when convenient
 refactor
Code restructuring without behavior change
 roadmap
Planned feature or enhancement tracked on the roadmap
 scope: client
Client-specific work
 scope: dolibarr
Dolibarr modules and customizations
 scope: infrastructure
Server, CI, backups, monitoring
 scope: joomla
Joomla templates and extensions
 scope: waas
MokoWaaS platform
 security
Security vulnerability or hardening
 status: blocked
Waiting on external dependency
 status: duplicate
Duplicate of another issue
 status: in-progress
Being worked on
 status: needs-review
Ready for review
 status: wontfix
Will not be addressed
No labels
Type —
Status —
Priority —
Milestone
No items
No Milestone
Assignees
Clear assignees
jmiller (Jonathan Miller)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: MokoConsulting/MokoWaaS#187
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?