Support

Admin Tools

#22132 Admintools_scanalert table oversized trouble

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 user56570 on Thursday, 26 February 2015 03:49 CST

Monday, 23 February 2015 13:05 CST

user56570
 Hello,

The admintools_scanalerts table in my MySQL database sized 732 Mo.

How is it possible ?

How can I reduce it ?

Regards,

Lematmat

Joomla 3.3.6
AdminTool 3.4.3 

Monday, 23 February 2015 16:45 CST

nicholas
Go to Admin Tools, click on Options. Click on the File Scanner tab. Set "Calculate diffs when scanning" to No. Click on Save & Close.

Now go to PHP File Change Scanner. Click on the "Purge file cache" button.

Problem solved :)

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!

Tuesday, 24 February 2015 02:09 CST

user56570
Hi Nicholas,

I've set to no "Calculate diffs when scanning" and I've also purged the file cache in the "PHP File change scanner" tab.
But the admintools_scanalerts tab remains every big (right now > 746 Mo).

did I miss anything ? Or could there be a delay in the refreshment of the database information displayed ?

Regards,

lematmat

Tuesday, 24 February 2015 06:39 CST

nicholas
Empty the table manually.

From now on, after each scan is complete please look at the report. If you see suspicious files which are legitimate you MUST select them and mark them as safe. Otherwise the same files will appear in the next scan and this consumes more space in the scanalerts 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!

Thursday, 26 February 2015 03:49 CST

user56570
Great,

No more trouble now !

Regards,

lematmat

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!