How can I change the field length for product description?

[1speedbump]

I thought it would be in the Admin Configuration area, but If it is, I can't identify it.

[stevesh]

Admin - Configuration - Product Listing - Display Product Description

The default is 150 characters.

[1speedbump]

I"m sorry, I meant Product Name. Under Product Name it has a value of "2". I know that isn't what I'm looking for as I already have over 60 characters. I just need one more space.

[stevesh]

You'll have to change that in the database, using phpMyAdmin. It's in the products_description table and is currently set to 64 characters. That field may appear in other tables too, including orders_products

[1speedbump]

That figures, that's when it goes over my head. I'm no programmer and don't feel comfortable messing with that sort of thing. I guess I had better find different ways of wording my Product Names.

Thanks.

[Ajeh]

Be aware, if you change the size of the products_name in the table products_description, you also need to change the size of the products_name in the table orders_products ...

[1speedbump]

Don't worry Linda, I won't be changing anything. I am somewhat comfortable messing with HTML, but anything else is just not worth the big mess I could make of things. I'll just re word things to shrink them.

[Ajeh]

Or, someone could be really nice and tell you to go to your Zen Cart Admin to the Tools ... Install SQL Patches ... and run this in there:

ALTER TABLE products_description CHANGE products_name products_name VARCHAR(96) NOT NULL DEFAULT '';
ALTER TABLE orders_products CHANGE products_name products_name VARCHAR(96) NOT NULL DEFAULT '';

and it will change the two database tables to have products_name with a field length of 96 ...

[1speedbump]

You mean someone really nice like you? You have always been nice to me and very helpful. But before I dive into the abyss, do I just insert that code into the SQL Query Executor and click send?

[Ajeh]

Just go to the Tools ... Install SQL Patches ... and in the large input box (SQL Query Executor) paste that in and click the SEND button ...