News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

My log is being filled with errors

Started by FragaCampos, November 11, 2022, 05:52:53 PM

Previous topic - Next topic

FragaCampos

Hi there.

Since yesterday, my error log is being filled with errors and I don't know by what or whom, since the log doesn't show an IP.

Here's the error (the only thing that changes is the error's url and the SET last_seen value)
Guest
Apply Filter: Only show the error messages of this IP address   
  Reverse chronological order of list Today at 22:48
Apply Filter: Only show the error messages of this session d239977682097deba5724190c0e9ceb0
Apply Filter: Only show the errors of this type Type of error: Database
Apply Filter: Only show the error messages of this URL
https://www.docspt.com/index.php?topic=2553.msg8380
Apply Filter: Only show the errors with the same message
: Out of range value for column 'page_hits' at row 1


UPDATE smf_log_spider_stats
SET last_seen = 1668206885, page_hits = page_hits + 1
WHERE id_spider = 727
AND stat_date = '2022-11-11'
Apply Filter: Only show the errors from this file
File: /home/docsptco/public_html/Sources/ManageSearchEngines.php
Line: 527

Sir Osis of Liver

That shouldn't be happening, but you can fix it by changing Type from SMALLINT to MEDIUMINT or BIGINT for page_hits in smf_log_spider_stats.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

FragaCampos

Thank you, Sir Osis of Liver.
I'll try that.

FragaCampos


Sir Osis of Liver

Looks like your forum is being overrun by spiders.  You should be able to block the worst ones with ,htacess.  Don't have time to look for it right now, but you should be able to search it up.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

Advertisement: