Expanding the product name field

[stevesh]

Exactly. That's because that field is set to 64 characters in the database. bobdog's advice will fix the problem.

[enginarat]

Exactly. That's because that field is set to 64 characters in the database. bobdog's advice will fix the problem.

It won't work for me, either. There's no "length" option at where you directed us above. Please see attached screenshot. Thanks.

[stevesh]

It's the type - varchar64. Edit that field and change it to varchar128, say.

[scientific_anomaly]

I just had to do the same thing - and fixed it so it is working now. There is a hilarious logical loop following the advice above in practice. If you actually drop the products_description table and try and upload a new one with your lengthy product names, the new sql upload defines the number of characters here:

`products_name` varchar(64) NOT NULL default '',

and undoes your previous efforts and puts the name length back to 64.

If you are going to drop and reload that table anyway, then this is the only place it needs changing - for example:

`products_name` varchar(72) NOT NULL default '',

(for a max of 72 characters in the product name)