Help with SQL Error

[wackoblaze]

Hey can anyone tell me what the SQL Error is and if so, how can I fix it?
THANKS!

 

[Justin M]

What error? You haven't posted one.

 

[death180]

You need to post an error in order for us to help you. There are many SQL errors so we need to know which one.

 

[wackoblaze]

Return to index page General Error
SQL ERROR [ mysql4 ]

Lost connection to MySQL server at 'reading initial communication packet', system error: 113 [2013]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group


(THANTS WHAT IT SAYS ABOVE)

 

[Justin M]

In the config file, are you using localhost for the mysql server in mysql_connect?

 

[wackoblaze]

srry what does local host mean again? Is it like public?

 

[Justin M]

If you open the config file for your forum installation, there will be a command that connects to the mysql server. If it's on the same server as your files it will be localhost, otherwise it's a remote connection. It will look something like this;

$con = mysql_connect("localhost","database_username","database_password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

The other possible solution I have found is that a mysql file has been corrupted, and for that you'll need to get in touch with your hosting provider.

http://bugs.mysql.com/bug.php?id=35737

 

[wackoblaze]

No I think its a localhost then.

 

[Justin M]

Ok, then it's most likely a corrupted file, which only your hosting provider can fix. Who do you host with?

 

[wackoblaze]

my hosting provider is 000webhost.com

 

[Justin M]

Alright, open up a ticket with their support and tell them your problem, they'll hopefully be able to fix it.

 

[wackoblaze]

k thank you very much.

 

[Kashike]

If you open the config file for your forum installation, there will be a command that connects to the mysql server. If it's on the same server as your files it will be localhost, otherwise it's a remote connection. It will look something like this;

$con = mysql_connect("localhost","database_username","database_password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

The other possible solution I have found is that a mysql file has been corrupted, and for that you'll need to get in touch with your hosting provider.

http://bugs.mysql.com/bug.php?id=35737

If you read the post with the error, you would have seen that he is using phpBB, not MyBB. 😉

 

[Justin M]

If you open the config file for your forum installation, there will be a command that connects to the mysql server. If it's on the same server as your files it will be localhost, otherwise it's a remote connection. It will look something like this;

$con = mysql_connect("localhost","database_username","database_password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

The other possible solution I have found is that a mysql file has been corrupted, and for that you'll need to get in touch with your hosting provider.

http://bugs.mysql.com/bug.php?id=35737

If you read the post with the error, you would have seen that he is using phpBB, not MyBB. 😉

I never said it was mybb. Besides, that doesn't change anything, the problem is with mysql and I provided him with a link to the mysql website. His hosting provider needs to fix it, the issue is on their end.

 

[wackoblaze]

now when i try to go on, it says that the website is under review by 000webhost administrator so it should be fixed within 2-4 hours, so its probably gonna work after.

THANK YOU 'Serenade' and 'Justin M'

 

[EdwardJ]

lol wackoblaze... 🙂

 

[wackoblaze]

oh nope, i guess its not fixed. Oh well i'll just have my friend look at it tomorrow.

 

[SpacewardAsh]

If your on 000webhost then the chances of your database being hosted on localhost is pretty slim, you'll have to ask them or find out what database server your database is on.

The last time I checked with them, they did'nt use localhost, they used different database servers that had their own names, and you had to enter the database server name instead of localhost.

 

[wackoblaze]

It works now