WordPress.org

Make WordPress Core

Opened 10 years ago

Closed 9 years ago

#1225 closed defect (bug) (wontfix)

cat_name and category_nicename inconsistency

Reported by: Denis de Bernardy Owned by:
Milestone: Priority: normal
Severity: trivial Version:
Component: General Keywords:
Focuses: Cc:

Description

in the DB, you have:

cat_name is a varchar(55) and has a unique key
category_nicemame is a varchar(200) and is indexed

it should be:

cat_name is a varchar(200) and has is indexed
category_nicemame is a varchar(200) and is indexed

ex:

/psychology/social-psychology/
/sociology/social-psychology/

or:

cat_name is a varchar(200) and has a unique key
category_nicemame is a varchar(200) and has a unique key

the previous makes a cat2cat table mandatory however, and the resulting algorithms are orders of magnitude more complex, so I would recommend against it if you are unconfortable with graphs

Change History (3)

comment:1 @Denis de Bernardy10 years ago

  • Patch set to No

comment:2 @shorty1149 years ago

I believe it's that way for legacy. And it works.

comment:3 @shorty1149 years ago

  • Resolution set to wontfix
  • Status changed from new to closed

It works, this is 2 years old... WONTFIX. Patch welcome, but it would probably pretty complicated due to legacy issues.

Note: See TracTickets for help on using tickets.