On Oct 18, 2004, at 9:54 PM, Brion Vibber wrote:
Sort keys for categories used to include the 'Category' namespace,
they don't anymore. Edit all affected pages to update the links table
for each, or run a query like this to do them all at once:
Do you mean to just do some kind of edit/save on the category pages, or
the articles that go in them? I just tried both and neither seemed to
have any effect. I did empty the browser cache...
SET cl_sortkey=SUBSTRING(cl_sortkey,10) WHERE cl_sortkey LIKE
I'll try this after I get a good backup of the database, just in case.
I've never run a query on it before. :-)
Also, I would strongly advise you to upgrade to 1.3.7
as soon as
possible, as a number of potential security problems have been fixed.
Will do -- thanks!