category name max length

First off, I just started using zen as an alternative to the quick cart that go daddy offers...I love the ability to customize nearly everything! Definitely something the other one didn't have.....

Anyway, the question I have has to with the category/products page. Unfortunately I have some categories that are longer than 32 characters. I looked everywhere, tried the toolkit and searched here without result. Where would I need to go to change that max variable? Many thanks.

Jason

you will have to manually edit that record field and change the "var" from 32 to 48 or another reasonable value....

Easier to shorten your cat/sub-cat names

In the db? Well that sucks. I would have thought for sure it was in one of the php files or something

Nope - All the category names are stored in the DB

Figured it out. Yes you do have to modify it in the db, but finding and changing it wasn't nearly as difficult as I thought it would be. woot!

Congratulations on figuring it out - please can you share it with the group so that we can all benefit.

best wishes

Can anyone give a quick step by step as to how to increase the category and subcategory length?

Thanks!

1. CPanel
2. PHPMyAdmin
3. Select database (for example, mine is named** zencart**)
4. Select categories_descriptions (look on the left side, select it by clicking on it)
5. On the right side of the screen after you click on categories_descriptions you will see this: categories_name varchar(32)
6. Put a check mark next to categories_name then click on the image of the pencil which means "change"
7. Change the Length/Values to 48 then click on Save.

I hope that helps you.

:clap:

I need to do this but wheres the CPanel? Is it somewhere in zencart admin??

I need a bit more guidance!

Many thanks

Sushigal:

I need to do this but wheres the CPanel? Is it somewhere in zencart admin??

I need a bit more guidance!

Many thanks

I'm interested to know how you manage your hosting account if you don't know what/where CPanel is...

(It may be that your host does not use CPanel, but another host admin interface).

CPanel (or your host's equivalent) has nothing to do with zencart. It is the admin interface you use to manage your hosting account on the host's server.

The more important thing here is phpMyadmin, so if you know how to get into that program (via your host), then you can ignore references to CPanel.

A word of warning... Novices should not play about in phpMyAdmin... a tiny error and your shop could evaporate :shocking:

I don't really follow! Sorry :blush:

All I know is that I use dreamweaver to edit zen files eg the stylesheet.css

and I use the zencart admin aswell.

As everything else was set up without me, and I'm quite knew to it all. I do remember our i.t bloke mentioning doing a database back up which I have performed before but when it comes to 'managing my hosting account' I don't know what the jargon means! I mean, I know I must probably be doing what you mention but I wouldn't know to call it that if you know what I mean! :smile:

Sushigal:

I don't really follow! Sorry :blush:

All I know is that I use dreamweaver to edit zen files eg the stylesheet.css

and I use the zencart admin aswell.

As everything else was set up without me, and I'm quite knew to it all. I do remember our i.t bloke mentioning doing a database back up which I have performed before but when it comes to 'managing my hosting account' I don't know what the jargon means! I mean, I know I must probably be doing what you mention but I wouldn't know to call it that if you know what I mean! :smile:

Suggest you talk to your "i.t.bloke" then...

Yes, have done and he gave me the login for my php which I was able to use, all very straight forward and thanks to this thread I could change the character count,

Thanks guys!