[Solved] Can't Find Ps_Shop_Domain And Ps_Shop_Domain_Ssl

[Davallen]

Hi guys,

 

I've looked for how to change url on my prestashop and all the guides says I have to locate the ps_configuration and look for PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL and change the url. The thing is that PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL does not exist in my database! Any idea where I can find this?

 

I have attached a dump of my database

[El Patron]

it's easier to just change it from your back office...

 

you didn't mention your ps version, always a good idea...

 

depending on your ps version, simply find seo and url's

 

and change the url's...(this assuming it's not a 1.5 with multishop)

[PascalVG]

If you really need to change it in the database:

 

Open phpMyAdmin, and go to pc_configuration

 

Standard it shows only the first (30?? I thought) records in your database, but at the top you can see that there are many more (3hundred something, I believe).

 

To get to your needed records:

 

Change your filter to: (close to the top of the screen are some fill in fields to do this)

show records from record [0], show [400] records,

 

Then use your "find on this page" in the browser to locate the record

 

Hope this helps.

Pascal

Edited February 20, 2013 by PascalVG (see edit history)

[gonebdg - webindoshop.com]

Since PS v.1.5.x.x it stored in DB table PREFIX_shop_url NOT in PREFIX_configuration

 

PREFIX_ = your prestashop prefix database, default : ps_

[Davallen]

Hi everyone,

 

Sorry i forgot the version. PascalVG gave me the correct answer. It simply showed the first 30 rows, I've found it now. Thanks for your help

[vekia]

thanks for sharing the solution

i marked this topic as solved for other forum members

 

regards

[El Patron]

this SHOULD be modified using the back office NOT by modifying the database

 

 

and we should all be very careful about giving out hacks when there is a back office management tool that does the job...

 

I mean if they have to ask how to modify something in the database..should they actually be doing that? just saying

 

ave maria pues

Edited February 20, 2013 by elpatron (see edit history)

[vekia]

you've got right elpatron, totally agree with you

[PascalVG]

When moving shop to another site, once a while some hacking is needed, though, to get into the back office in the first place...

 

(But I fully agree, if possible, take the "front door" :-) )

Edited February 20, 2013 by PascalVG (see edit history)