News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Strange issue...database errors for me but not others

Started by shadav, December 31, 2020, 12:29:07 AM

Previous topic - Next topic

shadav

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

Aleksi "Lex" Kilpinen

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

shawnb61

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?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

shadav

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

Aleksi "Lex" Kilpinen

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

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

Aleksi "Lex" Kilpinen

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

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

kitz

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 

Aleksi "Lex" Kilpinen

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

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

Advertisement: