Page 1 of 1

mysql str replace takes only effect after manual saving

Posted: Thu Apr 23, 2015 4:19 pm
by peggylon
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

Re: mysql str replace takes only effect after manual saving

Posted: Fri Apr 24, 2015 10:09 am
by garvinhicking
Hi!

I suppose you have the entryproperties plugin enabled, which offers caching, and saves that in serendipity_entryproperties. Either you do this string replacement there too, OR you disable caching, OR you rebuild the cache (should be an option in your entries menu in the backend, like "Recreate Cache of all entries").

HTH,
Garvin

[SOLVED] mysql str replace takes only effect after manual sa

Posted: Fri Apr 24, 2015 11:26 am
by peggylon
Hi Garvin!

You were right about
garvinhicking wrote:you have the entryproperties plugin enabled, which offers caching, and saves that in serendipity_entryproperties
I had not been sure about using the backend cache function. I thought it would freeze entries the way they were displayed on the blog. But since you suggested so, I tried and it worked perfectly. The changes are now visible in all recipe entries.

Thank you so much!
cheers