Skip to main content
Cybersalt Consulting Ltd
Joomla extension

Quirky DB Fixes

Repair the database leftovers of a Joomla 3 to 4/5 migration

FreeJoomla 4Joomla 5Joomla 6 v1.2.1
Free

Free download. GPL, the same license as Joomla.

Quirky DB Fixes is a free Joomla 4.2, 5 and 6 component that finds and repairs the database problems a Joomla 3 migration and a database restart leave behind: articles missing from the Article Manager, missing Smart Search menu items, and the "Table finder_tokens doesn't exist" error. Each fix checks for its problem first, shows the SQL it will run, and lets you download a backup of the affected tables before you run it.

Why this exists

A Joomla 3 site migrated to Joomla 4 or 5 can end up without the workflow records Joomla 4 added. The articles are still in the database, but the Article Manager doesn't list them, and nothing in Joomla says why. Smart Search has two tables that live in memory, so a MySQL restart wipes them and saving an article starts failing. Each of these takes a few lines of SQL to fix, as long as you know which lines. This component packages the fixes Cybersalt was running by hand on migrated client sites, with a check in front of each one so you only run what your site needs.

What it fixes

FixWhat you see beforeWhat the fix does
Restore missing workflow system No articles in the Article Manager after a migration. Creates the four workflow tables if they're missing and adds Joomla's default workflow, stage and seven transitions.
Fix missing workflow associations Some articles are missing from the Article Manager. Links every article without a workflow record to the default workflow.
Fix missing Smart Search menu items Smart Search's admin submenu is incomplete. Puts back the missing Smart Search menu items.
Fix missing Smart Search tokens table "Table finder_tokens doesn't exist" when saving. Recreates the finder_tokens MEMORY table, with the collation your other Smart Search tables use.
Fix missing Smart Search tokens aggregate table The same error for finder_tokens_aggregate. Recreates the finder_tokens_aggregate MEMORY table.

The Quirky DB Fixes screen listing the five fixes, each with a green check when no problem is found

Installing it

  1. Download the ZIP with the button above.
  2. In Joomla admin, go to System โ†’ Install โ†’ Extensions and upload the ZIP. The same ZIP installs on Joomla 4.2 and later, Joomla 5 and Joomla 6.
  3. Open Components โ†’ CS Quirky DB Fixes. The screens come in 15 languages.

Using it

  1. Back up the whole database first. The fixes are written to be safe, but they change the database directly.
  2. Open a fix. Its diagnostic says whether your site has the problem, and the SQL it would run is shown in full.
  3. Click Download Backup to save the tables that fix touches, tick the confirmation box, and click Run Fix. Fixes for problems your site doesn't have stay switched off.

One fix opened: the problem, the diagnostic, the SQL it runs, the Download Backup button and the Run Fix button

After Run Fix, the result shows at the top and the diagnostic runs again:

After Run Fix: a green Fix completed successfully message at the top, and all five fixes listed with green checks

Installing it on a Joomla 4 site that is stuck mid-migration is a good use: repair the workflow and Smart Search tables there, then upgrade to Joomla 5 with a clean database.

Permissions and security

Only Super Users can open the component, run a fix or download a backup. Other administrators don't see it in the Components menu.

Open source

Quirky DB Fixes is open source under GPL-2.0-or-later. Download it here on cybersalt.com. The source code and issue tracker are on GitHub at github.com/cybersalt/cs-quirky-db-fixes. Thanks to Phil Taylor for the pull request that made it Super Users only.


Interesting blog? Like it on Facebook, Post it or share this article on other bookmarking websites.

Written by:
Tim Davis is the founder and owner of Cybersalt.

Recent changes

Version 1.2.1 19 Nov 2026

Changed

  • Updates and the changelog now come from cybersalt.com, so new versions show up under System > Update > Extensions. Sites on 1.2.0 or older install this version by hand once.
  • New logo.

Add comment

Submit

Joomla websites built well and looked after properly, from Victoria, BC, Canada, since 1998.

About Cybersalt