XF 2.2 Database Error after Disabling Domain Redirection

[Matthew Hutchinson]

I've been redirecting traffic from an unused domain for the last several months. My board's URL is pointing to the current domain. I just disabled the redirect from my unused domain via my host's control panel and removed the domain from my host. Now, my board is reporting an unexpected database error:

An unexpected database error occurred. Please try again later.

I've submitted a ticket to my host but am hoping someone might also be able to help.

 

[Jeremy P]

You can try viewing the source of the page for a more detailed error.

 

[Matthew Hutchinson]

This is what the page source shows. I've x'ed out the domain name for privacy.

<!-- php_network_getaddresses: getaddrinfo for mysql.xxxxx.net failed: Name or service not known -->

 

[Jeremy P]

That would be the address of the MySQL server you've set in src/config.php. Presumably it's pointing to the old domain and needs to be updated?

 

[Matthew Hutchinson]

Just tried that, but now I'm getting this error with no more source info:

An unexpected error occurred. Please try again later.

 

[Jeremy P]

You would need to check the server error logs (from your host) to see the underlying error.

 

[Matthew Hutchinson]

Great.... And I have no idea what to look for....

 

[Jeremy P]

It can vary by host and hosting control panel. One quick thing to check is that the updated config line has the correct syntax, since the error changed afterwards. It should look like this, including the surrounding single quotes and trailing semicolon:

$config['db']['host'] = 'some-host.com';

 

[Matthew Hutchinson]

The syntax and formatting are intact. All I did was replace the info between the apostrophes in front of the semicolons.

 

[bzcomputers]

Have you tried...

$config['db']['host'] = 'localhost';

 

[Matthew Hutchinson]

Have you tried...

Every time I've created a mysql for a new website, my host's control panel has always said that I must use the host name and that 'localhost' will not work.