MokoConsulting/MokoSuiteCross
1
0
Fork 0
Code Issues 27 Pull Requests 1 Releases 5 Wiki Activity

bug: uninstall SQL missing analytics and category_rules table drops #225

New Issue
Open
opened 2026-06-29 14:19:18 +00:00 by jmiller · 1 comment
jmiller commented 2026-06-29 14:19:18 +00:00
Owner
Copy Link
Copy Source

Summary

The uninstall SQL script only drops 4 of 6 tables, leaving orphaned tables in the database after component removal.

Current State

File: source/packages/com_mokosuitecross/sql/uninstall.mysql.sql

DROP TABLE IF EXISTS `#__mokosuitecross_logs`;
DROP TABLE IF EXISTS `#__mokosuitecross_posts`;
DROP TABLE IF EXISTS `#__mokosuitecross_templates`;
DROP TABLE IF EXISTS `#__mokosuitecross_services`;

Missing

The install SQL (install.mysql.sql) creates two additional tables that are not dropped on uninstall:

-- These should be added BEFORE the existing drops (FK order):
DROP TABLE IF EXISTS `#__mokosuitecross_analytics`;
DROP TABLE IF EXISTS `#__mokosuitecross_category_rules`;

Impact

  • Severity: Medium
  • After uninstalling MokoSuiteCross, #__mokosuitecross_analytics and #__mokosuitecross_category_rules remain as orphaned tables
  • Reinstalling will work (CREATE TABLE IF NOT EXISTS) but stale data persists
## Summary The uninstall SQL script only drops 4 of 6 tables, leaving orphaned tables in the database after component removal. ## Current State **File:** `source/packages/com_mokosuitecross/sql/uninstall.mysql.sql` ```sql DROP TABLE IF EXISTS `#__mokosuitecross_logs`; DROP TABLE IF EXISTS `#__mokosuitecross_posts`; DROP TABLE IF EXISTS `#__mokosuitecross_templates`; DROP TABLE IF EXISTS `#__mokosuitecross_services`; ``` ## Missing The install SQL (`install.mysql.sql`) creates two additional tables that are not dropped on uninstall: ```sql -- These should be added BEFORE the existing drops (FK order): DROP TABLE IF EXISTS `#__mokosuitecross_analytics`; DROP TABLE IF EXISTS `#__mokosuitecross_category_rules`; ``` ## Impact - **Severity:** Medium - After uninstalling MokoSuiteCross, `#__mokosuitecross_analytics` and `#__mokosuitecross_category_rules` remain as orphaned tables - Reinstalling will work (CREATE TABLE IF NOT EXISTS) but stale data persists
jmiller commented 2026-06-29 14:19:21 +00:00
Author
Owner
Copy Link
Copy Source

Branch created: feature/225-bug-uninstall-sql-missing-analytics-and-

git fetch origin
git checkout feature/225-bug-uninstall-sql-missing-analytics-and-
Branch created: [`feature/225-bug-uninstall-sql-missing-analytics-and-`](https://git.mokoconsulting.tech/MokoConsulting/MokoSuiteCross/src/branch/feature/225-bug-uninstall-sql-missing-analytics-and-) ```bash git fetch origin git checkout feature/225-bug-uninstall-sql-missing-analytics-and- ```
Sign in to join this conversation.
Labels
No items
No labels
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/MokoSuiteCross#225
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?