database problem

[u3a3e3]

I'm getting this error to my email so much


atabase error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'ruae.db.8528892.hostedresource.com' (2)
/home/content/92/8528892/html/vb/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Thursday, December 29th 2011 @ 08:41:29 AM
Error Date : Thursday, December 29th 2011 @ 08:41:29 AM
Script : http://www.r-uae.net/vb/showthread.php?t=7838
Referrer : http://www.r-uae.net/vb/forumdisplay.php?f=76
IP Address : 2.49.151.238
Username :
Classname : vB_Database
MySQL Version :

my config.php is correct and my forum is working but between time to time I get database error page .

how to fix it ?

[u3a3e3]

If necessary I'll pay for support services from vbulltine team but I need solutions .

[PossumX]

database problem

It's a hosting company issue, where your forum can't connect to their database server platform. They need to figure that out, so I would file a ticket with the host. Are you getting any other errors like max connections exceeded?

[Wayne Luke]

You're trying to access a server that doesn't exist on the network. Verify that the MySQL Host name is correct with your hosting provider and update your config.php file needed.

[u3a3e3]

thank you for your answers but the hosting company says it's you scripting problem from your side, we checked our databases and everything seems fine nothing .

still getting database error reports over 50 message per day last one was


Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Unknown MySQL server host 'ruae.db.8528892.hostedresource.com' (1)
/home/content/92/8528892/html/vb/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Saturday, December 31st 2011 @ 10:53:21 PM
Error Date : Saturday, December 31st 2011 @ 10:53:21 PM
Script : http://r-uae.net/vb/
Referrer : http://r-uae.net/vb/
IP Address : 64.31.20.218
Username :
Classname : vB_Database
MySQL Version :

I checked my config.php file and servername, password, username, all correct but still I get each minute database error page in my forum then error report to my email, I even upgraded my forum to vBulletin 3.8.7 patch level 2 deleted my database then restore it, still the getting database error .

my hosting company is www.godaddy.com

help plz

[Zachery]

That is an error from php (which we use) connecting to mysql. The error has nothing to do with our script and everything to do with their network and setup.

[u3a3e3]

That is an error from php (which we use) connecting to mysql. The error has nothing to do with our script and everything to do with their network and setup.

I talked to the hosting company and they still say there's no problem from our side ...etc (nothing useful)

would you log in my forum and take a tour and tell me whats the problem and how to fix it I'll PM you my admin username and password if you agree

wait your reply ..

[Zachery]

Assuming that your mysql information is 100% correct, the error is from php trying to connect to mysql

Unknown MySQL server host 'ruae.db.8528892.hostedresource.com' (1)

Are you sure the hostname is correct?

[u3a3e3]

my config.php file

$config['Database']['dbtype'] = 'mysql';
$config['Database']['dbname'] = 'dbusername';
$config['Database']['tableprefix'] = '';
$config['Database']['technicalemail'] = '[email protected]';
$config['Database']['force_sql_mode'] = false;
$config['MasterServer']['servername'] = 'ruae.db.8528892.hostedresource.com';
$config['MasterServer']['port'] = 3306;
$config['MasterServer']['username'] = 'username';
$config['MasterServer']['password'] = 'password';
$config['MasterServer']['usepconnect'] = 0;

and the rest is set to default .
the server name got it from phpymyadmin .
if the servername is wrong you know that the forum won't work at all but the forum is working its just between time to time I get database error in control panel or surfing the forum or writing threads .

this is one of the error I got today

http://imageshack.us/photo/my-images/716/errordatabase2.jpg/

then I receive error report the usual reports to my email over 100 message per day

http://imageshack.us/photo/my-images/710/errordatabasep.jpg/

here's the latest hosting company reply

============

Thank you for your reply. I have reviewed your issue with our advanced hosting support team. Their review of the database server indicates no over utilization at this time, and all of our attempts to replicate your issue have failed. We are able to connect to your database without issue at this time. When reviewing your account we did notice tables in your database that were rather large. One table had over 900,000 records, and we would advise archiving some of this data to help with database access issues.

=========

by the way my database size is only 160 mb in this forum, and I have another forum with database size 500mb but not encountering any problems is working fine and in same hosting company
if the issue is related to table as they say then what to do and how to solve it .

thank youZachery for your time and support really really appreciated .

[Zachery]

You should set the hostname to the same that shows in your godaddy databases page.

[u3a3e3]

You should set the hostname to the same that shows in your godaddy databases page.

http://imageshack.us/photo/my-images/857/godaddy.jpg/

its same hostname whether from phpmyadmin or godaddy page .

[Zachery]

Then your host is lieing to you. I'm not sure what else I can tell you.

[u3a3e3]

Then your host is lieing to you. I'm not sure what else I can tell you.

I downloaded new fresh vbulletin 3.8.7 patch level 2 from customer area moment ago to see something

I noticed in config.php.new or lets say config.php it starts with

<?php

but it doesn't ends with

?>

is that will case this kind of problem that I'm having ?

I believe it does how about you ?

[Zachery]

No, that is fine, it actually can help avoid issues.

[TheNewOne]

I use godaddy and dont have this problem you have not added the correct info into the config