Prestashop redirects to old domain after changing it in Database

Question

I am trying to create a copy of a prestashop 1.6 e-shop for development purposes from domain.com to dev.domain.com

The process I followed is

1. Disable cache and compilation
2. Copy the files from domain.com to dev.domain.com
3. Dump the mysql database from domain.com in dump.sql
4. Open dump.sql on vi and search and replace using :%s/domain.com/dev.domain.com/g
5. Import dump.sql in the devdb
6. Open prestashop cpanel and verify all shop url configuration is changed.
7. Open phpmyadmin and check that all domain.com entries have changed to dev.domain.com
8. Deleted files from /cache/smarty/compile /cache/cachefs
9. Rebuild .htaccess file from prestashop.
10. Changed login credentials in the devdb so that the website will load that one

Now the problem is that when I open dev.domain.com i still get redirected to domain.com and I'm at a loss as to what to try next.

Searching for domain.com in phpmyadmin in the devdb doesn't yield results grep -ri 'domain.com' * doesn't yield results either in the files

Any suggestions what I can try next?

PS: domain.com and dev.domain.com are two different domains. Not similar in anyway

Answer 1

For prestashop 1.7 you have to modify some values in the database:

• ps_configuration table and change PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL to your new domain name, e.g. mydomain.com
• ps_shop_url table and change again ‘domain’, ‘domain_ssl’ fields to your new domain name and ‘physical_uri’. If you copied files into root folder, the path will be simply ‘/’.

More on https://blog.premium-templates.eu/how-to-move-prestashop-from-localhost-to-domain-or-vice-versa

Note: browsers cache redirections, you will have to clean your browser cache. Check https://www.getfilecloud.com/blog/2015/03/tech-tip-how-to-do-hard-refresh-in-browsers/ to know how to do a "hard refresh" for your browser.