Advertisement:

Author Topic: Strange issue...database errors for me but not others  (Read 525 times)

Offline shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,053
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Strange issue...database errors for me but not others
« on: December 31, 2020, 12:29:07 AM »
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

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,593
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Strange issue...database errors for me but not others
« Reply #1 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.
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"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

Online shawnb61

  • Developer
  • SMF Hero
  • *
  • Posts: 2,967
    • sbulen on GitHub
Re: Strange issue...database errors for me but not others
« Reply #2 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?
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,053
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Strange issue...database errors for me but not others
« Reply #3 on: December 31, 2020, 03:01:22 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

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

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,593
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Strange issue...database errors for me but not others
« Reply #4 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.
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"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

Offline shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,053
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Strange issue...database errors for me but not others
« Reply #5 on: December 31, 2020, 03:11:07 AM »
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

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,593
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Strange issue...database errors for me but not others
« Reply #6 on: December 31, 2020, 03:14:21 AM »
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.
« Last Edit: December 31, 2020, 03:31:32 AM by Aleksi "Lex" Kilpinen »
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"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

Offline shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,053
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Strange issue...database errors for me but not others
« Reply #7 on: December 31, 2020, 11:45:49 AM »
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

Offline kitz

  • Jr. Member
  • **
  • Posts: 135
    • kitz.co.uk
Re: Strange issue...database errors for me but not others
« Reply #8 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 

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 19,593
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • My Daily Dose Of Blasphemy
Re: Strange issue...database errors for me but not others
« Reply #9 on: January 09, 2021, 05:43:17 AM »
The field needs a default value.
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
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"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

Offline shadav

  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,053
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Strange issue...database errors for me but not others
« Reply #10 on: January 09, 2021, 02:47:10 PM »
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