MYSQL Problem MYSQL Problem
 

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

Main Menu

MYSQL Problem

Started by lucasnet, January 08, 2005, 07:52:16 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lucasnet

I see that error:

Coppermine critical error:
Unable to connect to database !
MySQL said: User xxx_blax has already more than 'max_user_connections' active connections

My admin said me that my script has got an error. Max 20 connections are open and dont close.

??
LuCaS ( lucas@tuning4u.info ) GG: 40139
---------------------------------------------------------
http://tuning4u.info - best wallpapers and tuning photos

Joachim Müller

The connections close when the script finishes, see http://www.php.net/manual/en/function.mysql-close.php

Joachim

opulence

I'm having the same problem... will it go away?

Joachim Müller

ask your webhost for support, this is not coppermine-related.

opulence

lol that's funny because my admin is saying the opposite :(

He's saying it's because the script isn't closing too!

*sigh* it sucks being stuck as the middle man

opulence

I think it might have something to do with idle persistent connections.

Is there someplace in coppermine where I can set a lower "wait_timeout" ?

does coppermine use mysql_connect or mysql_pconnect ?

Nibbler

Coppermine only uses mysql_connect, which drops the connection as soon as the script ends and the page is displayed.