Page 1 of 1
product error on save
Posted: 08 Feb 2024, 18:24
by 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
Re: product error on save
Posted: 08 Feb 2024, 19:48
by 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
Re: product error on save
Posted: 11 Feb 2024, 22:15
by 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