Friendly URL's name problem

[essential]

Hi

 

I have problem with friendly url's at prestashop 1.4.4.1

 

All my products from one category havefriendly URL from first product

 

(it's polish language but u will see what i mean)

http://shop.400ml.pl/5-montana-black

 

all 'colours' has friendly url like

 

.../XX-blk1010-easter-yellow.html

 

where XX is a product id. How can i change it ? I wish all products have friendly url name like the product name is.

[essential]

IF anyone else has similar problem i changed in SQL

 

UPDATE ps_product_lang as t SET t.link_rewrite = ( SELECT replace( lcase( (
SELECT p.`name`
FROM (
SELECT *
FROM `ps_product_lang`
) AS p
WHERE p.`id_product` =t.id_product
AND p.`id_lang` =6 ) ) , ' ', '-' )
)
WHERE t.id_lang =6

 

where id_lang=6 is my language (polish) in prestashop.

[johannesw]

Tried your query because I have the same problem, but for me it messed up lots of links and pictures wont show up and links wont work to some products, not all but some, do you know what the problem can be?