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
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.
Thank you, Sir Osis of Liver.
I'll try that.
It seems to have fixed it. Thanks!
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.