[SOLVED] PS folder references in the DB

[GuyB]

I'm new to Prestashop and so far I've found the forum excellent for all sort of tips and tricks.

 

But I'm stuck with something I can't resolve!

 

I have a site www.chh-design.com that I've changed from /prestashop/ to / (root), I did this in the settings settings.inc.php fle and the the PS Admin via preferences/SEO & URLS and mostly it works fine but all the links all have the /prestashop/ folder still showing.

 

I've got round it by a redirect in .htaccess but from the DB Backup I can see 'prestashop' still in the db.

 

How do I solve this - I don't have much experience with DBs and so I don't want to change all the references in the .sql file and import it - but maybe that is the answer.

 

Thanks in advance

[bellini13]

can you be more specific about the links that still contain /prestashop in them? perhaps you have a custom module that needs to be revised?

[GuyB]

Yes, here's some detail from the sql file produced by the db backup using a normal text editor.

 

('15','1','Photo Gallery',NULL,NULL,'<p><a href=\"http://chh-design.com/prestashop/product.php?id_product=36\"><img src=\"http://chh-design.com/gallery/1.jpg\"

 

and

('100','PS_BASE_URI','/prestashop/','2010-09-05 16:58:15','2011-08-05 14:40:08'),

and

<a href=\"http://chh-design.com/prestashop/product.php?id_product=52\"> from ps_product_lang

 

It seem to me that as the site is working that Prestashop is not reading either the PS_BASE_URI from the setting file or the / from the SEO & URLS when I set that.

 

maybe I'm wrong though.

 

I very much appreciate your help. Guy

 

It has lots of these url /prestashop/ references for thing like links in the footer and the

[bellini13]

could you also specify what database tables those entries are located in? you should only have to scroll up a little bit in the export file to see a "create table" line

[Mike Kranzler]

Hi Guy,

Are all of your PrestaShop files uploaded directly to the root of your site via FTP, or are they within a /prestashop folder that is placed in the root?

 

-Mike

[GuyB]

all the prestashop files and folders are in root there is no prestashop folder as that was what I moved from.

 

Ok here are the tables and a record from each table showing the /prestashop/ bit

 

in ps_cms_lang:

('7','1','Website Terms of Use',NULL,NULL,'<p><span style=\"font-size: 14pt;\"><span style=\"color: #3366ff;\">Terms and Conditions</span></span></p>\r\n<p> </p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\">Welcome to our website. If you continue to browse and use this website, you are agreeing to comply with and be bound by the following terms and conditions of use, which together with our <a href=\"http://chh-design.com/prestashop/cms.php?id_cms=8\"><span style=\"color: #ff00ff;\"><strong>privacy policy</strong></span></a> and <a href=\"http://chh-design.com/prestashop/cms.php?id_cms=10\"><strong><span style=\"color: #ff00ff;\">copyright notice</span></strong></a> govern CHH Design Limited’s relationship with you in relation to this website. If you disagree with any part of these terms and conditions, please do not use our website.<br />The term ‘CHH Design Limited’ or ‘us’ or ‘we’ refers to the owner of the website whose registered office is North Aldworth House, Aldworth, RG8 9TS. Our company is registered in England and Wales under number 7299747. The term ‘you’ refers to the user or viewer of our website.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\">The use of this website is subject to the following terms of use:</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> The content of the pages of this website is for your general information and use only. It is subject to change without notice.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific requirements.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> All trademarks reproduced in this website, which are not the property of, or licensed to the operator, are acknowledged on the website.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> Unauthorised use of this website may give rise to a claim for damages and/or be a criminal offence.</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> From time to time, this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s).</span></span></span></p>\r\n<p><span style=\"font-size: 10pt;\"><span style=\"color: #ff00ff;\"><span style=\"font-size: 12pt;\"><br /> Your use of this website and any dispute arising out of such use of the website is subject to the law of England and Wales.</span></span></span></p>','website-terms-of-use'),

 

In ps_configuration:

('100','PS_BASE_URI','/prestashop/','2010-09-05 16:58:15','2011-08-05 14:40:08'),

 

And there are quite a few in the product table but they are due to link being put in the product description text I believe, which I would like to be able to change too!

[Mike Kranzler]

Hi Guy,

Please make sure you have changed the necessary information in all the locations listed in our guide for moving PrestaShop here, and let me know if that works for you.

 

-Mike

[GuyB]

Hi Mike,

 

Thanks for your help.

 

I've just found a lot of the references to /prestashop/ which was an included .txt file for the l/h menu and I've done a find and replace and all of the issues on the l/h menu have gone, which is great.

 

I've inherited this site from another developer and he/she has obviously not used a module for the l/h menu but built a .txt file which is all hardcoded.

 

So the question for me is what module should I use for a vertical or horzontal menu which I can put categories and 'About Us' etc in?

 

Thanks also for your very prompt replies.

Guy

[Mike Kranzler]

Hi Guy,

Per the rules of the PrestaShop forums, please post each individual issue or question as a separate thread. I will go ahead and mark this thread as solved for you. Happy selling!

 

-Mike