Support

Admin Tools

#42851 Unknown column 'admintools_filescache_id

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
6.03
PHP version
8.4.19
Admin Tools version
7.8.7

Latest post by nicholas on Tuesday, 31 March 2026 00:39 CDT

benw987

Installation error.

Advice please

nicholas
Akeeba Staff
Manager

Thank you for reaching out!

The error message you are seeing means that Joomla's database still has records indicating Admin Tools is installed, but the actual extension files and tables are missing from your site. This happens when the extension's files and tables are deleted directly from the server (for example via FTP or a file manager, and the host-provided phpMyAdmin / Adminer respectively) rather than the extension being properly uninstalled through Joomla's Extension Manager. Joomla is then confused: it tries to run database update queries against tables that no longer exist.

To resolve this, you will need to manually remove the leftover database records before (re-)installing Admin Tools. Please follow these steps:

  1. Open your host-provided database management tool (phpMyAdmin, Adminer, or similar).
  2. In the #__extensions table (where # is your database table prefix, e.g. jos_extensions), find the row where the element column is com_admintools. Note down the number you see next to the extension_id.
  3. Delete the #__extensions table row you found.
  4. In the #__schemas table, find and delete the row where the extension_id matches the ID of the row you found in step 2.
  5. Once both records are removed, go to Joomla's Extension Manager and install Admin Tools Professional normally.

If you are not comfortable editing the database directly, please ask your hosting provider's support team for assistance — they can do this safely for you.

Once reinstalled correctly, the error should be completely gone. Please let me know if you run into any further issues and I will be happy to help!

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!