TheCoffeeLocator

Please anyone? I could do with help on this one!

A user has deleted one of or categories plus 8 subcategories. We or may not have a backup, but need to know which tables are effected in the database. Can anyone advise? On inspection, the following have lost records: ps_category ps_category_lang But is I would like to know where else we will have to recreate the database (a simple backup may not be good enough as we would lose too many records. Thanks

301 is better for link juice, and reportedly preferred for search engines. There is more about the problems we had with htaccess redirect here - http://www.prestashop.com/forums/topic/203972-remove-en-from-url-when-multi-language-enstalled/page__st__20__p__1149703#entry1149703

I am not so sure it is that simple - have you REALLY implemented this, and in which version of Prestashop? certainly it is not so simple in 1.4* Also, 302 redirect is not best practice.

It is a shame that prestashop does not have an option to do this built into the back end when a user adds a language: Post #5 - rewrite the .htaccess file. Any line that refers to "agile" you will not need - this is an addon module that we used to create a marketplace. You will have to change the links as well to suit your store. Post #8 - to remove the /en/ from english language. Be careful as any errors in htaccess ccan cause your site to show stop working. make sure you backup the files on server before making these changes.

We stil have the language issues: Some pages users cannot change language Some pages do not have multilanguage (due to modules we installed not having language settings) Though we have no tlooked into the issue for a while now. when we get the solution we will post here as it is valuable

Hi, I have been looking for an answer on this (I know in PS1.3) that there is a chron job solution. Does anyone know a quicker way to active auto currency convertion so that the currency is updated at least daily? Thanks

Thanks Paul, Id noticed the module bazaar, but was hoping prestashop had developed something!

Hi, Can anyone advice if prestashop has a dropshipping module? I have had a good look around for this without finding a definite answer Many thanks

@darktangent the solution works to an extent. But I also have the issue of not being able to switch back languages (in ps 1.4).

hi @Damonsk, so oyu have any ideas as to where this is not working? Much appreciated

Sure. I double check everything, and the following all give 404s: login area, registration, new-products.php, search results, and many multistore features (this site is also a multishop where anyone can create a shop and sell). <IfModule mod_rewrite.c> # URL rewriting module activation RewriteEngine on # URL rewriting rules RewriteRule ^([a-z0-9]+)\-([a-z0-9]+)(\-[_a-zA-Z0-9-]*)/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1-$2$3.jpg [L] RewriteRule ^([0-9]+)\-([0-9]+)/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1-$2.jpg [L] RewriteRule ^([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$1$2.jpg [L] RewriteRule ^([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$1$2$3.jpg [L] RewriteRule ^([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$3/$1$2$3$4.jpg [L] RewriteRule ^([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$3/$4/$1$2$3$4$5.jpg [L] RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$3/$4/$5/$1$2$3$4$5$6.jpg [L] RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$3/$4/$5/$6/$1$2$3$4$5$6$7.jpg [L] RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$3/$4/$5/$6/$7/$1$2$3$4$5$6$7$8.jpg [L] RewriteRule ^([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])([0-9])(\-[_a-zA-Z0-9-]*)?/[_a-zA-Z0-9-]*\.jpg$ /market/img/p/$1/$2/$3/$4/$5/$6/$7/$8/$1$2$3$4$5$6$7$8$9.jpg [L] RewriteRule ^c/([0-9]+)(\-[_a-zA-Z0-9-]*)/[_a-zA-Z0-9-]*\.jpg$ /market/img/c/$1$2.jpg [L] RewriteRule ^c/([a-zA-Z-]+)/[a-zA-Z0-9-]+\.jpg$ /market/img/c/$1.jpg [L] RewriteRule ^c/([0-9]+)/[a-zA-Z0-9-]+\.jpg$ /market/img/c/$1.jpg [L] RewriteRule ^([0-9]+)(\-[_a-zA-Z0-9-]*)/[_a-zA-Z0-9-]*\.jpg$ /market/img/c/$1$2.jpg [L] RewriteRule ^([0-9]+)\-[a-zA-Z0-9-]*\.html /market/product.php?id_product=$1&isolang=en [QSA,L] RewriteRule ^[a-zA-Z0-9-]*/([0-9]+)\-[a-zA-Z0-9-]*\.html /market/product.php?id_product=$1&isolang=en [QSA,L] RewriteRule ^([0-9]+)\-[a-zA-Z0-9-]*(/[a-zA-Z0-9-]*)+ /market/category.php?id_category=$1&isolang=en&noredirect=1 [QSA,L] RewriteRule ^([0-9]+)\-[a-zA-Z0-9-]* /market/category.php?id_category=$1&isolang=en [QSA,L] RewriteRule ^([0-9]+)__([a-zA-Z0-9-]*) /market/supplier.php?id_supplier=$1&isolang=en [QSA,L] RewriteRule ^([0-9]+)_([a-zA-Z0-9-]*) /market/manufacturer.php?id_manufacturer=$1&isolang=en [QSA,L] RewriteRule ^content/([0-9]+)\-([a-zA-Z0-9-]*) /market/cms.php?id_cms=$1&isolang=en [QSA,L] RewriteRule ^content/category/([0-9]+)\-([a-zA-Z0-9-]*) /market/cms.php?id_cms_category=$1&isolang=en [QSA,L] RewriteRule ^([a-z]{2})/vendor/name-start-with-([a-zA-Z]*) /market/modules/agilesellerproducts/agilesellers.php?filter=$2 [QSA,L] RewriteRule ^([a-z]{2})/vendor/([0-9]+)\-([a-zA-Z0-9-]*) /market/modules/agilesellerproducts/agileseller.php?id_seller=$2&seller_name=$3 [QSA,L] RewriteRule ^([a-z]{2})/countries/([0-9]+)\-([a-zA-Z0-9-]*) /market/modules/agilesellerproducts/sellercountry.php?id_seller_country=$2 [QSA,L] RewriteRule ^vendor/name-start-with-([a-zA-Z]*) /market/modules/agilesellerproducts/agilesellers.php?filter=$1 [QSA,L] RewriteRule ^vendor/([0-9]+)\-([a-zA-Z0-9-]*) /market/modules/agilesellerproducts/agileseller.php?id_seller=$1&seller_name=$2 [QSA,L] RewriteRule ^countries/([0-9]+)\-([a-zA-Z0-9-]*) /market/modules/agilesellerproducts/sellercountry.php?id_seller_country=$1 [QSA,L] RewriteRule ^([a-z]{2})/seller /market//modules/agilemultipleseller/myselleraccount.php [QSA,L] RewriteRule ^seller /market//modules/agilemultipleseller/myselleraccount.php [QSA,L] RewriteRule ^page-not-found$ /market/404.php [QSA,L] RewriteRule ^address$ /market/address.php [QSA,L] RewriteRule ^addresses$ /market/addresses.php [QSA,L] RewriteRule ^authentication$ /market/authentication.php [QSA,L] RewriteRule ^best-sales$ /market/best-sales.php [QSA,L] RewriteRule ^cart$ /market/cart.php [QSA,L] RewriteRule ^contact-us$ /market/contact-form.php [QSA,L] RewriteRule ^discount$ /market/discount.php [QSA,L] RewriteRule ^guest-tracking$ /market/guest-tracking.php [QSA,L] RewriteRule ^order-history$ /market/history.php [QSA,L] RewriteRule ^identity$ /market/identity.php [QSA,L] RewriteRule ^manufacturers$ /market/manufacturer.php [QSA,L] RewriteRule ^my-account$ /market/my-account.php [QSA,L] RewriteRule ^new-products$ /market/new-products.php [QSA,L] RewriteRule ^order$ /market/order.php [QSA,L] RewriteRule ^order-follow$ /market/order-follow.php [QSA,L] RewriteRule ^quick-order$ /market/order-opc.php [QSA,L] RewriteRule ^order-slip$ /market/order-slip.php [QSA,L] RewriteRule ^password-recovery$ /market/password.php [QSA,L] RewriteRule ^prices-drop$ /market/prices-drop.php [QSA,L] RewriteRule ^search$ /market/search.php [QSA,L] RewriteRule ^sitemap$ /market/sitemap.php [QSA,L] RewriteRule ^stores$ /market/stores.php [QSA,L] RewriteRule ^supplier$ /market/supplier.php [QSA,L] RewriteRule ^en/(.*)$ /$1 [L,R=301] RewriteRule ^market/en(.*)$ /market$1 [L,R=301] </IfModule> # Catch 404 errors ErrorDocument 404 /market/404.php

Thanks again for the help. It half worked. Some links such as new products stopped working (404 error), and any search result came back with a 404 error. Any ideas?

Doh still the same problem. So I rewrote all urls as in example below: $tab['RewriteRule']['content']['^([0-9]+)\-[a-zA-Z0-9-]*'] = 'category.php?id_category=$2&isolang=en [QSA,L]'; i.e. removing the part ([a-z]{2})/ and adding en instead of $1

Actually this has not even changed the htaccess file! By far the easiest way seems to be a rewrite as I tried originally, but this is not working either.