How to Disable a Broken Joomla Extension Directly in the Database

Use database editing only for recovery

Direct edits bypass Joomla's normal extension-management workflow. Use them only when normal Administrator controls are unavailable. If you can still sign in, use System → Manage → Extensions or the appropriate Plugins/Modules screen instead.

Before editing, export the database or at minimum the affected jossa_extensions row. Replace jossa_ in examples with your site's real table prefix.

Identify the exact extension record

Search rather than guessing. For example:

SELECT extension_id, name, type, element, folder, enabled
FROM yourprefix_extensions
WHERE name LIKE '%Example%' OR element LIKE '%example%';

Confirm the extension type, element, and—for plugins—the folder. Do not disable a similarly named core extension by mistake.

Disable only the confirmed record

For extensions represented by an enabled flag, make the smallest possible change and guard it with the exact identity you verified:

UPDATE yourprefix_extensions
SET enabled = 0
WHERE extension_id = 123
  AND type = 'plugin'
  AND element = 'example'
  AND folder = 'system';

Verify that exactly one row changed. If zero or multiple rows are affected, stop and re-check the identity.

Know what this does not do

Changing enabled is not the same as uninstalling. It does not remove files, reverse SQL changes, run an uninstall script, or clean related data. Components, packages, libraries, templates, and module instances may have additional state, so do not assume every extension can be recovered by changing one flag.

Test and repair normally

1. Reload the request that failed and try Administrator again.
2. Review Joomla and PHP logs to confirm the original error stopped.
3. Keep the extension disabled while you obtain a compatible release or vendor recovery procedure.
4. Use Joomla's normal extension management for the repair, update, re-enable, or uninstall operation.
5. Test frontend, Administrator, and the affected feature before closing recovery.

Do not delete the jossa_extensions row as an uninstall shortcut.