how do i get back online after changing base url by mistake?

[irinarose]

Hi there,

I changed the "Base URI" by accident (Preferences > SEO & URLs) and now my shop has fallen apart and I am not able to change it back , and no access to back office 

Any advice?

Thanks
 

[Bill Dalton]

Through your host access your MySQL database, in table ps_configuration look for ID 231 PS_SHOP_DOMAIN you may change the domain name.

[vekia]

as far as i know back office should work, even with wrong "base uri" field.

 

what's going on when you're trying to connect to back office?

[irinarose]

When i try to log on back iffice it seems it cant find the server

 

when on mysql what should i look for and where??

 

i found this and changed value text to initial uri but doesn t work

 

 

Field Type Function Null Value

 

id_configuration int(10) unsigned

id_shop_group int(11) unsigned

id_shop int(11) unsigned

name varchar(32)

value text

date_add datetime  Calendar

date_upd datetime  Calendar

Edited April 18, 2014 by irinarose (see edit history)

[irinarose]

finally did this, it worked:

• Login to your cPanel.
   
• Scroll down to the database section and click on phpMyAdmin.
   
• When you have launched phpMyadmin, select the database by scrolling down the left side list. If you're not sure how to find your PrestaShop 1.5 database, go to 341: How to find your database name for PrestaShop 1.5. Once you have found your database, click on it to open.
   
• When the database is open, scroll down the left side until you see the table labeled "tableinitals_shop_url". Table initials usually default to "ps" but can be changed to something else during the installation process. Click on this table to select and open it. You will see the option to EDIT this table at left (as indicated in the screenshot at right).
   
• Click on EDIT and then change the URL entries. Make sure to change both the entries with the appropriate URL. If you aren't sure about the SSL or you are not using it, simply use the same one.
   
• Click on GO at the bottom of the page in order to save your entries.