MySQL problem (MyBB)

MarkW7 · 9 Jun 2010 at 14:29

I've set up a forum that been going to around 2 weeks everything seems to be running fine but on occasion people including me are getting weird MySQL errors. When they refesh 1-3 times it usually goes.

But why is it coming? I've had a google and it said something about enabling auto_reconnect? But it wasn't well documented and i don't know where to add it.

Any ideas?
Thank you.

GravyMonster · 9 Jun 2010 at 15:11

What error message is it displaying?

There's a lot of things it could potentially be

MarkW7 · 9 Jun 2010 at 15:13

So far it's displayed;

2003
1053
2013

NathanT · 9 Jun 2010 at 15:55

2003 is a connection error to the SQl server, could mean a lot of things

1053 means a server shutdown is in progress, not had this before and had to google it. This is normally caused by a cronjobs being carried out (server side)

2013 is a connection lost error, normally caused by a timeout error or filesizes being set very low in the server config.

I'd get hold of your hosting company, sounds like either your software is bad or the server is.

MarkW7 · 9 Jun 2010 at 16:24

I've got into contact with them, but all they said is to try and do this auto reconnect thing. Which i have no idea how to.

MarkW7 · 12 Jun 2010 at 12:02

Any ideas on this?

NathanT · 12 Jun 2010 at 15:44

They ask you to in-corperate this in to your code? It sounds like a cop out to me, I've only ever had some of those errors on shockingly bad hosts.

If your running a php script, add this to your header file or something that is called each page

my_bool reconnect = 1;
mysql_options(&mysql, MYSQL_OPT_RECONNECT, &reconnect);

I found this code and a decent explanation on the 2nd result of a google search "enable auto_connect" :/