Welcome, Guest. Please login or register. Did you miss your activation email?

Author Topic: Search/Database problem  (Read 5855 times)

0 Members and 1 Guest are viewing this topic.

eXpl0it3r

  • SFML Team
  • Hero Member
  • *****
  • Posts: 10801
    • View Profile
    • development blog
    • Email
Search/Database problem
« on: July 24, 2012, 06:33:42 pm »
I've now run twice into this database error with the search function and I guess it could happen even more often if I'd need to use the search function more (which I probably should have ;D).



Do you know the reason for this and/or how it could get fixed?


(A side note isn't 128kb individual file size a bit too limiting, e.g. couldn't add the image as attachment....)
« Last Edit: July 26, 2012, 12:27:42 am by eXpl0it3r »
Official FAQ: https://www.sfml-dev.org/faq.php
Official Discord Server: https://discord.gg/nr4X7Fh
——————————————————————
Dev Blog: https://duerrenberger.dev/blog/

Laurent

  • Administrator
  • Hero Member
  • *****
  • Posts: 32504
    • View Profile
    • SFML's website
    • Email
Re: Search/Database problem
« Reply #1 on: July 25, 2012, 10:47:38 pm »
I have no idea sorry :(
Laurent Gomila - SFML developer

binary1248

  • SFML Team
  • Hero Member
  • *****
  • Posts: 1405
  • I am awesome.
    • View Profile
    • The server that really shouldn't be running
Re: Search/Database problem
« Reply #2 on: July 26, 2012, 03:15:44 pm »
Found this: http://www.simplemachines.org/community/index.php?topic=423482.msg3325138#msg3325138

Happens to me on my server a lot too that the MySQL daemon drops connections under too much load. I guess I tuned the my.conf too much :P
SFGUI # SFNUL # GLS # Wyrm <- Why do I waste my time on such a useless project? Because I am awesome (first meaning).

zsbzsb

  • Hero Member
  • *****
  • Posts: 1409
  • Active Maintainer of CSFML/SFML.NET
    • View Profile
    • My little corner...
    • Email
Re: Search/Database problem
« Reply #3 on: July 29, 2012, 02:56:03 pm »
This^^ is the exact same thing I got here.
Motion / MotionNET - Complete video / audio playback for SFML / SFML.NET

NetEXT - An SFML.NET Extension Library based on Thor

Laurent

  • Administrator
  • Hero Member
  • *****
  • Posts: 32504
    • View Profile
    • SFML's website
    • Email
Re: Search/Database problem
« Reply #4 on: July 29, 2012, 03:00:00 pm »
Did you have all the forums selected for this search?
Laurent Gomila - SFML developer

eXpl0it3r

  • SFML Team
  • Hero Member
  • *****
  • Posts: 10801
    • View Profile
    • development blog
    • Email
Re: Search/Database problem
« Reply #5 on: July 29, 2012, 03:07:51 pm »
Is there a way not to select all forums?
Official FAQ: https://www.sfml-dev.org/faq.php
Official Discord Server: https://discord.gg/nr4X7Fh
——————————————————————
Dev Blog: https://duerrenberger.dev/blog/

Laurent

  • Administrator
  • Hero Member
  • *****
  • Posts: 32504
    • View Profile
    • SFML's website
    • Email
Re: Search/Database problem
« Reply #6 on: July 29, 2012, 04:32:54 pm »
Of course, below "CHOOSE A BOARD TO SEARCH IN, OR SEARCH ALL" ;)

It would be much better if it was expanded by default though. I'll see if I can change that.
Laurent Gomila - SFML developer

eXpl0it3r

  • SFML Team
  • Hero Member
  • *****
  • Posts: 10801
    • View Profile
    • development blog
    • Email
Re: Search/Database problem
« Reply #7 on: July 29, 2012, 04:41:38 pm »
Of course, below "CHOOSE A BOARD TO SEARCH IN, OR SEARCH ALL" ;)

It would be much better if it was expanded by default though. I'll see if I can change that.
Ah lol, I never noticed that it's expandable. ;D
I was always thinking about what unchecking the 'Check all' box would do, or what the sense is, since you "can't" choose specific forums. ;)
Official FAQ: https://www.sfml-dev.org/faq.php
Official Discord Server: https://discord.gg/nr4X7Fh
——————————————————————
Dev Blog: https://duerrenberger.dev/blog/

eXpl0it3r

  • SFML Team
  • Hero Member
  • *****
  • Posts: 10801
    • View Profile
    • development blog
    • Email
Re: Search/Database problem
« Reply #8 on: August 04, 2012, 10:03:10 pm »
Arg it happend again twice today.  >:(
This is getting annoying... :-\
Official FAQ: https://www.sfml-dev.org/faq.php
Official Discord Server: https://discord.gg/nr4X7Fh
——————————————————————
Dev Blog: https://duerrenberger.dev/blog/

natchos

  • Jr. Member
  • **
  • Posts: 97
    • View Profile
    • Email
Re: Search/Database problem
« Reply #9 on: August 16, 2012, 11:42:30 pm »
Happening almost constantly. It also gives an error where the browser says that the server sent no data.

eXpl0it3r

  • SFML Team
  • Hero Member
  • *****
  • Posts: 10801
    • View Profile
    • development blog
    • Email
Re: Search/Database problem
« Reply #10 on: September 03, 2012, 04:48:31 pm »
Well the search function seems to become more and more useless, i.e. I've now tried to search something 10 times in a row and always either got the PHP error from above or an EMPTY_RESPONSE from the server... >:(

I did a little research and came up with this statement about the error (source):
Quote from:  Spuds
This error basically means that sometime between when the page load began (which means an sql connection was made) but before the end the page the mysql connection dropped.  This should *never* happen but it does, I don't know why but it does.
Laurent: Could you maybe check the MySQL logs & SFM logs for strange mysql drops or similar and/or contact your hoster, maybe they know more about this...

I've also found these two threads, but I haven't digged all the way through it, but maybe there's a solution somewhere:
http://www.simplemachines.org/community/index.php?topic=423482.0
http://portamx.com/2835/error_log-shows-an-error-in-subs-db-mysql-php-on-line-130/

Or does this solution fix it?

Edit: Ah well binary actually linked already to that issue, so it seems to be that the MySQL server just drops the connection because of too much load. So this should be solved by the hoster...
« Last Edit: September 03, 2012, 04:56:29 pm by eXpl0it3r »
Official FAQ: https://www.sfml-dev.org/faq.php
Official Discord Server: https://discord.gg/nr4X7Fh
——————————————————————
Dev Blog: https://duerrenberger.dev/blog/

Laurent

  • Administrator
  • Hero Member
  • *****
  • Posts: 32504
    • View Profile
    • SFML's website
    • Email
Re: Search/Database problem
« Reply #11 on: September 03, 2012, 04:54:52 pm »
Quote
Or does this solution fix it?
It fixes the error message error, but the connection is still lost when the search takes too long.
Laurent Gomila - SFML developer