Page 1 of 1

Need short help on MySQL

Posted: Thu Aug 18, 2005 2:59 am
by Thomas
Hi,

today, while checking my template with the validator I recognized that I had an invalid tag entered in some entries.

So updated them quickly:

Code: Select all

update serendipity_entries set body= replace(`body`,'<B>','<b>');
Fine so far for the database entries, they're updated. But: why the hell I do not see the correct entry in the browser? I reloaded the page a couple times, but the result stays the same, the '<B>' tag is still there.

Why?

Regards, Thomas

Re: Need short help on MySQL

Posted: Thu Aug 18, 2005 11:36 am
by garvinhicking
It seems you're using the extended properties plugin with caching enabled. Then you must make the same replacement on the entryproperties table:

Code: Select all

update serendipity_entryproperites set value = replace(value, '<B>', '<b>') WHERE property LIKE ('ep_cache_%');
(untested, but should hopefully work)

Regards,
Garvin