Ver 6.1.8 causes issues with some product titles

[Frank Auffret]

I just upgraded my sites to ver 6.1.8 mainly to fix the product titles with double quotes bug e.g. 6" length
which was breaking the product image title code in the listing so no image was displayed.

<img src="image.jpg" title=" product="" title"="" >

The upgrade fixes the bug but causes another issue i.e. any product title previously added with double quotes breaks in the product admin page. 
e.g. 12" widget  
displays as 12 
Doesn't affect the store front listing

As I have hundreds of products across various sites like this I was wondering if anyone can think of a quick way to fix this issue otherwise I will have to manually re-enter every similar product.

Apostrophe character escaped in product names, emails bug

 

 

Edited August 16, 2017 by Frank Auffret

[keat]

I have something floating in the back of my mind from years ago, and I think i just did some sort of search and replace query on the database.

[Dirty Butter]

Here's the query pattern to use, but you can easily make a mess of your database if you do something wrong - SO MAKE A COPY OF THE APPROPRIATE DATABASE TABLE BEFORE ATTEMPTING. iF YOU'VE NEVER DONE SOMETHING LIKE THIS - YOU MIGHT WANT TO BACKUP THE WHOLE DATABASE BEFORE ATTEMPTING.

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");