cat_name and category_nicename inconsistency

[Denis de Bernardy]

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

[shorty114]

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

[shorty114]

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