Database problem I think?

[griffinzx10]

Some members on my forum are seeing something weird with their PM box.
It shows this:
65,534 New PMs. You have 29 total out of 50 allowed

I am assuming that there is some corruption in my database?

This is the third person who said they are seeing this, one person who had it, all of a sudden said, it's fixed, and I didnt do anything.

My hosting company has been having issue with their MySQL servers, and today alone I have received 120 database notifications.

Any info would be greatly appreciated.
Thanks

[Steve Machol]

Assuming you are not using any third-party add-ons, fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

[griffinzx10]

Assuming you are not using any third-party add-ons, fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Please include a complete description of the problem and be sure to include the login info to your Admin CP, phpMyAdmin and FTP in the 'Sensitive Data' field.

Thanks...

[griffinzx10]

Actually, what do I do if I cannot find my information for the license, and password... What do I do? I know I have a valid license, but cant remember the info.

Also on a second note, would I be able to create a ticket for 2 issues at the same time, my hosting company recently upgraded to MySQL 5.0 and I am told that I have 1 MySQL database id, and that it is using more then the 10 concurrnet connections allowed by their servers, as a result my site is running slow, getting a lot of errors and over all problems.
They said that I need to create another DB id, would you all be able to help me with that?

And finally, I wanted to know how much it would cost to upgrade from version 3.5.3 to the newest version?

As always thanks so much for your help.

[Steve Machol]

You can use the lost password link to have your customer number and password sent to you:

http://www.vbulletin.com/members/lostpw.php

If your host limits you to 10 concurrent connections , then you are going to have problems. You will only be able to run the smallest of forums with that kind of restriction.

If you have an active license, you can download and upgrade to the latest version of vB at no charge. If not, then you willl need to renew your license.

[griffinzx10]

You can use the lost password link to have your customer number and password sent to you:

http://www.vbulletin.com/members/lostpw.php

If your host limits you to 10 concurrent connections , then you are going to have problems. You will only be able to run the smallest of forums with that kind of restriction.

If you have an active license, you can download and upgrade to the latest version of vB at no charge. If not, then you willl need to renew your license.

Thank you, I will fill out the lost password sheet.

What are my options regarding the concurrent connections, they told me to create a new id for my database and that should work, but my hosting company isnt the brightest... My site isnt that large, I have almost 2000 members, but at any given point in time there are probably btwn 1-45 people on my site at any 1 given time. Does this mean I might need to go to a dedicated server situation?

Regarding the upgrade, 2 years ago, when I purchased Vbulletin, I paid 160.00 for my license. Does that mean I can upgrade? I know I upgraded once before, and I had 1 free upgrade, and I used that.

Again, sorry to be a PITA, just need to know what some of my options are.

[Steve Machol]

Your host's response doesn't make any sense to me. You will have to ask them to clarify this.

I would expect most shared hosting plans would be able to handle up to 45 concurrent users at one time.

As for the upgrade, check your license. If it's active,. then you can download the latest version of vB and upgrade. If not, then you need to renew the license first.

[griffinzx10]

So what should I ask? They said that their new MySQL server only handle 10 concurrent connections.... And I am constantly over my limit, but like I also said, at any given time, I have 0-45 users on my site at once.. Not much as changed in 2 year on that end, other than more total members, but not more overall traffic, and more posts and threads

[griffinzx10]

This is the error msg I keep getting, almost 300 in the past 36 hours


Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User
griffinzx10 already has more than 'max_user_connections' active connections
/hermes/web08/b734/pow.griffinzx10/htdocs/forum/includes/class_core.php on line 279

MySQL Error :
Error Number :
Date : Wednesday, September 5th 2007 @ 01:49:39 PM
Script :

http://www.tampasportbikes.com/forum/image.php?u=2805&dateline=1188755990

Referrer : http://www.tampasportbikes.com/forum...d.php?p=263903
IP Address : 69.46.237.80
Username :
Classname : vb_database

[Steve Machol]

This is a server/host issue. The server has maxed out the number of MySQL connections your host allows you to have. You can try turning persistent connections off in your config.php:

        //      ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
        //      This option allows you to turn persistent connections to MySQL on or off.
        //      The difference in performance is negligible for all but the largest boards.
        //      If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0; 

But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.

Here is more info on this error:

http://dev.mysql.com/doc/refman/4.1/en/user-resources.html

http://dev.mysql.com/doc/refman/5.0/en/user-resources.html

[griffinzx10]

Thanks Steve

[griffinzx10]

Hey Steve, I just went into my the FTP for my site, and went to:

Root folder, /forum/includes/config.php

I believe it is already set to 0 this is what it shows..

// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;


So I guess it's time to start looking for a new company, huh?

[Steve Machol]

Yes, as I said in your support ticket yestersday this is a ridiculously low limit your host has imposed and the only viable option is to find a better host.

[griffinzx10]

Steve, may I ask for your recommendation on who I might consider for web hosting? Someone that can offer better connections, be able to upload my database in whole, not have to split it up to upload..

[Steve Machol]

Sorry but we don't provide official recommendations for hosts. I suggest you view the vBulletin Hosting Options forum for advi
ce from our customers:

http://www.vbulletin.com/forum/forumdisplay.php?s=&forumid=11

Note that vBulletin requires a web server that includes relatively recent versions of PHP (minimum 4.3.3) and MySQL (minimum 4.0.16) installed. Make sure that any host you are considering offers this support. I also strongly recommend you choose a host that provides telnet or ssh access since this will make it much easier to backup and restore your database if you ever need to.