Hello,
We finally decided to upgrade our CsCart from 2.1.0 to 2.1.4.
The whole process completed without any problems.
But we have a very important problem with the urls of our products/categories etc
Our urls used to be like these:
Category www.e-professionalphoto.gr/studio/softbox.html
Product www.e-professionalphoto.gr/nikon-mh-63-for-en-el10.html
We didn’t change anything and the SEO addon is still active but now our links have the following format:
Category: [url]http://www.e-professionalphoto.gr/category-322/[/url]
Product: [url]http://www.e-professionalphoto.gr/product-29876.html[/url]
SEO Addon Settings:
Product/page SEF URL format:product_name.html
Categories SEF URL format: [parent_item_name/]item_name/[page2/]
We tried to give seo name to a category e.g kialia(one that we used to use) and it transformed to kialia-gr
What should we do in order to have the same urls, we used to have back to 2.1.0
We exported the details of products from DB
Product code,Product URL,SEO name,Page title
“000290”,“http://www.e-professionalphoto.gr/product-31353.html",“nikon-d90-kit-af-s-dx-nikkor-18-105mm-ed-vr-and-nikon-af-s-70-300mm-vr-6”,"Nikon D90 Kit AF-S DX Nikkor 18-105mm ED VR & NIKON AF-S 70-300mm VR - 6 Άτοκες Δόσεις”
“000279”,"http://www.e-professionalphoto.gr/product-31354.html",“nikon-d90-kit-af-s-dx-nikkor-18-200mm-vr-new-and-nikon-case-6”,"Nikon D90 Kit AF-S DX Nikkor 18-200mm VR (NEW) & Nikon Case - 6 Άτοκες Δόσεις "
Seo names for products exist but the seo addon does not use them to create the urls…
Any ideas?
What does the data in your cscart_seo_names table look like? If it’s good, you might try uninstalling/installing the SEO addon.
If the data in the table matches what you’re seeing then something has overwritten your seo_names table. You can check the schema and if they are the same, you could simply replace the new with the old (assuming you have backups).
We checked the cscart_seo_names table where the names are as the used to be back to 2.1.0 version.
We discovered that besides the old ones like:
“external-hard-disks”;“370”;“c”;;“EL”
“flash-units-canon”;“308”;“c”;;“EL”
“flash-units-nikon”;“309”;“c”;;“EL”
“flash-units-olympus”;“310”;“c”;;“EL”
“flash-units-metz”;“311”;“c”;;“EL”
“flash-units-expoimaging”;“559”;“c”;;“EL”
“flash-units-brilliant”;“560”;“c”;;“EL”
“flash-units-pentax”;“561”;“c”;;“EL”
“flash-units-sigma”;“562”;“c”;;“EL”
“flash-units-nissin”;“563”;“c”;;“EL”
“flash-units-sony”;“564”;“c”;;“EL”
This table containts some new names which uses now, like the above:
“product-31289”;“31289”;“p”;;“GR”
“product-31290”;“31290”;“p”;;“GR”
“product-31291”;“31291”;“p”;;“GR”
“product-31292”;“31292”;“p”;;“GR”
“product-31293”;“31293”;“p”;;“GR”
“product-31294”;“31294”;“p”;;“GR”
“product-31295”;“31295”;“p”;;“GR”
“product-31296”;“31296”;“p”;;“GR”
“product-31297”;“31297”;“p”;;“GR”
“product-31298”;“31298”;“p”;;“GR”
“product-31299”;“31299”;“p”;;“GR”
“product-31300”;“31300”;“p”;;“GR”
“product-31301”;“31301”;“p”;;“GR”
“product-31302”;“31302”;“p”;;“GR”
“product-31303”;“31303”;“p”;;“GR”
“product-31305”;“31305”;“p”;;“GR”
The greek language which we are using has EL code, i can not understand why the table has some with code GR and why Seo Addon uses them.
I believe that we found the problem but we do not know how to solve it.
Anyone? 
[quote name=‘tbirnseth’]What does the data in your cscart_seo_names table look like? If it’s good, you might try uninstalling/installing the SEO addon.
If the data in the table matches what you’re seeing then something has overwritten your seo_names table. You can check the schema and if they are the same, you could simply replace the new with the old (assuming you have backups).[/QUOTE]
Well we just solved it…
What we did, we activated english language as the main language of our eshop.
We regenerated our sitemp and cleaned our cache.
Then we just deactivated english language and now our eshop has the sef urls that used to have back to 2.1.0 version…
That is just crazy guys…