Davallen Posted February 19, 2013 Share Posted February 19, 2013 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 Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 19, 2013 Share Posted February 19, 2013 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) Link to comment Share on other sites More sharing options...
PascalVG Posted February 20, 2013 Share Posted February 20, 2013 (edited) 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) Link to comment Share on other sites More sharing options...
gonebdg - webindoshop.com Posted February 20, 2013 Share Posted February 20, 2013 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_ Link to comment Share on other sites More sharing options...
Davallen Posted February 20, 2013 Author Share Posted February 20, 2013 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 Link to comment Share on other sites More sharing options...
vekia Posted February 20, 2013 Share Posted February 20, 2013 thanks for sharing the solution i marked this topic as solved for other forum members regards Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 20, 2013 Share Posted February 20, 2013 (edited) 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) 1 Link to comment Share on other sites More sharing options...
vekia Posted February 20, 2013 Share Posted February 20, 2013 you've got right elpatron, totally agree with you 1 Link to comment Share on other sites More sharing options...
PascalVG Posted February 20, 2013 Share Posted February 20, 2013 (edited) 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) 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now