How to Find the Installed Joomla Database Schema Version

Joomla tracks database schema progress separately from the human-facing Joomla or extension version. The schema record tells Joomla which numbered SQL update scripts have already been processed. For normal administration, first use Joomla's Database screen to determine whether the structure is current; inspect jossa_schemas directly only when you need the stored schema value for diagnosis.

Check database health in Joomla first

  1. Sign in to Administrator.
  2. Go to System → Maintenance → Database.
  3. Find the Joomla CMS entry and review its database-structure status.
  4. If Joomla reports the structure is current, record that result before doing direct database inspection.

This check is more meaningful than a version string alone because it compares the installed Joomla programs with the expected core table structure.

Understand what Joomla stores in jossa_schemas

Joomla uses the jossa_schemas table to store a version_id for an extension that uses numbered SQL update files. Joomla's programmer documentation distinguishes this from the extension manifest version stored in jossa_extensions.manifest_cache. The two values are separate and Joomla does not require them to be identical.

For Joomla core, the relevant extension record is the Joomla files package commonly identified as files_joomla. Its extension_id links to the corresponding jossa_schemas row.

Read the Joomla core schema version safely

Take a database backup before advanced troubleshooting, then use phpMyAdmin or another database client. Replace jossa_ with the site's real Joomla table prefix and run a read-only query:

SELECT e.extension_id,
       e.name,
       s.version_id
FROM jossa_extensions AS e
LEFT JOIN jossa_schemas AS s
       ON s.extension_id = e.extension_id
WHERE e.name = 'files_joomla';

The returned version_id is Joomla's stored core schema marker. The LEFT JOIN also makes a missing schema row visible as a null value instead of hiding the extension record.

Compare the marker with Joomla's core SQL update files

Joomla core database update scripts are under administrator/components/com_admin/sql/updates in database-specific locations. Joomla's Database tool can run outstanding core scripts through Update Structure. The schema marker relates to those update scripts and should not be assumed to equal the marketing Joomla version character-for-character.

For third-party extensions, the same principle applies: Joomla orders the extension's SQL update filenames numerically, processes those after the stored schema version during an update, and then stores the last processed filename as version_id.

Do not edit version_id just to silence a warning

Changing jossa_schemas.version_id does not create missing columns, indexes, or tables. A stale or missing row can be evidence of an interrupted update or nonstandard installation, so manually advancing it can falsely tell Joomla that SQL migrations ran.

Return to System → Maintenance → Database and use Update Structure for normal core repair. Joomla documentation describes direct reconstruction of a missing core schema record for specific abnormal cases, but that should be done only after verifying the actual core files and SQL scripts and taking a recoverable backup. After any repair, confirm the Database screen reports the structure current and test the site.


Need More Help with Joomla?

Still having trouble? Open a support ticket with QuantaCade Support and we'll be happy to help where we can.

Support priority is given to QuantaCade products, services, and customers. However, we're also happy to assist fellow Joomla users with general Joomla questions and troubleshooting when possible.

QuantaCade is an independent Joomla extension developer and is not official Joomla support. Some issues involving third-party extensions, hosting environments, server configurations, or other systems outside our development control may be beyond what we're able to resolve.

Open a Support Ticket