Forums / Setting Up Categories, Products, Attributes / Category Fields - not long enough

Category Fields - not long enough

Locked

Views: 1,889

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
27 Dec 2006, 1:30 AM
#1
lionrhod avatar

lionrhod

New Zenner

Join Date:
Dec 2006
Posts:
19
Plugin Contributions:
0

Category Fields - not long enough

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?

27 Dec 2006, 2:08 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Category Fields - not long enough

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

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!

27 Dec 2006, 2:49 AM
#3
ajeh avatar

ajeh

Oba-san

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

Re: Category Fields - not long enough

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

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

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!

27 Dec 2006, 5:10 PM
#4
lionrhod avatar

lionrhod

New Zenner

Join Date:
Dec 2006
Posts:
19
Plugin Contributions:
0

Re: Category Fields - not long enough

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

27 Dec 2006, 7:02 PM
#5
lionrhod avatar

lionrhod

New Zenner

Join Date:
Dec 2006
Posts:
19
Plugin Contributions:
0

Re: Category Fields - not long enough

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

27 Dec 2006, 7:34 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Category Fields - not long enough

Ajeh:

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

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

27 Dec 2006, 10:09 PM
#7
lionrhod avatar

lionrhod

New Zenner

Join Date:
Dec 2006
Posts:
19
Plugin Contributions:
0

Re: Category Fields - not long enough

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

28 Dec 2006, 5:11 AM
#8
ajeh avatar

ajeh

Oba-san

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

Re: Category Fields - not long enough

DrByte:

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

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!

28 Dec 2006, 11:32 AM
#9
lionrhod avatar

lionrhod

New Zenner

Join Date:
Dec 2006
Posts:
19
Plugin Contributions:
0

Re: Category Fields - not long enough

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