Category Fields - not long enough

[lionrhod]

Just got zencart installed and am working on setup. I'm putting in my categories, and the field is too short by about 5 characters or so. Can't get in the full category info. Is there a way to customize this, so it will take a few more keystrokes?

[Ajeh]

We don't have 5 character category info ... umm ... where do you think you are when you see these limited 5 character displays?

[Ajeh]

Okay ... so I cannot read right all of the time ...

You can expand the sizes of the fields in the database tables themselves ...

Just be careful that any time you change a field that you check for other places a field may also be used such as on orders ...'

In this case, the categories_name is just in the categories table so you have just the one place to change its size ... it is set to varchar(32) so go to something logical such as varchar 48 ... logical meaning a coder would look at it and think nothing of the value of the size because it makes geek sense ...

[lionrhod]

Thank you. Umm any idea how I get into the database and do that?

[lionrhod]

I figured out how to get to my phpmyadmin, but category name doesn't seem to show in the table

[DrByte]

the categories_name is just in the categories table

We'll have to dig up another pot of coffee for Ajeh ... I'm sure she meant to say categories_description table

[lionrhod]

Thanks much! That helped me find it and fixed the problem.

[Ajeh]

We'll have to dig up another pot of coffee for Ajeh ... I'm sure she meant to say categories_description table

Go get technical on me ... *I* know what I meant ... but that keyboard took over ... and ... and ... yeah ... the keyboard took over that was it ...

[lionrhod]

hehehe :) either way you got me started to the answer and thanks.