Change products title length problem

14 Apr 2009, 2:24 AM

#1

New Zenner

Join Date:: Mar 2009
Location:: Shenzhen
Posts:: 10
Plugin Contributions:: 0

Change products title length problem

Hi all,it's my first post in zencart.com, i'm a guy from China, i' setting up my store to sell some goods, and i found it's the best place to talk about something about zencart with you all from all over the world, keep posting...

Hope it's the right place to post this :smile:

I just met a problem about my products title length, it's limited by 64 characters(including space) when showed in list or products page, but actually it's more than that length, where can i change the setting to apply with my actual products title?or will i have to alter the code somewhere?

Appreciate it!

schumi

14 Apr 2009, 3:02 AM

#2

haredo

Totally Zenned

Join Date:: Apr 2006
Location:: Texas
Posts:: 6,178
Plugin Contributions:: 0

Re: Change products title length problem

Sc,
www.your_web_site.com/cpanel

click on MySQL
click on your database name
click on products_descriptions
edit products_name
edit Length/Values
change from 64 to whatever you like
save

14 Apr 2009, 3:07 AM

#3

schumi

New Zenner

Join Date:: Mar 2009
Location:: Shenzhen
Posts:: 10
Plugin Contributions:: 0

Re: Change products title length problem

Haredo,

thanks your job, i will figure it out later.

14 Apr 2009, 4:36 AM

#4

ajeh

Oba-san

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

Re: Change products title length problem

NOTE: you will want to change all tables that utilize the products_name field:
products_description
orders_products

anywhere that the products_name is stored needs to have the same change made on the length ...

14 Apr 2009, 4:38 AM

#5

haredo

Totally Zenned

Join Date:: Apr 2006
Location:: Texas
Posts:: 6,178
Plugin Contributions:: 0

Re: Change products title length problem

Ajeh,
Dang I missed one in the database...

Thanks for the update, as always a keen eye:yes:

14 Apr 2009, 4:43 AM

#6

ajeh

Oba-san

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

Re: Change products title length problem

As always ... got the T-Shirt ... :cool:

6 May 2011, 11:09 PM

#7

lilkanini

New Zenner

Join Date:: Feb 2011
Posts:: 35
Plugin Contributions:: 0

Re: Change products title length problem

I know this is an old thread....I have changed the database using phpmyadmin as instructed to 100 VARCHAR but the length remains unchanged....what am I doing wrong??

6 May 2011, 11:21 PM

#8

lilkanini

New Zenner