Support

Site Restoration

#28036 HTTP Status: 500 (Internal Server Error)

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by on Friday, 28 July 2017 17:17 CDT

webatelier47
Hello,

I have create a worpress website localy with mamp, when i am on stop restoration database i have this error

HTTP Request Error
HTTP Status: 500 (Internal Server Error)
Internal status: error
XHR ReadyState: 4
Raw server response:

Thanks.

nicholas
Akeeba Staff
Manager
Your host is blocking the restoration of the database from going on but they do not tell you why. According to our 11+ years of experience the most common causes -and their solutions- are:

  1. Wrong database connection type. Try switching between MySQL (PDO), MySQL and MySQLi (note the trailing i!).
  2. Your host has a web server security solution (e.g. mod_security2) with rules which get tripped when you use special characters in your database password. Try a database password consisting of only lowercase and uppercase English letters (a-z, A-Z) and numbers (0-9).
  3. Your host enforces a maximum number of database commands (queries) over a set period of time, e.g. 1000 queries per minute. Since you are restoring your entire site's database we need to perform a large number of queries in a short amount of time. You can try setting the Maximum execution time to 1 and the Throttle time to 4000 (these settings are in the lower right corner in the database restoration page - the page in your screenshot) to make the restoration run 5 times slower.
  4. Your host enforces a maximum number of requests over a set period of time (e.g. with mod_evasive). Again, the solution is the same as with the previous issue: you need to modify the maximum execution and throttle time to make the restoration run much slower.


It is possible that the limits set on the server are so low that even these solutions do not work. If you still can't restore the site you will need to contact the host and show them this reply of mine. Ask them to check their server logs to see why their server is halting the restoration and tell you. If it's a server limit ask them to temporarily raise or lift it so that you can restore the site. If they won't do that find a better host; unrealistically strict usage limits that the host won't lift even temporarily are typically the sign of a crowded server which leads to poor site performance and a negative impact in your search rankings and user engagement.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!