This is a typical issue when someone chooses to try to increase the length of this field and others that are tracked through the order process and other related processes.
(eg: in Zen Cart v1.5.6 both tables are set to 64 characters by default)
It should be possible to resolve the issue through the following SQL statement that can be applied through tools->Install SQL Patches
Code:
ALTER orders_products MODIFY products_name VARCHAR(128);
It is recommended to make a backup of the database before executing commands that modify the database structure.
Bookmarks