Help4.x

Information : Base de données

From Joomla! Documentation

This page is a translated version of the page Help4.x:Information: Database and the translation is 9% complete.
Other languages:
Deutsch • ‎English • ‎Nederlands • ‎français • ‎italiano

Description

Cet écran vérifie que la structure des tables de votre base de données est à jour par rapport à vos programmes Joomla et vous permet d'essayer de corriger les problèmes qui sont trouvés. Lors d'une mise à jour normale de la version de Joomla, les changements apportés à la structure des tables de la base de données (également appelée "schéma") sont effectués automatiquement pour que la version de la base de données reste synchronisée avec la version de Joomla. 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.

How to Access

  • Select System  Information Panel  Database from the Administrator menu.

Screenshot

[[Image:Help-4x-extension_manager-database-screen-

en

.png|800px]]

Column Headers

Chunk4x:Help screen column header Chunk4x:Help screen column header

  • Location. Specifies if this is a site or administrator extension.
  • Type. The extension type - module, plug-in, template, language.
  • Problems. Any problems will be mentioned here. A hover Tooltip provides more information.
  • Database Version. The version number of the Database.
  • Manifest Version. The version number of Joomla or Extension.
  • Folder. If the extension is a plug-in, the subdirectory of your Joomla! installation's /plugins directory where the extension is located.
  • ID. The ID number. This is a unique identification number for this item assigned automatically by Joomla!. It is used to identify the item internally, for example in internal links. You cannot change this number.

List Filters

{{safesubst:Chunk4x:Help_screen_filters_Search_Bar_Filter/

en

}}

Filter Options

You can use one of the available filters or any combination of them to limit the number of extensions displayed to just the extensions which match your filter parameters.

  • -Select Location-. Select Site, Administrator or API from the drop-down list of available locations.
  • -Select Type-. Select the extension type from the drop-down list box of available types.
  • -Select Folder-. Select a plug-in folder from the drop-down list box of available folders. There is a separate folder for each type of plug-in defined in your Joomla installation.

{{:Chunk4x:Help_screen_filters_Pagination/

en

}}

Toolbar

{{safesubst:Chunk4x:Help_screen_toolbar_top_descriptor/

en

}}

  • Update Structure. 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.

{{safesubst:Chunk4x:Help_screen_toolbar_icon_Options/

en

}} {{safesubst:Chunk4x:Help_screen_toolbar_icon_Help/

en

}}

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

Links to Other Screens