So here is the symptom. You just ran a restore from a dump of a Magento database and you are running the setup wizard and point the database to the restored DB. You got an 404 error or with Firefox you received the following message “Firefox has detected that the server is redirecting the request for this address in a way that will never complete.”.

Here are the solution that solves my problem:

  1. Open up your DB SQL dump
  2. On the line after the “use” database statement (if exist), add the following text: “SET sql_mode=’NO_AUTO_VALUE_ON_ZERO’;”
  3. Rerun the setup

That’s it. The setup should run with no problem now.