When you create edit or delete an existing Product Extra Field

Description

I think this is an SQL error.

When you create a Product Extra Field (using textarea not single line)- and use it on a product.

Deleting the Product Extra Field
you get:

Extra Product Fields
Delete Extra Product Field

Label: English Used By: 0 products

Are you sure you want to delete this field?
(but it is in use!!! and at this point displays)

If you edit the Product Extra Field and try to save... Anything ... you get a warning....

Data will be lost if you reduce the field length to this size! Currently 2 product descriptions contain values that are longer than this size! To avoid data loss this field would need to be at least 6 characters long. If you really want to reduce the size of this field and cause data to be truncated then click the Save button to confirm the change.

And IF you continue - it deleted all the product info for all your products for that field. Even if you edit the product and add back that data - WILL NOT be saved (but show properly in the preview).

Tried upgrading to latest version of contribution - Still has the same error/issue.

Environment

None

Steps to reproduce

1. Create a NEW Product Extra Field using textarea (not single line).
2. Create or Edit an existing product. Fill in the Product Extra Fields values.
3. Verify that displays fine on catalog etc.
4. Edit the Product Extra Field and change ANY value (OR EVEN NOTHING!) and click Save
5. Warning will display - Data will be lost if you reduce the field length to this size! Currently XX product descriptions contain values that are longer than this size! To avoid data loss this field would need to be at least XXX characters long. If you really want to reduce the size of this field and cause data to be truncated then click the Save button to confirm the change.
6. View or Edit the original product - fields are blank. Try to fill them in and preview - displays fine.... click save.
7. Again View/edit - fields are blank!

Status

Assignee

Michael Sasek

Reporter

Jason

Labels

None

Severity

Major

Components

Fix versions

Affects versions

v2.6

Priority

Configure