Search/Database problem

[eXpl0it3r]

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



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

[Laurent]

I have no idea sorry

[binary1248]

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

[zsbzsb]

This^^ is the exact same thing I got here.

[Laurent]

Did you have all the forums selected for this search?

[eXpl0it3r]

Is there a way not to select all forums?

[Laurent]

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.

[eXpl0it3r]

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

[eXpl0it3r]

Arg it happend again twice today. 
This is getting annoying...

[natchos]

Happening almost constantly. It also gives an error where the browser says that the server sent no data.

[eXpl0it3r]

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

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

[Laurent]

Or does this solution fix it?

It fixes the error message error, but the connection is still lost when the search takes too long.