Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: dubinc on December 14, 2021, 05:11:23 AM

Title: database_error
Post by: dubinc on December 14, 2021, 05:11:23 AM
Hello,

After migration i run smf 2.0.18 with php 7.3.31, mysqli mysqlnd 5.0.12-dev and mysql 5.7.33.

Specific (anonymous) user profiles (ip ?) encounter the error database_error. The same anonymous user with vpn has no error.

There is no details in (database) logs ...
Is there a way to store logs in file ?
Title: Re: database_error
Post by: Aleksi "Lex" Kilpinen on December 14, 2021, 05:20:33 AM
Could you get us the actual error message? Would help.
But I'm guessing the problem is likely that your user has an ipv6 address, and 2.0 doesn't really like ipv6.


Title: Re: database_error
Post by: shadav on December 14, 2021, 11:15:48 AM
are you using the httpbl mod by chance? I had that issue with that mod and using ipv6
you will either have to disable the mod or have everyone that visits your site disable ipv6 (if they know how or if they can)

in your admin under maintenance then under logs and error logs
what errors are shown there
Title: Re: database_error
Post by: dubinc on December 14, 2021, 03:22:35 PM
Hello,

Thanks for help !

A screen/page show the error "Erreur base de donnĂ©es" = "Database Error" =  database_error

The error appear in  admin -> log journal :  Type d'erreur: database but the rest of the information is empty...
Title: Re: database_error
Post by: dubinc on December 15, 2021, 05:34:20 AM
Indeed it's ipv6 ....

Thanks a lot !

Next step find a bypass solution.

Is SMF 2.1 solve this problem ?

@shadav i'm on a shared hosting. I will looking for disabling httpbl mod in htaccess or a similar solution to prevent ipv6.
Title: Re: database_error
Post by: Aleksi "Lex" Kilpinen on December 15, 2021, 08:41:28 AM
It's most likely not directly an issue in SMF, it's likely a problem with a mod that stores IP addresses. ( Such as httpbl )
Title: Re: database_error
Post by: dubinc on December 28, 2021, 06:10:40 AM
It works with patch "smfmod_ipv6" which disable IPV6 on smf forum !

Thanks for help !
Title: Re: database_error
Post by: dubinc on January 17, 2022, 02:39:07 PM
Quote from: dubinc on December 28, 2021, 06:10:40 AMIt works with patch "smfmod_ipv6" which disable IPV6 on smf forum !
Thanks for help !
It doesn't works when connected...
Blocking IPV6 solve the problem.