Invisible character limit in product names

Hi All,

I’ve just noted that when creating products from create products option, product name section only saves a length of 50 characters and the rest is simply vanishes. I found that the issues is caused because of the imposed database character limit and simply increasing that from the respective table and the field would fix the issue.

I think this field length should be same as the invoice item name field.

I can confirm. Hit a limit of 39 characters in Product Name field on version 1.4.6.

Note however when writing the product name (in the box titled “Title”) manually when creating an invoice or quote, the 50 character limit was not there. Writing “1234567890abcdefghijklmnopqrstuvwxyz1234567890abcdefghijklmnopqrstuvwxy” manually into the Title box showed up on the pdf no problem. Even stranger, when you go to edit the item, the title you entered previously for the item will be shortened to 39 characters in the Product Name input field.

Checked the files, the variable that stores the product name (“product_name”) in the database is given a limit of 50 characters.

See file: application/modules/setup/sql/006_1.2.0.sql
line 42: product_name VARCHAR(50) NOT NULL,

I guess unless there’s a hotfix, the only solution would be to change the column in the database yourself. I have no idea what’s causing the 39 character problem though.