I finally took a few minutes and completed the category support for my weblog. Everything was there except for the part that actually added the categories when I created or updated an entry.
Oh, son of the monster... MySQL's REPLACE command isn't smart enough to use a multi-column primary key to figure out whether to replace or insert. This has got to be a bug.
Oh duh, it is a bug, but it's my bug. Glad to know. I had an extra UNIQUE index that shouldn't have been there, in retrospect. That's what MySQL was keying off of for the REPLACE. There we go, now it works right. Silly me.
Thursday, August 1, 2002
Permalink
Feel free to post a comment below. Please see my comment policy.
Formatting Rules (No HTML):