Joomla! Documentation™

This screen is accessed from the back-end Joomla! administrator panel. It is used to check and fix any database issues with your website.

How to Access

• Select Extensions → Extension Manager from the drop-down menu of the Joomla! Administrator Panel. Then select the Database menu item in the Extension manager screen that appears.

Description

This screen checks that your database table structure is up to date with your Joomla programs and lets you try to fix any problems that are found.

In a normal Joomla version update, changes to the database table structure (also called "schema") are done automatically to keep the database version synchronized with the Joomla version. If an update is done manually, or if some part of an automatic update fails, the database schema might not be updated to match the version of the Joomla program files. In this case you will see a list of database problems on the screen. You can normally fix any problems by clicking on the Fix button.

Screenshot

Screen display when database is up to date.

Screen display when the database table structure is not up to date.

Toolbar

At the top right you will see the toolbar:

The functions are:

This Page is a Candidate for Deletion

This notice should remain for a minimum of 1 week after it was placed on the page. If discussion is still ongoing, it should remain until a consensus is reached, after which the page will either be deleted or this notice removed. If you disagree with its deletion, please discuss your reasons on its associated talk page, as applicable.

Remember to check if anything links here and the page history before deleting.

Last edit by MATsxm (talk · contrib) · Last edited on Wed, 13 Apr 2016 09:13:36 +0000

• Fix. This program attempts to fix any database table structure problems found in the Database check. It runs any database schema change scripts (from the folder administrator/components/com_admin/sql/updates) that were not run during the version update. It then re-checks whether or not the database is up to date. If it is successful, the message "Database table structure is up to date" will show.

• Options. Opens the Options window where settings such as default parameters can be edited.

• Help. Opens this help screen.

Links to Other Screens

At the top left, you will see the following five links:

• Install. Links to the Install Screen.
• Update. Links to the Update Screen.
• Manage. Links to the Manage Screen.
• Discover. Links to the Discover Screen.
• Database. Links to the Database Screen.
• Warnings. Links to the Warnings Screen.
• Install Langauges. Links to the Languages Screen.

Quick Tips

• If you experience problems during an update, use this Database check to see if your database got updated correctly.
• It is strongly recommended that you use the Joomla! Update component to update your site. This way the database changes will be done automatically.

Related Information

• You can check for available updates in the Joomla! Update component or in the Control Panel.