Database Error: Out of range value for column 'most_on' at row 1

[dsanchez]

Noticed lots of spammers lately in the forum and getting this error in the db error logs:

Any thoughts?

Code Select Expand

Type of error
Database
Error message
Database Error: Out of range value for column 'most_on' at row 1
File
/var/www/html/smf/Sources/Logging.php
Line
372
URL of page causing the error
myforum.com/index.php?topic%3D3438.msg774739

[vbgamer45]

Requires a database change Change smallint to mediumint or int in table smf_log_activity

[shawnb61]

...or better bot management.

...or apply the session change recommended here:
https://www.simplemachines.org/community/index.php?msg=4190204

Since making that change, my most_on has been reasonable.

Or better yet, both bot management and the session change.

[dsanchez]

...or better bot management.

...or apply the session change recommended here:
https://www.simplemachines.org/community/index.php?msg=4190204

Since making that change, my most_on has been reasonable.

Or better yet, both bot management and the session change.

thanks, applied the patch

https://github.com/SimpleMachines/SMF/pull/8394/commits/2f2a5e0ae404fd1adb408b87896ce00cca1715ec#diff-4edd47bd0375fd8cc8df23ccd9a41ddb948e0d8f256b8bdfe0d603b104c109dd

what's bot management? didn't find any package with that name...

[shawnb61]

No patch.  I was referring to using .htaccess to block bad guys.

See info here:
https://www.simplemachines.org/community/index.php?msg=4179600

& an example here:
https://github.com/sbulen/SMF-bot-hygiene