hello there,
how do i increase the number of characters you can enter on the product name field when entering new products.
any help would be much appreciated.
thank you :)
hello there,
how do i increase the number of characters you can enter on the product name field when entering new products.
any help would be much appreciated.
thank you :)
The default limit is 64 characters, and is determined from your database structure.
If you want to make it longer, simply use phpMyAdmin to change the "products_name" field in the products_description table to a longer length.
Be sure to do a database backup first.
.
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.
I am trying to lengthen the product name to recieve a longer description on the packing slip and/or invoice. I went into my data base
and changed only the field length and I recieved the error listed below. Any ideas what I need to do different. Thank You
Error
SQL query:
ALTER TABLE `zen_products_description` CHANGE `products_name` `products_name` LONGTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL
MySQL said:
#1170 - BLOB/TEXT column 'products_name' used in key specification without a key length
Bookmarks