schemaoutofdate

Database Errors

Why is it a problem?

Joomla reports that there are errors in the database structure of the extension. In most cases, these problems can cause functionality issues with the extension, or even prevent the extension from running at all.

Suggested fix

Ask Joomla to fix the extension. Go to Joomla's System, Maintenance, Database page, select the extension, and click on Update Structure. Alternatively, click the button in Onthos' interface which calls Joomla's Update Structure for the extension directly.

If the Update Structure fails to fix all the problems you can go to Joomla's System, Maintenance, Database page to see what the problem is. Alternatively, click the link in Onthos' interface to be taken directly to that page, with only the extension in question being shown.

Notes

Not all database errors reported by Joomla are real, or important.

Joomla tries to parse the update SQL files of the extension to deduce what the database table structure should look like. Because of the different ways database table structure variations can be expressed in SQL, Joomla might not be able to make a correct deduction. Moreover, the database itself may decline providing the information Joomla needs to deduce whether the current database structure is correct. If trying to fix an issue never seems to work, that's probably the case.

Furthermore, the errors Joomla reports may vary in importance from mere notices (e.g. the collation of a column is off), to something major (an entire table is missing). Keep that in mind when you see this issue; it might not be as severe as it looks.

Finally, keep in mind that Joomla can neither test whether the database tables are broken / crashed, nor fix them if they are. If you need this kind of functionality we strongly recommend using our free of charge Admin Tools CORE extension.