FYI - Connection Error - Fixed - Advanced Poll

In case someone else finds this useful...

After the poll having worked just fine for months on end, I suddenly started receiving "connection error" along with the php error:
mysql_connect(): User xxx has already more than 'max_user_connections' active connections

The rest of the site is driven using php/mysql, and yet that was still working fine.

Turns out, that to fix the poll, I had to change line 31 of db/include/class_mysql.php from:

$this->conn_id = mysql_connect($this->db['host'].":".$this->port,$this->db['user'],$this->db['pass']);

to:

$this->conn_id = mysql_connect($this->db['host'],$this->db['user'],$this->db['pass']);

Still not sure what got changed on the server, possibly a minor php upgrade. Anyway, I'm happy, it's fixed!

Sounds like you exceeded the max number of connections for that particular port.

Hence why you removed the port bit in the code below...
(the bit in bold and marked with *)

$this->conn_id = mysql_connect($this->db['host']*.":".$this->port*,$this->db['user'],$this->db['pass']);

That's why it started working again because it wasn't set to a specific port on the server.

- Auron

I ran into this error almost immediately, so I input the above fix a few days after I first installed the poll. It seemed to fix it, but now it's back.

MySQL Error : Connection Error
Error Number: 1203 User xxx_adpo1 has already more than 'max_user_connections' active connections
Date : Mon, June 16, 2008 02:34:27
IP : xx.xxx.xxx.xx
Browser : Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)
Referer :
PHP Version : 4.4.8
OS : Linux
Server : Apache/1.3.41 (Unix) mod_jk/1.2.26 mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
Server Name : www.xxx.com
Script Name : /testing/index.php

My site isn't "live" yet, so I'm the only one who's accessing it, i.e., how could I possibly have maxed out any connections? I can't even access the admin because it gives me the exact same error.

If anyone has any ideas I can try, I'd appreciate it.

I'd really like to be able to use this script. I've already edited the template and the poll looks great on my site, but if it's going to keep cutting out on me and ruining my site (the rest of the page refuses to load after the PHP error from the poll), I'm going to have to switch to something else.

Well, thanks for reading,

Kodi

It's pretty self explanatory "1203 User xxx_adpo1 has already more than 'max_user_connections' active connections ". You are probably using the same MySQL user account for several scripts and so are reaching the maximum number of connections per account your host allows.

You are probably using the same MySQL user account for several scripts and so are reaching the maximum number of connections per account your host allows.

Thank you, Carbonize, but I'm not sure that's right (if I'm wrong, please explain further).

If the several scripts are all from Advanced Poll, then that might be accurate, but if you're talking about other MySQL databases, I don't think it can be. I'm currently using four MySQL databases, and each one gave me a different user account. Also, my site is only calling to the Advanced Poll database because the others aren't meant to be integrated into the site like Advanced Poll, and I haven't worked on any of them in months.

I checked the list of databases and they all have different names, and there's only one user in each database, and the user name is the same as the name of the database.

The other databases are:

xxx_mamb1 - Mambo, which I'm planning on deleting because it didn't work well, hence I'm trying to recreate it's poll feature with Advanced Poll, but I still have some text to copy from Mambo before I kill it

xxx_pchat1 - PHP Chat, a php-based chat room

xxx_phpb1 - phpBB, the same forum/bulletin board system as this forum

These databases actually create their own sites/pages, so they aren't called by my Web site (i.e., they aren't called just because I load my Web page), except as a link to another page, and the only one I even have a link to on the template page I'm working on is the forum.

But like I said, I haven't worked on those other databases for months. I was struggling with Mambo for a very long time and recently decided to give up on it and recreate the site on my own (I'm well-versed in HTML and CSS, and can use JavaScript and PHP readily enough, though I don't know anything about creating a script on my own).

I'm currently working on the site template, so I did refresh the page quite a bit while tweaking the template. However, if that's all it takes to max out the user connections, what's going to happen when the site goes live and I have a dozen different polls on a hundred different pages with 1,000 visitors a month? Or is it just if my user account accesses the site too many times? Though I don't see how that could work, since I wasn't even logged into Advanced Poll's admin. I wasn't even working on the poll because I've already finished modifying the HTML and CSS to let it integrate seamlessly into my site. All I was doing was refreshing the page the poll was on.

I've never considered my site to be large, but is it too big for Advanced Poll? It's already breaking on a single page that's been refreshed maybe a hundred times over about an 8-hour period.

Or is there something I can modify, or ask my hosting provider to modify, that will allow Advanced Poll to work?

If anyone has any further information, I'd appreciate it.

And thanks for taking the time to read this.

Take care,

Kodi

That is exactly what the message means. The database account you are using has reached it's allowed limit of connections.