Support

Admin Tools

#37234 Error SQL Table 'xxx.hxvn5_admintools_filescache' doesn't exist

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
4.1.4
PHP version
7.4.28
Admin Tools version
7.1.7

Latest post by tampe125 on Wednesday, 15 June 2022 03:31 CDT

xhalox

I got this error when I tried to install Admin Tools 7.1.7 Pro on Joomla 4.1.4

"JInstaller: :Install: Error SQL Table 'xxx.hxvn5_admintools_filescache' doesn't exist Extension installation aborted. Package Install: There was an error installing an extension: com_admintools-pro.zip"   Can you tell me how to fix this problem? Thank you!

System Task
system
The ticket information has been edited by Victor Nguyen (xhalox).

tampe125
Akeeba Staff

Hello,

this happens because Joomla can not create that table, that's a bit strange, I'd wish to connect to your site and double check what's going on.

I have made this ticket private so that only you and me can see the information posted here.

Please provide me with the following information:

  1. The URL to your site's administrator login page
  2. Super User username and password
  3. FTP connection information


Please allow up to one business day (GMT+2 timezone) for me to log in to your site and debug this issue. When I'm done I will post back. Once the issue is fixed, you can revoke my access e.g. by changing the Super Administrator and FTP passwords.

IMPORTANT INFORMATION
In order for me to help you fast and accurately, please provide the information by copying the form below, paste it into your reply and fill in the information:

----- Access Information Form -- START -----
Super Administrator access

  • URL to site's administrator page (e.g. http://www.example.com/administrator?foobar):
  • Super User username:
  • Super User password:


FTP connection information

  • FTP methods supported (e.g. FTP, FTPS, SFTP):
  • FTP Hostname:
  • FTP Username:
  • FTP Password:
  • FTP Port (if other than 21 for FTP and 22 for SFTP, ask your host):


----- Access Information Form -- END -----

Please make sure that you have tested the Super Administrator connection using a different browser or machine than the one you are using daily. Double check that logging in is possible and that the user has Super User privileges, i.e. it's not a regular Administrator. Make sure that your site does not block whole countries or IP ranges which would make it impossible for me to log in / connect by FTP. Finally, please do make sure that the FTP connection works and that logging in to it I have access to your site's files.

Kindly note that your site connection information and your site content is handled in strict confidence. Not only we are a reputable development company, we are also bound by law (EU GDPR) to do so. After you file your reply, the connection information to your site will be stored in an encrypted, hidden storage area on our site and will be automatically deleted when this ticket is closed. Finally keep in mind that the people providing support to you are the same developers who wrote the software you're using on your site.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

xhalox

Thanks for your response. Here is my connection information:

----- Access Information Form -- START -----
Super Administrator access

  • URL to site's administrator page (e.g. http://www.example.com/administrator?foobar): https://www.wowplaynow.com/administrator
  • Super User username: user
  • Super User password: adminadminadmin


FTP connection information

  • FTP methods supported (e.g. FTP, FTPS, SFTP): FTP
  • FTP Hostnameftp.wowplaynow.com
  • FTP Username[email protected]
  • FTP Password: adminadminadmin
  • FTP Port (if other than 21 for FTP and 22 for SFTP, ask your host): 21


----- Access Information Form -- END -----

 

Let me know if you have any login trouble. Thanks!

tampe125
Akeeba Staff

Hello,

thank you very much for access details. I was able to connect and verify your situation and indeed it was a bit tricky.

You had a partial install, so when you tried to actually install Admin Tools you get an error, but trying to uninstall it lead to an error too since files were missing. I had to manually add some files so Joomla was happy enough to uninstall it and then install it again.

Now it should be working as expected, can you please double check?

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

xhalox

Admin Tools component is working properly right now. You did an excellent job. Thank you so much!

tampe125
Akeeba Staff

You're welcome!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

xhalox

Sorry this is not related topic issue here. My issue is about secret URL for Administrator. I already set Administrator secret URL parameter (example: test), but when I try to access into Administrator URL without "test", I can be still able to access Administrator login page without redirect to homepage. So how to make secret URL parameter works?

tampe125
Akeeba Staff

Did you put your IP in the White list section? If so, the redirection won't apply to you.

Moreover, in latest versions of Admin Tools we're doing a nice trick: we will create a cookie for you, so even if you didn't put the secret param (but you logged in  at least once with it), your access will be granted: https://www.akeeba.com/documentation/admin-tools-joomla/web-application-firewall.html#waf-configure-basic-protection section "Browser cookie override for the administrator secret URL parameter"

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

xhalox

Awesome! Thanks for clarifying.

tampe125
Akeeba Staff

You're welcome!

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

xhalox

Hello, I just installed JL Sitemap component on my site, but it seems like Admin Tools blocks "sitemap.xml", I can't access this page https://www.wowplaynow.com/sitemap.xml 

So how to make JL sitemap component accessible without blocking by Admin Tools? or any Sitemap extension do you recommend to use?

tampe125
Akeeba Staff

Can you please open a new ticket for your issue?

Otherwise it gets very hard to follow them all.

Davide Tampellini

Developer and Support Staff

🇮🇹Italian: native 🇬🇧English: good • 🕐 My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Easter vacation: We will be closed from 17 April 2025 16:00 UTC to 21 April 2025 06:00 UTC due to observing the Christian Easter holiday. Support will be closed during that time for both new tickets, and replies to existing tickets.

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!