database_error

Started by dubinc, December 14, 2021, 05:11:23 AM

Previous topic - Next topic

dubinc

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 ?

Aleksi "Lex" Kilpinen

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.


Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

shadav

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

dubinc

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...

dubinc

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.

Aleksi "Lex" Kilpinen

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 )
Slava
Ukraini!
"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

dubinc

It works with patch "smfmod_ipv6" which disable IPV6 on smf forum !

Thanks for help !

dubinc

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.

Advertisement: