Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2015
    Location
    california
    Posts
    3
    Plugin Contributions
    0

    Default 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...

    Name:  example0001.PNG
Views: 208
Size:  17.8 KB

    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.

  2. #2
    Join Date
    Jan 2015
    Location
    california
    Posts
    3
    Plugin Contributions
    0

    Default Re: increasing number of characters in category name

    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....

  3. #3
    Join Date
    Jul 2012
    Posts
    16,816
    Plugin Contributions
    17

    Default Re: increasing number of characters in category name

    Quote Originally Posted by hyeboy99 View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: increasing number of characters in category name

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: increasing number of characters in category name

    NOTE: also do not include the quote marks and end the line with a semi-colon ...<br>
    Code:
    <br>ALTER TABLE `categories_description` CHANGE `categories_name` `categories_name` VARCHAR( 64 ) NOT NULL;<br>
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  6. #6
    Join Date
    Jul 2012
    Posts
    16,816
    Plugin Contributions
    17

    Default Re: increasing number of characters in category name

    Quote Originally Posted by Ajeh View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: increasing number of characters in category name

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  8. #8
    Join Date
    Jan 2015
    Location
    california
    Posts
    3
    Plugin Contributions
    0

    Default Re: increasing number of characters in category name

    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.

 

 

Similar Threads

  1. v139h increasing Product Category Name character limitation?
    By kevinmc3 in forum General Questions
    Replies: 3
    Last Post: 19 Nov 2012, 10:20 PM
  2. Category Name (2) - Removing the number?
    By Digitex in forum Basic Configuration
    Replies: 4
    Last Post: 13 Jul 2006, 10:01 PM
  3. More Characters In Category Name
    By thegrafixguy in forum General Questions
    Replies: 4
    Last Post: 5 Nov 2004, 02:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg