Need short help on MySQL

[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

[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