Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!
Hi Everybody,
in november I had an Attack on my Domain. Problem: Since that Day my nice Mint-Installation shows a biiiig big bar in November that doesn’t suite to the other small bars and really bothers me. I already deleted those Attacks in the SQL-Database for Mint, but it still shows the big bar.
What and where else do I have to delete something to make Mint forget this Attack?
Thanks for help!
Log into your your Mint installation and visit yourdomain.com/mint/?visits and read the instructions very carefully. That utility will allow you to remove the attack visits.
Don’t mess with the drop-down menus (those are only there in case your Mint Visits array gets corrupted and you need to reindex timestamps), all you need to change is the Total and Unique visits in the text inputs for the month of November.
Thanks Shaun. The Problem is, that the attacks mixed with normal visits. So with this tool I can only guess how many visits there might have been in november and change the total number, right?
That’s simple but is there no possibility where I can go to these specific 2 days where I had the attacks and delete these numbers directly?
That’s correct.
Unfortunately there isn’t a way to isolate just those two days. Mint aggregates its visit counts to keep the database size down.
If you have a backup of your visits table from just after the November attack you could run a query against that table to find the number.
SELECT *, COUNT(ip_long) as hit_count FROM [BACKUP TABLE NAME HERE] GROUP BY ip_long ORDER BY hits DESC;
The record at the top of the list is probably your offender so you could use the value in the hit_count column to adjust Mint’s hits.
thanks for your help! In Google Anaylitics (runs parallel with mint) I found the two days and subtracted these day’s hits from the total month’s. That made it possible to correct the values in mint.
You must be logged in to reply. Login above or create an account
