MG 1.1 How to search and replace comments (encoding problem)

We migrated from PhotoPost to Media Gallery. The settings of the PhotoPost had been erroneous for some time period, or there was some bug, I don't know for sure. The result was wrong character encoding in some of the gallery comments. Now they are successfully converted to Media Gallery, but some comments are still tangled.

An example: tuolle jutulle löytyy mielestäni rasvanippa, onkohan kytkinakseli kyseessä. Ainakin tutun näköistä töhnää akselilla näyttäs olevan.

That should read: tuolle jutulle löytyy mielestäni rasvanippa, onkohan kytkinakseli kyseessä. Ainakin tutun näköistä töhnää akselilla näyttäs olevan.

I wonder if there is any tool like Kier's post replace tool, which could be used to fix this.
 
Unfortunately there's no such tool, though it would theoretically be simple to adapt the post one to handle Gallery comments too. You would either need to have experience with PHP yourself or find someone to do it for you, though.

Aside from that you will either need to do it manually, or directly in the database (not recommended), do the import again or leave it as it is.
 
Top Bottom