Accidentally changed domain name so cant access cms

[hechbone]

Hello,

I hope some one can offer some assistance, in attempting to place a redirect on my prestashop hosted website i have accidentally saved the domain name as "/" so now my website url is "https://www.domainname.com/https://www.domainname.com/...".

I know how to change this back however I am now unable to login to my pretashop CMS because of the change in my websites url. The log in page is not even pulling through any css anymore!

Please help!

[endriu107]

You need to login to your database and change it in PREFIX_shop_url table.

[hechbone]

15 hours ago, endriu107 said:

You need to login to your database and change it in PREFIX_shop_url table.

Thanks for your reply, Yeh i understand how to fix the problem once im in the admin/database but the problem is i cant get into the admin area because of the error.  The Login page is now carrying any styling on js as the src it duplicating the url. For example -

<link rel="stylesheet" href="/https:/www.hechbone.com/adm643/themes/default/css/admin-theme.css" type="text/css" media="all">

you can see the href starts with "/" which means it duplicates the url to "https:/www.hechbone.com/https:/www.hechbone.com".

[JBW]

The advice from @endriu107 is correct. You need to change this directly in the database, not in the backend. Usually your hosting provider gives you database access by tools such as phpMyAdmin. Login there and follow the instruction from endriu107

In case you don't have phpMyAdmin you can put following tool on your server by FTP with similar functionality

https://www.adminer.org/en/

Edited June 22, 2022 by JBW (see edit history)