When I browse the category_node table in phpmyadmin, it displays the following alert:

PRIMARY and INDEX keys should not both be set for column `cid`

Just wanted to flag this in case it is important.

CommentFileSizeAuthor
#1 category.install-nonsensical-pk.patch919 bytesbdragon

Comments

bdragon’s picture

Status: Active » Needs review
StatusFileSize
new919 bytes

Yeah, good point. The primary key is never used on that table. Not sure if it's worth an update, but dropping it won't hurt anything.

bdragon’s picture

Priority: Normal » Minor
Jaza’s picture

The indexes for category_node are the same as for the term_node table in the core taxonomy module. If this is a category bug, then it is also a core bug, and the core bug should be fixed first.

Please file a bug against core - category will not be updated until core is fixed.

bdragon’s picture

Status: Needs review » Closed (won't fix)

I'm going to wontfix this.