Jump to content
Davallen

[Solved] Can't Find Ps_Shop_Domain And Ps_Shop_Domain_Ssl

Recommended Posts

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

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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 by PascalVG (see edit history)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

thanks for sharing the solution

i marked this topic as solved for other forum members

 

regards

Share this post


Link to post
Share on other sites

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 by elpatron (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

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 by PascalVG (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More