Timeout when I search in the logs

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
2 years ago
Guys.. help!
Nop 4.20
Everything works  smoothly, it's a pretty big website.

Since MAY we're facing an issue, everytime I search a word in the logs... a javascript alert appears with an error and in the system log I see:

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

Any ideas?
2 years ago
Clean out the log
Either delete all entries - maybe you will need to try a few times due to the above problem
Or use SQL to delete older entries
2 years ago
At tis point, since you probably have many entries, using SQL is probably best.  I regularly run one like this to get rid of the 'bad' stuff

delete from Log 
where 1=1
  and (
           PageUrl like '%.php%'
        or PageUrl like '%wp-%'
        or PageUrl like '%bitcoin%'
        or PageUrl like '%.asp%'
        or PageUrl like '%/wp/%'
        or PageUrl like '%wordpress%'
        or PageUrl like '%wp-%'
        or PageUrl like '%joomla%'

        or PageUrl like '%apple-touch-icon%'
        or PageUrl like '%.jsp%'
        or PageUrl like '%cgi-bin'
        or PageUrl like '%cgi-sys%'
        or PageUrl like '%.well-known%'
        or PageUrl like '%wallet%'
     )
2 years ago
Thank you guys, we already filtered urls with our CDN so our log is pretty clean but good advice!
I'll try to clean up "info type" entry, keeping just errors and...fingers crossed.

BTW, it's weird, we're talking about 8k record... it should work. :(
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.