bug: uninstall SQL misses analytics and category_rules tables #245

New Issue

2026-06-29T14:27:08Z

jmiller commented

2026-06-29 14:27:08 +00:00

Description

uninstall.mysql.sql only drops 4 of 6 tables:

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:

#__mokosuitecross_analytics
#__mokosuitecross_category_rules

Both tables are created by install.mysql.sql and will be orphaned on uninstall.

Fix

Add the missing DROP statements before the existing ones (to respect FK ordering):

DROP TABLE IF EXISTS `#__mokosuitecross_analytics`;
DROP TABLE IF EXISTS `#__mokosuitecross_category_rules`;

Impact

Severity: Low -- orphaned tables waste space but cause no runtime issues
Affected file: source/packages/com_mokosuitecross/sql/uninstall.mysql.sql

## Description `uninstall.mysql.sql` only drops 4 of 6 tables: ```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: - `#__mokosuitecross_analytics` - `#__mokosuitecross_category_rules` Both tables are created by `install.mysql.sql` and will be orphaned on uninstall. ## Fix Add the missing DROP statements before the existing ones (to respect FK ordering): ```sql DROP TABLE IF EXISTS `#__mokosuitecross_analytics`; DROP TABLE IF EXISTS `#__mokosuitecross_category_rules`; ``` ## Impact - **Severity**: Low -- orphaned tables waste space but cause no runtime issues - **Affected file**: `source/packages/com_mokosuitecross/sql/uninstall.mysql.sql`

jmiller commented

2026-06-29 14:27:10 +00:00

Branch created: feature/245-bug-uninstall-sql-misses-analytics-and-c

git fetch origin
git checkout feature/245-bug-uninstall-sql-misses-analytics-and-c

Branch created: [`feature/245-bug-uninstall-sql-misses-analytics-and-c`](https://git.mokoconsulting.tech/MokoConsulting/MokoSuiteCross/src/branch/feature/245-bug-uninstall-sql-misses-analytics-and-c) ```bash git fetch origin git checkout feature/245-bug-uninstall-sql-misses-analytics-and-c ```

Sign in to join this conversation.

Priority Medium

Type Feature

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: MokoConsulting/MokoSuiteCross#245