Change domain starting from a old domain backup

[alessio.b79]

Hi all and thanks for a support, i have a backup (FTP+SQL) of my store with the old domain, i have restore this backup in a new domain and i see this error message

Link to database cannot be established: SQLSTATE[HY000] [1045] Access denied for user 'xxxxxxxx'@'ip_address' (using password: YES)
at line 120 in file classes/db/DbPDO.php

i have change my database settings with those of my new domain in /app/config/paramaters.php and in database table ps_configuration fields PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL but i see again other error...

Thanks for the support

Alessio

[musicmaster]

/app/config/paramaters.php should be enough.

On 10/2/2022 at 3:02 PM, alessio.b79 said:

in database table ps_configuration fields PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL

This is wrong. Those changes should be made in the ps_shop_url table.  But having this not set will only redirect the page. It will not result in database errors. But of course it may be that you didn't watch the browsers address bar.

[alessio.b79]

Thanks musicmaster for the support.

Now Domain and Domain_ssl is correct, physical_uri also and I also changed PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL in the ps_configuration table but i see this error message:

/web/htdocs/www.mydomain.it/home/prestashop/vendor/composer/ClassLoader.php on line 444

my shop is in the folder www.mydomain.it/prestashop/, you know why this subfolder /home/ between my domain and my physical_uri ?

thank you very much, best regards

Edited October 5, 2022 by alessio.b79 (see edit history)

[musicmaster]

No problem. It is just how your hosting provider set up your account.

Quite likely you don't have access below /web/htdocs/www.mydomain.it/.

In that case other subdirectories than "home" can be used to store for example statistics and error reports.

[alessio.b79]

Correct, i don't have access below /web/htdocs/www.mydomain.it/ and /web/htdocs/www.mydomain.it/home/ is my Apache Document Root

the funny thing is i don't see in File Manager a /Home/ folder in www.mydomain.it

my html website in /web/htdocs/www.mydomain.it/ work fine, you think i need to make manually the /home/ folder and move all, html website /home/ and PrestaShop files in /home/PrestaShop ?

Let me try....

Thanks again for support and your time musicmaster

Edited October 5, 2022 by alessio.b79 (see edit history)

[alessio.b79]

ok no, /home/ folder tricks don't work, with url www.mydomain.it/Prestashop/ show me 404 Not found and with www.mydomain.it/home/prestashop same error

Warning: include(/web/htdocs/www.mydomain.it/home/home/prestashop/vendor/composer/../symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php): failed to open stream: No such file or directory in /web/htdocs/www.mydomain.it/home/home/prestashop/vendor/composer/ClassLoader.php on line 444

Fatal error: Class 'Symfony\Component\HttpKernel\Kernel' not found in /web/htdocs/www.mydomain.it/home/home/prestashop/app/AppKernel.php on line 33

any suggestions? .htaccess can help me? i don't have the .htaccess in my domain root folder

[musicmaster]

I have no idea what you are doing. The home directory is where you must be. So stick to that.

The function of all those other directories is a nice academic discussion for curious people. It is a hobby you can waste your time on once the shop is running.