Support

Admin Tools

#12066 How do I clean out old scanner details?

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
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Wednesday, 25 April 2012 09:02 CDT

elau24
Mandatory information about my setup:

Have I read the related troubleshooter articles above before posting (which pages?)? No
Have I searched the tickets before posting? No
Have I read the documentation before posting (which pages?)? No
Joomla! version: (unknown)
PHP version: (unknown)
MySQL version: (unknown)
Host: (optional, but it helps us help you)
Admin Tools version: 2.2.5 Pro

Description of my issue:

I've recently moved a site to production. While in development, I had tried out the PHP file scanner. I want to remove the old scan info from production and start from fresh. I deleted the scan reports and removed all records from _admintools_scanalerts, but looks like I should also remove all records from admintools_filescache. Could you confirm if that's what I should do? It would be terrible to delete them only to find out they're used elsewhere.

It's ok to reply after your conference. Thanks in advance for your help.

nicholas
Akeeba Staff
Manager
Precisely, these are the two tables you need to empty. You got it right :)

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!

elau24
Thanks! I deleted everything from scan reports and those 2 tables and even fixed all the paths in _overrider, but a new scan still lists files from development. I'm at a lost where that comes from. I searched the database for the path to the development area or it subdomain name, and the only place is at Akeebabackup. I'm excluding that directory from the backup, so that was expected. Am I missing something here? Thanks again for your help!

nicholas
Akeeba Staff
Manager
The file scanner asks Joomla! to provide the filesystem path to the root directory (the JPATH_ROOT constant) and start scanning from there. Actually, the file scanner uses exactly the same engine as Akeeba Backup. The only difference is that, instead of backing up the files into an archive, it processes them for threat level determination and examines if they have been changed. However, if your development area is in a subdirectory of the main site, then its files will be scanned. At this moment there is not provision for excluding directories from the file scanning.

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!

elau24
I see, and I thought I had done something wrong in the setup. So it's nothing to worry about then. Good.

Btw, what's the _overrider table? I didn't even knew there was such a thing until I searched for the development area path.

nicholas
Akeeba Staff
Manager
I have no idea what _overrider table you are talking about? What is the actual, full name of the table?

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!

elau24
The table name is just _overrider. Looks like it's part of Joomla. It contains a bunch of constants, their values and the source. e.g.

constant: EMAIL_SUBJECT_OK
string: Akeeba Backup has taken a new backup
file: (absolute path to en-GB.com_akeeba.ini)

nicholas
Akeeba Staff
Manager
OK, I now understand what you mean. Yes, that's the language override table. Yes, it's part of Joomla!. I thought you had found a table with a name of something like jos_admintools_overrider, that's why I was wondering what happened :D That table you have there is all normal to be part of a Joomla! site.

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!

elau24
Yup, it's that Joomla table. If I duplicate a site using Akeeba backup/kickstart, would it break anything if I don't fix up the paths in this overrider table? As it is, nothing is broken, but maybe that's because the files it's pointing to are still there.

nicholas
Akeeba Staff
Manager
If you do not fix those paths, all that will happen is that the customised translation strings will not be applied. Nothing more and nothing less.

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!

elau24
So it's not just an informational thing. Got it, thanks!

nicholas
Akeeba Staff
Manager
You're welcome!

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!