MokoConsulting/MokoSuiteBackup
1
0
Fork 0
Code Issues 28 Pull Requests Releases 2 Wiki Activity

fix: uninstall.mysql.sql missing DROP for snapshots table #181

New Issue
Open
opened 2026-06-29 14:39:43 +00:00 by jmiller · 2 comments
jmiller commented 2026-06-29 14:39:43 +00:00
Owner
Copy Link
Copy Source

Summary

sql/uninstall.mysql.sql drops #__mokosuitebackup_profiles, #__mokosuitebackup_records, and #__mokosuitebackup_remotes but is missing DROP TABLE IF EXISTS #__mokosuitebackup_snapshots.

Uninstalling the component leaves an orphaned table in the database.

Location

source/packages/com_mokosuitebackup/sql/uninstall.mysql.sql

Fix

Add: DROP TABLE IF EXISTS #__mokosuitebackup_snapshots;

## Summary `sql/uninstall.mysql.sql` drops `#__mokosuitebackup_profiles`, `#__mokosuitebackup_records`, and `#__mokosuitebackup_remotes` but is missing `DROP TABLE IF EXISTS #__mokosuitebackup_snapshots`. Uninstalling the component leaves an orphaned table in the database. ## Location `source/packages/com_mokosuitebackup/sql/uninstall.mysql.sql` ## Fix Add: `DROP TABLE IF EXISTS #__mokosuitebackup_snapshots;`
jmiller added the component: engine label 2026-06-29 14:39:43 +00:00
jmiller commented 2026-06-29 14:39:46 +00:00
Author
Owner
Copy Link
Copy Source

Branch created: feature/181-fix-uninstall-mysql-sql-missing-drop-for

git fetch origin
git checkout feature/181-fix-uninstall-mysql-sql-missing-drop-for
Branch created: [`feature/181-fix-uninstall-mysql-sql-missing-drop-for`](https://git.mokoconsulting.tech/MokoConsulting/MokoSuiteBackup/src/branch/feature/181-fix-uninstall-mysql-sql-missing-drop-for) ```bash git fetch origin git checkout feature/181-fix-uninstall-mysql-sql-missing-drop-for ```
jmiller commented 2026-07-05 19:43:02 +00:00
Author
Owner
Copy Link
Copy Source

Confirmed in 02.56.05 — keep open.

sql/uninstall.mysql.sql drops only three tables (remotes, records, profiles); there is no DROP TABLE IF EXISTS #__mokosuitebackup_snapshots;. The snapshots table is left orphaned on uninstall. Add the missing DROP.

Confirmed in 02.56.05 — keep open. `sql/uninstall.mysql.sql` drops only three tables (remotes, records, profiles); there is no `DROP TABLE IF EXISTS #__mokosuitebackup_snapshots;`. The snapshots table is left orphaned on uninstall. Add the missing DROP.
Sign in to join this conversation.
Labels
Clear labels
component: admin
Admin UI and views
 component: api
REST API
 component: engine
Backup/restore engine
 component: remote
Remote storage (FTP/GDrive)
 component: scheduler
Scheduled tasks
bug
Something is not working
 duplicate
This issue or pull request already exists
 enhancement
New feature
 help wanted
Need some help
 invalid
Something is wrong
 question
More information is needed
 wontfix
This won't be fixed
No labels component: engine
Priority Medium
Type Feature
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/MokoSuiteBackup#181
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?