XF 1.5 An unexpected error occurred. Please try again later.

[Jazem]

Xenforo I get this error:

I'm sure database credentials are correct. This happened when I was transferring hosts. Config.php was updated and old .sql file was exported from old host and imported into this one.

 

[Optic]

For the unexpected error, if you check the page source is there more details on the error?

Looks like a corrupt backup.. how was the backup created?

 

[Jazem]

For the unexpected error, if you check the page source is there more details on the error?

Looks like a corrupt backup.. how was the backup created?

There are no more details when I check page source. Backup created by zipping my web files and downloading it, then uploading to new host and unzipping.

 

[Optic]

OK but how was the database backup created? Did you use the command line with mysql or use phpMyAdmin? Because very likely the way it was exported is causing this issue.

Do you have access to the old server to re-create the database backup?

Also check if your new server meets the requirements using this script:
https://xenforo.com/xenforo-requirements-test.zip

XenForo System Requirements

• PHP: 5.2.11+
• MySQL: 5.0+
• PHP extensions: MySQLi, GD (with JPEG support), PCRE, SPL, SimpleXML, DOM, JSON, iconv, ctype
• PHP safe_mode off

 

[Jazem]

OK but how was the database backup created? Did you use the command line with mysql or use phpMyAdmin? Because very likely the way it was exported is causing this issue.

Do you have access to the old server to re-create the database backup?

Also check if your new server meets the requirements using this script:
https://xenforo.com/xenforo-requirements-test.zip

Database backup created through myPhPAdmin and I meet system requirements, thanks for the test script

 

[whynot]

Database backup created through myPhPAdmin

That can be a big problem with large databases.

 

[Paul B]

As already stated, the issue is due to a corrupt dump or restore.

Use SSH rather than cPanel.

 

[Jazem]

As already stated, the issue is due to a corrupt dump or restore.

Use SSH rather than cPanel.

I don't have SSH login nor do I have extensive experience with the command-line. It doesn't make sense; no matter how I export the dump it will always be corrupt?

 

[Jazem]

EDIT: I have SSH access (using hostgator) and am exporting using ssh. I will keep you all posted.

 

[Jazem]

I get this when importing the db I used when exporting through SSH.

 

[Jazem]

http://cepheus.co

My website works fine when on HostGator (as it is currently), however when I transfer the public_html files and mysql database to the new host then the I encounter that error.

 

[whynot]

I get this when importing the db I used when exporting through SSH.

Are you sure that you are exporting the database from Hostgator, using SSH?

 

[Jazem]

Are you sure that you are exporting the database from Hostgator, using SSH?

Yes I connect with Putty.

 

[Optic]

What version of mysql are you runnning on the new server?

On the command line type in: mysql -V

 

[whynot]

Yes I connect with Putty.

Years ago I wanted to have access to my database, I could not.
I could have access to the files only.

 

[Jazem]

Years ago I wanted to have access to my database, I could not.
I could have access to the files only.

I do not understand what you are saying here, it doesn't help me at all.

What can I do to solve this problem? Anyone?