Forums / Setting Up Categories, Products, Attributes / products name not long enough

products name not long enough

Locked

Views: 1,973

Results 1 to 9 of 9
This thread is locked. New replies are disabled.
24 Feb 2007, 9:29 PM
#1
ericpeng avatar

ericpeng

Zen Follower

Join Date:
Jan 2006
Posts:
115
Plugin Contributions:
0

products name not long enough

we need more than 64 characters for product name.
Can I just change the Length/Valuse from 64 to 80?
table : products_description field : products_name

any side effect that I need to know ???

Thank you
Eric

26 Feb 2007, 4:54 PM
#2
lib99 avatar

lib99

Totally Zenned

Join Date:
Dec 2004
Location:
New York, USA
Posts:
965
Plugin Contributions:
0

Re: products name not long enough

You can change the data table field size. You could end up with sidebox issues. One thing that worked for us was the following. (German translations of our products can get very long! But we limit to less characters to force shorter names.

.sideBoxContent {

		overflow:hidden;

		width:170px;

	}

What this does is limit the amount of text in the sidebox to 170px. Anything more (characters) beyond the specified width doesn't display. Works with Firefox and IE6/7 browsers.

Ironically, there is a post from another member discuss the same issue a little. http://www.zen-cart.com/forum/showthread.php?t=59180

27 Feb 2007, 7:49 AM
#3
ericpeng avatar

ericpeng

Zen Follower

Join Date:
Jan 2006
Posts:
115
Plugin Contributions:
0

Re: products name not long enough

[QUOTE=lib99;335227]You can change the data table field size. You could end up with sidebox issues. One thing that worked for us was the following. (German translations of our products can get very long! But we limit to less characters to force shorter names.

Thank you so much.
Eric

1 Mar 2007, 3:28 AM
#4
ericpeng avatar

ericpeng

Zen Follower

Join Date:
Jan 2006
Posts:
115
Plugin Contributions:
0

Re: products name not long enough

I changed the field size to 95, everything just fine.
side box and tell a friend both work well.

Maybe the problem is fixed in V1.3.7 ??

1 Mar 2007, 3:57 AM
#5
ajeh avatar

ajeh

Oba-san

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

Re: products name not long enough

Be sure that you also changed the products_name in all related tables ...

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!

1 Mar 2007, 6:33 AM
#6
ericpeng avatar

ericpeng

Zen Follower

Join Date:
Jan 2006
Posts:
115
Plugin Contributions:
0

Re: products name not long enough

Ajeh:

Be sure that you also changed the products_name in all related tables ...

Sorry, i don't get it. Would you give me more information?

Thanks

1 Mar 2007, 6:54 AM
#7
ericpeng avatar

ericpeng

Zen Follower

Join Date:
Jan 2006
Posts:
115
Plugin Contributions:
0

Re: products name not long enough

ericpeng:

Sorry, i don't get it. Would you give me more information?

Thanks

Ok, I search over and I found products_name in the following 3 tables

products_description, customers_wishlist, orders_products

should I change all of them to the same size ?

Thanks

2 Mar 2007, 4:29 AM
#8
ajeh avatar

ajeh

Oba-san

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

Re: products name not long enough

Yes or they would get cut off when they are added to the tables ... :smile:

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!

2 Mar 2007, 6:51 AM
#9
ericpeng avatar

ericpeng

Zen Follower

Join Date:
Jan 2006
Posts:
115
Plugin Contributions:
0

Re: products name not long enough

Ajeh:

Yes or they would get cut off when they are added to the tables ... :smile:

got it. Thanks