Ticket #3729 (closed defect: duplicate)

Opened 2 years ago

Last modified 4 weeks ago

Table Structure: varchar(50) for category/term name is too short

Reported by: ice_ Assigned to: charleshooper
Priority: normal Milestone:
Component: Administration Version: 2.1
Severity: normal Keywords: mysql categories has-patch commit
Cc: jhodgdon, mastermind

Description

Please change this to varchar(200), like wp_categories.category_nicename. I need more than 50 chars for my category name, cause i use the polyglot plugin and categories are used like this: [lang_de]Neue Kategorie[ /lang_de][lang_en]New Category [ /lang_en]

That is the name of my category and because of this, why not change to varchar(200), like category_nicename? I changed it manually, but mb some other users dont know how to do this...

Attachments

wp_schema_big_catname.diff (0.9 kB) - added by charleshooper on 01/31/07 22:52:15.
Sets wp_categories.cat_name to varchar(200) and bumps db version
schema-php.diff (0.6 kB) - added by jhodgdon on 06/22/07 21:23:26.
Patch compatible with 2.3 bleeding

Change History

01/31/07 17:36:49 changed by foolswisdom

  • milestone changed from 2.1.1 to 2.2.

01/31/07 22:52:15 changed by charleshooper

  • attachment wp_schema_big_catname.diff added.

Sets wp_categories.cat_name to varchar(200) and bumps db version

01/31/07 22:53:27 changed by charleshooper

  • keywords changed from mysql,categories to mysql categories has-patch.
  • owner changed from anonymous to charleshooper.
  • status changed from new to assigned.

Patch added.

03/28/07 00:00:26 changed by foolswisdom

  • milestone changed from 2.2 to 2.3.

(follow-up: ↓ 5 ) 04/12/07 21:42:38 changed by jhodgdon

Oh no! I just added the above patch to the wrong bug report... how do I remove it? Sorry!!!!

(in reply to: ↑ 4 ) 04/12/07 21:44:02 changed by foolswisdom

Replying to jhodgdon:

Oh no! I just added the above patch to the wrong bug report... how do I remove it? Sorry!!!!

NP, deleted.

06/22/07 21:23:26 changed by jhodgdon

  • attachment schema-php.diff added.

Patch compatible with 2.3 bleeding

06/22/07 21:27:55 changed by jhodgdon

  • summary changed from MySQL Structur: varchar(50) for cat_name in table wp_categories is too short to Table Structure: varchar(50) for category/term name is too short.

I have been hoping for a while that this would get patched... I know we who use multilingual blogs are in the minority, but it would sure be handy.

In any case, I have created a new patch for scheme.php, which makes the term name have field length 200, which is compatible with trunk [5744] (i.e. 2.3 bleeding). I didn't bump the DB version in the patch.

If you are not planning to ever patch this, maybe you could just close the bug as "won't fix", so I could give up hope. Thanks!

06/22/07 21:28:04 changed by jhodgdon

  • cc set to jhodgdon.

09/24/07 07:07:10 changed by f00f

I'd also like to see it changed. What is the reason for the restriction to 50 chars anyway?

03/26/08 15:13:40 changed by mastermind

  • cc changed from jhodgdon to jhodgdon, mastermind.

A little update, meanwhile this bug refers to wp_terms.name.

WP 2.5 is soon to come, and this annoying bug is still unresolved, even though it should be rather easy to fix. :/

08/05/08 20:27:44 changed by Otto42

  • keywords changed from mysql categories has-patch to mysql categories has-patch commit.

Anybody planning on committing this anytime soon?

08/05/08 20:36:24 changed by ryan

  • status changed from assigned to closed.
  • resolution set to duplicate.
  • milestone deleted.

Duplicate of #7465