so um.....about that.... :o
yesterday, everything was fine....today all of my forums keep telling me they have database errors...
contacted my host and they are saying everything is fine...
I again contacted them with screenshots showing that everything is not fine
and they send me back screenshots showing it is fine for them
so now i'm thoroughly confused
not really sure this is a support question for smf or not....
any suggestions?
I've checked the settings.php everything is fine in them
I even tried creating a new database and still can't connect to it...
so I mean, I have no idea what's going on and well as far as my host is concerned everything's fine on their end so that's that...
https://4rearth.info/
https://askthemuslims.com/forum/
http://forum.foamyfanatics.net/
https://shadav.com/forum/
they all show to me
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
thoughts, opinions, suggestions
What if you change browsers or clear all your temporary files? (and perhaps clear the SMF filecache if it's in use)
This just off of a hunch, based on the fact that it's only you who seems affected.
Anything in the smf error log? If you can't login as admin, you may need to look at smf_log_errors via phpmyadmin.
Anything in the apache log?
Php version? Mysql version?
Quote from: Aleksi "Lex" Kilpinen on December 31, 2020, 02:00:39 AM
What if you change browsers or clear all your temporary files? (and perhaps clear the SMF filecache if it's in use)
This just off of a hunch, based on the fact that it's only you who seems affected.
tried that, no luck
Quote from: shawnb61 on December 31, 2020, 02:29:13 AM
Anything in the smf error log? If you can't login as admin, you may need to look at smf_log_errors via phpmyadmin.
Anything in the apache log?
Php version? Mysql version?
php 7.3.25
Server version: 10.4.15-MariaDB-cll-lve - MariaDB Server
Database client version: libmysql - mysqlnd 5.0.12-dev
8192: The each() function is deprecated. This message will be suppressed on further calls
Database Error: Field 'error' doesn't have a default value<br /><br /><br /> INSERT INTO `DBNAME`.smf_log_httpBL(`logTime`, `ip`, `threat`, `last_activity`, `suspicious`, `harvester`, `comment`, `url`, `user_agent`, `errorNumber`, `username`, `raw`, `stopped`)<br /> VALUES<br /> (1609400084, '2601:805:8204:1430:7415:e9a:1fa1:68ab', 0, 0, 0, 0, 0, '/', '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)
a lot of Undefined index and variable errors
2: in_array() expects parameter 2 to be array, null given
a bunch of file not found errors in the log which make no sense
and then
PHP Warning: Unknown: open(/var/cpanel/php/sessions/ea-php71/sess_45840c7d8b2f154d69d34ce02e6a5daa, O_RDWR) failed: No such file or directory (2) in Unknown on line 0
PHP Warning: Unknown: Failed to read session data: files (path: /var/cpanel/php/sessions/ea-php71) in Unknown on line 0
which if i'm reading that right, that's about php7.1 which i'm not using anyways....
Alright, it's not just you - It's most likely httpBL : "Field 'error' doesn't have a default value".
This would probably be fixable by giving the field a default value.
yeah just fixed that, strange that that never popped up before...
but still no joy...
now a new error in the log
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)
ug...so i'm thinking that the httpBL mod went amuck or something??? but why would it out of nowhere just decide to go bonkers
My guess - Your changed Cloudflare settings. httpBL is now seeing stuff it didn't see before.
The exact problem in this case being the IPv6 address - I'm guessing httpBL (or the version you are using) is not compatible with IPv6.
ok then...well....
it was the httpbl mod
went through and manually uninstalled the mod just to see and now I have access to my site again....
don't know what happened between the day before and yesterday, why it decided to block me out of all of my forums but ok....guess I won't be using that mod any more....
now to go and uninstall it from the other sites...crazy little temperamental mods
Hoping someone can help me / give some advice.
I've noticed I suddenly have hundreds of errors similar to the following in my admin logs
Quote
: Field 'error' doesn't have a default value
File: /home/xx/public_html/forum/Sources/httpBL_Subs.php
Line: 298
Only show the error messages of this member Guest
PS not sure if its related either, but after reading shadav's post above.
One of my members mentioned that he wasnt able to access the forum for a while and thought the site was down when it wasn't.
I believe my web host has recently updated to PHP Version 7.3.25
The field needs a default value.
Quote from: Aleksi "Lex" Kilpinen on December 31, 2020, 03:05:54 AM
Alright, it's not just you - It's most likely httpBL : "Field 'error' doesn't have a default value".
This would probably be fixable by giving the field a default value.
Any further support regarding the mod in question, you should direct at the mod's own support topic though httpBL (https://www.simplemachines.org/community/index.php?topic=366399.0)
Quote from: kitz on January 09, 2021, 05:39:00 AM
Hoping someone can help me / give some advice.
I've noticed I suddenly have hundreds of errors similar to the following in my admin logs
Quote
: Field 'error' doesn't have a default value
File: /home/xx/public_html/forum/Sources/httpBL_Subs.php
Line: 298
Only show the error messages of this member Guest
PS not sure if its related either, but after reading shadav's post above.
One of my members mentioned that he wasnt able to access the forum for a while and thought the site was down when it wasn't.
I believe my web host has recently updated to PHP Version 7.3.25
as lex said you should ask for support from the mod creator, now that we know it was that httpBL that was the issue...
but long story short, until they update the mod, any users that use ipv6 will not be able to access your forums
for the meantime unfortunately I had to disable the mod
the error issue is also httpBL, but :)
go to your database look for smf_log_httpBL (your prefix may be different I used smf)
click on structure for that table
then find error and click change for it
under where it says default change it to null and save
anytime you see any messages like that where bla bla bla doesn't have a default value you will need to find it in your database and change it to null
any other questions/issues with the mod please post them in https://www.simplemachines.org/community/index.php?topic=366399.0