Topic: httpBL

[Shades.]

Congrats, and I'm so sorry at the same time

eh well simple enough to disable ipv6 on my computer  and I'm back up and running again...

hm, but this could be a problem for my users...hm.....well about that....may still need to remove this mod anyways if others who use ipv6 can't access the site, that's gonna be an issue

I just tested my connection at testmyipv6.com and it says Im on this ipv6. I'm also using this mod on several of my sites and have had no issues myself. I hope this wont be a problem. 

[Aleksi "Lex" Kilpinen]

Could also be a different version of the mod, or something else differing - but based on the error I saw, the DB field for IP in shadav's install couldn't hold an IPv6 address because of it's length.

[shadav]

here's where Lex is talking about

after a day of my site being down...I thought it was my host at first but then turns out it wasn't....for me I was seeing database error message but for everoyne else the site was fine....
after checking error logs httpbl was the one giving issues...which again is strange as it hadn't ever popped up before

https://www.simplemachines.org/community/index.php?topic=576208.0

after fixing the default to null, the last error that showed up was

Database Error: Data too long for column 'ip' at row 1<br /><br /><br />         INSERT INTO smf_log_httpBL(`logTime`, `ip`, `threat`, `last_activity`, `suspicious`, `harvester`, `comment`, `url`, `user_agent`, `errorNumber`, `username`, `raw`, `stopped`)<br />         VALUES<br />            (1609402130, '2601:805:8204:1430:7415:e9a:1fa1:68ab', 0, 0, 0, 0, 0, '/index.php?action=enotify', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', 200, 'Guest', 'unknown', 2)

[SugarD-x]

Database Error: Data too long for column 'ip' at row 1<br /><br /><br />         INSERT INTO smf_log_httpBL(`logTime`, `ip`, `threat`, `last_activity`, `suspicious`, `harvester`, `comment`, `url`, `user_agent`, `errorNumber`, `username`, `raw`, `stopped`)<br />         VALUES<br />            (1609402130, '2601:805:8204:1430:7415:e9a:1fa1:68ab', 0, 0, 0, 0, 0, '/index.php?action=enotify', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', 200, 'Guest', 'unknown', 2)

That's likely because SMF 2.0.x is designed to store IPv4 addresses only, which are a specific length. IPv6 support was officially added in SMF 2.1.x, however this mod sadly has not been updated to support those versions yet.