Minor MySQL error

[matius4]

Hello Everyone,

I understand this issue has been posted before but none of the threads could give me the answer I was looking forward. So I thought I would ask.

This is an error I am only getting on very few occassions.

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Wednesday 11th of May 2005 09:33:11 PM
Script: http://www.magazineforall.co.uk/forum/subscription.php?do=addsubscription&f=8
Referer:
IP Address: 207.46.98.45

I understand that this error can be caused by incorrect settings in the config file. I have ensured these are correct.

Is it possible that the MySQL on my server has got "too many connections" I have looked at other threads which state this could be the problem. I'd like to be sure though before I bother my host about it. I wasn't sure either.

Thanks in advance

Matthew

[Marco van Herwaarden]

The most common reasons for this are:
- Wrong settings in config.php (in which case you would probably get this always)
- Wrong permissions for the MySQL database user (same goes as above)
- Server/MySQL overloaded.
- In some cases it could be because of a hack installed. Did you install any hacks, if yes which ones?

[matius4]

Thanks for your reply

I am only getting this error every so often. So is it possible that I can rule these out

- Wrong settings in config.php (in which case you would probably get this always)
- Wrong permissions for the MySQL database user (same goes as above)

I also don't have any hacks installed.

What should I ask my host to do if the MySQL/sever is getting overloaded?

Thanks for your time. If anyone else has suggestions I would be very greatful

[George L]

you need to get your web host to optimise their my.cnf mysql settings file and increase their max_connections value

read or point this link to your web hosts http://dev.mysql.com/doc/mysql/en/to...nnections.html

[matius4]

Thanks for your post eva I've got my host onto it. I'll let you know how it goes.

[George L]

no probs