product error on save

[vlada83]

Hi, by saving some products i get error

1062 Duplicate entry '127-1' for key 'i_parameter_id'
1062 Duplicate entry '130-3' for key 'i_parameter_id'

not sure why because it occurs only by certain products, not all

[Benno]

Hi,
Which Phoca Cart Component version do you use?
Which Joomla! Version do you use?
Which PHP version do you use?
Is it a fresh Phoca Cart Component install or a updated version?
If updated from which version updated?
Do you you receive a more detailed error message if you enable Joomla! Debug Mode and Error Message=Maximum

Kind regards,
Benno

[Jan]

Hi, try to open e.g. phpMyAdmin and try to add this SQL query:

Code: Select all

ALTER TABLE `#__phocacart_parameter_values_related` DROP INDEX `i_parameter_id`, ADD UNIQUE `i_parameter_id` (`item_id`, `parameter_value_id`, `parameter_id`);

change #__ to your database prefix, then it should be OK