Category Characters

28 Jul 2011, 8:36 PM

#1

nick1973

Totally Zenned

Join Date:: Sep 2008
Location:: Cleethorpes
Posts:: 1,230
Plugin Contributions:: 3

Category Characters

Hi I'm aware this has ben asked a few times before but none of the answers I found seemed to work globally.

I need my category names to be slightly longer by about 10 characters, so how do I do this in the database and what do I need to change?

28 Jul 2011, 8:49 PM

#2

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,643
Plugin Contributions:: 0

Re: Category Characters

http://www.zen-cart.com/forum/showthread.php?t=8592

28 Jul 2011, 8:58 PM

#3

nick1973

Totally Zenned

Join Date:: Sep 2008
Location:: Cleethorpes
Posts:: 1,230
Plugin Contributions:: 3

Re: Category Characters

Don't know why but its not linking to the thread you sent?

28 Jul 2011, 9:46 PM

#4

nick1973

Totally Zenned

Join Date:: Sep 2008
Location:: Cleethorpes
Posts:: 1,230
Plugin Contributions:: 3

Re: Category Characters

Can anybody help me with this as Kims post link didn't work.

29 Jul 2011, 12:18 AM

#5

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Category Characters

That link takes me right to the post on how to change the categories_name from 32 to 64 characters:

ALTER TABLE categories_description CHANGE categories_name categories_name VARCHAR( 64 ) NOT NULL;

29 Jul 2011, 9:04 AM

#6

Kim

Obaa-san

Join Date:: Jun 2003
Location:: West Coast, North America
Posts:: 26,643
Plugin Contributions:: 0

Re: Category Characters

Sorry, the thread I posted was in a closed section of the archives.

Note: I found the thread by scrolling to the bottom of the page and checking the Similar Topics.

29 Jul 2011, 10:32 AM

#7

nick1973

Totally Zenned

Join Date:: Sep 2008
Location:: Cleethorpes
Posts:: 1,230
Plugin Contributions:: 3

Re: Category Characters

Thanks Guys, I just couldn't get to it.

29 Jul 2011, 10:33 AM

#8

nick1973

Totally Zenned

Join Date:: Sep 2008
Location:: Cleethorpes
Posts:: 1,230
Plugin Contributions:: 3

Re: Category Characters

Linda do I paste that directly into PHPMYADMIN?

29 Jul 2011, 1:22 PM

#9

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Category Characters

Providing you do not have any database table prefixes ...

If your tables use prefixes, then you will need to add them ...