Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: MYSQL Problem  (Read 4207 times)

0 Members and 1 Guest are viewing this topic.

lucasnet

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 37
    • TUNING 4U
MYSQL Problem
« on: January 08, 2005, 07:52:16 pm »

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.

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MYSQL Problem
« Reply #1 on: January 08, 2005, 07:54:17 pm »

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

Joachim
Logged

opulence

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 46
Re: MYSQL Problem
« Reply #2 on: May 13, 2005, 02:26:38 am »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: MYSQL Problem
« Reply #3 on: May 13, 2005, 10:23:13 am »

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

opulence

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 46
Re: MYSQL Problem
« Reply #4 on: May 13, 2005, 03:48:57 pm »

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
Logged

opulence

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 46
Re: MYSQL Problem
« Reply #5 on: May 13, 2005, 04:17:29 pm »

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 ?
Logged

Nibbler

  • Guest
Re: MYSQL Problem
« Reply #6 on: May 13, 2005, 05:38:51 pm »

Coppermine only uses mysql_connect, which drops the connection as soon as the script ends and the page is displayed.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.