XF 1.5 [MAJOR] An unexpected database error occurred. Please try again later.

[countryside]

Hello,
I just changed servers, and I created a new database to put it in (changed name, username, and password). I then imported everything. I think XenForo is looking for the old one still. How do I change it?

Thanks,
Noah

 

[Paul B]

Point 6 of the FAQ explains the steps involved with switching hosts: https://xenforo.com/community/threads/frequently-asked-questions.5183/#post-180455

 

[countryside]

Point 6 of the FAQ explains the steps involved with switching hosts: https://xenforo.com/community/threads/frequently-asked-questions.5183/#post-180455

I changed the database information, still getting the same error.

 

[countryside]

Also, in Library, I have "config.php" and "config.default.php".

 

[Paul B]

The error is a database error (one of Zend_Db_Exception types) which should have the error message in the page source.

If it doesn't then you will likely need to contact your sysadmin or host for further troubleshooting and support.

 

[countryside]

<?php

$config['db']['host'] = 'localhost';
$config['db']['port'] = '3306';
$config['db']['username'] = ‘USERNAME’;
$config['db']['password'] = ‘PASSWORD’;
$config['db']['dbname'] = ‘DATABASE NAME’;

$config['superAdmins'] = '1';

This correct?

 

[Paul B]

No.

You have used magic quotes for some of the entries - replace them with ''.

 

[countryside]

<?php

$config['db']['host'] = “localhost”;
$config['db']['port'] = “3306”;
$config['db']['username'] = “USERNAME”;
$config['db']['password'] = “PASSWORD”;
$config['db']['dbname'] = “DATABASE NAME”;

$config['superAdmins'] = “1”;

So that? I changed the ' to "

 

[Paul B]

I recommend downloading Notepad++ and using that to edit php files.

You are still using magic quotes:

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

 

[countryside]

<?php

$config["db"]["host"] = “localhost”;
$config["db"]["port"] = “3306”;
$config["db"]["username"] = “user”;
$config["db"]["password"] = “pass”;
$config["db"]["dbname"] = “name”;

$config["superAdmins"] = “1”;

@Brogan - I have that now. All ' are now ".

 

[countryside]

Also, Notepad++ is for Windows only.

 

[countryside]

 

[countryside]

<?php

$config["db"]["host"] = "localhost";
$config["db"]["port"] = "3306";
$config["db"]["username"] = "user";
$config["db"]["password"] = "pass";
$config["db"]["dbname"] = "name";

$config["superAdmins"] = "1";

Aha! Fixed, I belive?

 

[Chris D]

That looks better and your site seems to be up.

For future reference, Atom is a good cross platform text editor. It's developed by GitHub.

 

[countryside]

That looks better and your site seems to be up.

For future reference, Atom is a good cross platform text editor. It's developed by GitHub.

Thanks, will look into this! I use Xcode currently.

 

[TPerry]

Thanks, will look into this! I use Xcode currently

TextWrangler for the win.
I've been using it for a while on my Mac and love it.