MYSQL.PHP

[MobTown]

Recently I have purchased version 1 (yeah i'm cheap)

of MCCodes, i have had no problems up until the last few days, in those few days i keep getting the message

 

Warning: mysql_connect() [function.mysql-connect]: Too many connections in /home/www/lords-of-mobtown.com/mysql.php on line 3

I got onto my host, as i believed that is where the fault lied, however they have told me it is probably due to not closing the sql connection.

Could some please adivise me if this is indeed the problem, my mysql.php file can be seen below, (naturally i have * sensitive data)

 

<?

$c=mysql_connect('***.***.com','******_******','password') or die('Sorry, technical faults have slowed down this site, please try again later.');

mysql_select_db('*****_****',$c);

?>

[Guest Anonymous]

Re: MYSQL.PHP

try contacting your hosting company about the issue am rather sure it's on there side with the problem.

[MobTown]

Re: MYSQL.PHP

thank you

for the response, but the thing is they are saying it is not.

as mentioned they think it is due to me not closing my mysql connction.

[Isomerizer]

Re: MYSQL.PHP

The host can also allow more connections.

[MobTown]

Re: MYSQL.PHP

ok so i may sound like a noob, but i tried adding msyql_close($c) to the end of mysql.php

 

<?

$c=mysql_connect('***.***.com','******_******','password') or die('Sorry, technical faults have slowed down this site, please try again later.');

mysql_select_db('*****_****',$c);

mysql_close($c);

?>

But this simply stopped all my queries from working, showing an error,

 

Warning: mysql_query(): 4 is not a valid MySQL-Link resource in /home/www/SITENAMEHERE/index.php on line 11

If mysql_close() is indeed the answer, where should it be put?

 

The host can also allow more connections.

This is what I suggested to the host when they replied with the close sql connections.

Again, any help would be greatly appreciated.

[Isomerizer]

Re: MYSQL.PHP

Use the mysql_close at the end of the script, so erm in the endpage() function would be a good idea. Think its located in header.php

[Floydian]

Re: MYSQL.PHP

placing mysql close at the end of a script is likely to change nothing. php actually does you the favor of closing the database connection at the end of a script anyways, UNLESS you EXPLICITLY ask for a persistent connection.

But don't take my word for it, make a script "page1.php" and connect to the database, but don't close the connection. Then make a page "page2.php" and put some queries in there, but don't open a connection. And watch, you won't be able to connect to the database, even if you load page1.php first, and then page2.php.

;)

Web host, it really does sound like something they need to fix.

[topmorpg]

Re: MYSQL.PHP

If someone is refreshing pages greatly this causes a problem.

It opens multiple connections for that user till it clears the database. thus multiple connections open.

now get a few people doing this.

You can fix this by:

disable auto refreshing, clickers in your site.

require the form buttons to be used.

Generate a log in the database and log the time of there last action. if it is under 2 seconds warn them to slow down. This is the nice way of doing it. The not so nice way is have your host install something to auto block them on massive amounts of connections limiting there connections to say 5 per ip.

This will slow it. However taking all this into account.

If you are on a cheap unlimited host forget all of the above first and get a real host that can handle the higher loads, and work with you the paying customer.

I raise max connections for clients all the time on there boxes. No reason why they cant do it for you.

TJ

[MobTown]

Re: MYSQL.PHP

thank you for your support here, i think the problem is now underhand.

btw i do have a real host lol :-D

i would post name, but i would deem it as advertising so can only assume admin would as well.

if any problem arises again i will be sure to ask here.

+1 to all.

[MobTown]

Re: MYSQL.PHP

Hi again, as previously mentioned, i believed the problem to be underhand since doing everything suggested here. However

since the last post, although i myself have not experienced any problems i have had numerous emails telling me that the error still exists, is there anything else i can do?