need SQL help

[guest*]

In one of the updates I did from 1.3.1.1. to 1.4.0.17 there where lost on link-rewriting the german characters. they where simply stripped.

How can I change in my DB the link-rewrite from

fuhrleine

TO

fuehrleine

with an SQL querie ?

The table which contains the link-rewrites is ps_product_lang and there the row link_rewrite, old word fuhrleine should be updated to fuehrleine.

Do somebody know the sql-query for this, I'm not an IT-profecient...

I think it should be something like: UPDATE `ps_product_lang` ... WHERE...

[Asenar]

UPDATE ps_product_lang 
SET link_rewrite = "fuehrleine"
WHERE url_rewrite = "fuhrleine"

But I think you also can use the administration interface in Prefereneces > Seo & Urls, choose the corresponding item and change it.


Tell us if that fix your problem

[guest*]

I will try it on BO. But it will have the effect as changing it manually directly in DB each one. There are more than 200 products only for this word ! I found others word with the same problem (stripping the german characters) and will do it by the same way as SQL-Query. It's faster.

[guest*]

I tried this, does not work:

UPDATE `ps_product_lang` SET `link_rewrite` = 'fuehrleine' WHERE `link_rewrite` = 'fuhrleine';

[guest*]

Could be the probem, that the word is not alone ? It could be composed like this: vorfuhrleine or fuhrleine-basic...

[Asenar]

I just tried the query and it worked, that mean no error returned.

If there is no modification, maybe it's not the exact expression in the "WHERE" clause. Maybe there is an extra space at the begin or the end, or maybe an invisible char where the correct character was.

[guest*]

For me it comes: no rows affected, or something else. He don't find the word in that row, that's why the word do not stay alone. It comes with characters before and after:

vorfuhrleine or fuhrleine-basic.

How mus I proceed in here ? There are several combinations with this word...

The link-rewrite was changed for other languages, and for german it is not good. It strips characters unknow. Perhaps this can be fixed in future by checking whicht iso-code is used in the shop.

[guest*]

Yes this is exactly what I assumed. It is not possible by a generall word. The change is only possible by adding also the res of link.

If you have fuhleine-basic als link so you can only update by fuehrleine-basic, if there are wolters-fuhrleine, only update possble by: wolters-fuehrleine.

So I will have a great job to correct this presta bug... 22.000 products ?! Not all have german characters, but the major part of them.