increasing number of characters in category name

Hello All... I've been a Zen Cart user for three days now... (formerly OSC). Building a new site and have a question that I cannot find the answer to... I'm sure its easy so forgive the newbie...

Currently, the Category Name (or sub cat name) field allows for 32 characters...

I would like to increase this to 46. I cannot find anywhere where one may input the desired number of characters such as on the Confuration/max values or Configuration/layout etc. I also cannot seem to find where it would allow for this in the css files.

Any help would be great..

thanks in advance.

After posting this, there were three related posts that appeared at the bottom of my (this) new one. Apparently the only way to increase the number of characters from 32 to xx is to do it from the database level. One post supplied a SQL code

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

My next question (as if I only had two), is what to do with this code... do I go into the admin via the tools/install sql patches.... and place code in the query box...

thanks again in advance....

hyeboy99:

After posting this, there were three related posts that appeared at the bottom of my (this) new one. Apparently the only way to increase the number of characters from 32 to xx is to do it from the database level. One post supplied a SQL code

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

My next question (as if I only had two), is what to do with this code... do I go into the admin via the tools/install sql patches.... and place code in the query box...

thanks again in advance....

Yes, but also need to do a similar action for one of the orders tables.. I don't recall which, but the table will capture what is part of the product information. Using the install sql patch will eliminate concerns of the DB_PREFIX.

mc12345678 is partially correct ...

While the change to the orders_products table is needed when changing the products_description table size, it is not needed when changing the categories_description size ...

NOTE: also do not include the quote marks and end the line with a semi-colon ...<br>```
<br>ALTER TABLE categories_description CHANGE categories_name categories_name VARCHAR( 64 ) NOT NULL;<br>

Ajeh:

mc12345678 is partially correct ...

While the change to the orders_products table is needed when changing the products_description table size, it is not needed when changing the categories_description size ...

Absolutely...

I focused on what was being changed and overlooked where it was being changed.. I shouldn't have to say this, but listen to ajeh...

Sorry for those reading this in the future for muttling the thread with an unnecessary action. There is no capturing of the categories description in the purchase/order process.

Still a help to folks learning new things ... as someone making changes to categories_description table and gets the urge to do similarly to products_description will now have the reminder that products_description changes for the products_name needs to be done on the orders_products table as well ... :cool:

Thanks everyone.... that work! So now it's just a matter of adding product... LOL.. I did notice that when I duplicate a product, it duplicates the photos as well... then when I changed them, it changed the 'host' item's images too... figured all that out and now I'm on a roll.

Nothing like knowing nothing then jumping right in with both feet... this programming stuff (the real understanding of it) is way beyond my attention span... LOL

thanks again.