mysql str replace takes only effect after manual saving
Posted: Thu Apr 23, 2015 4:19 pm
Hello,
a couple days ago I switched to a new template. For better looks I then added some additional HTML to a recipe scheme I used to use. Manually this worked (and looked) just fine. In order to adapt these changes to previos entries I did string replace that portion in body.
UPDATE multikuli_entries SET body = replace(body, 'stringtobereplaced', 'newstring');
No problems so far. But the changes didn't become visible. When opening an entry in backend and saving it, then the desired effect too place. Cache was cleared several times.
Is there a way to somehow simulate manual saving? I'd rather not want to open and save each single entry containing the recipe scheme...
I'm still on s9y 1.7.. Do you think updating to 2.0 could solve the problem?
Thanks for your time
a couple days ago I switched to a new template. For better looks I then added some additional HTML to a recipe scheme I used to use. Manually this worked (and looked) just fine. In order to adapt these changes to previos entries I did string replace that portion in body.
UPDATE multikuli_entries SET body = replace(body, 'stringtobereplaced', 'newstring');
No problems so far. But the changes didn't become visible. When opening an entry in backend and saving it, then the desired effect too place. Cache was cleared several times.
Is there a way to somehow simulate manual saving? I'd rather not want to open and save each single entry containing the recipe scheme...
I'm still on s9y 1.7.. Do you think updating to 2.0 could solve the problem?
Thanks for your time