gjr
commented Friday, 08 January 2016
Author
Hi Roland,
I tried to update the available fields for VM3, but seem to get stuck on a duplicate entry. The following error is shown:
Duplicate entry 'Maten-product-com_virtuemart' for key 'component_name_table' SQL=INSERT INTO `fhl18_csvi_availablefields` (`csvi_name`,`component_name`,`component_table`,`component`,`action`) VALUES ('Maten','Maten','product','com_virtuemart','import'),('Maten','Maten','product','com_virtuemart','export'),('Bewerkingen op de tong','Bewerkingen op de tong','product','com_virtuemart','import'),('Bewerkingen op de tong','Bewerkingen op de tong','product','com_virtuemart','export')
Should I empty the available fields table? Or isn't that going to solve the problem?
Hope to hear from you soon.
rolandd
commented Friday, 08 January 2016
Support
Hello Gert-Jan,
You will need to delete the csvi_availablefields table and recreate it manually using this SQL query:
CREATE TABLE IF NOT EXISTS `fhl18_csvi_availablefields` (
`csvi_availablefield_id` INT(11) NOT NULL AUTO_INCREMENT,
`csvi_name` VARCHAR(255) NOT NULL,
`component_name` VARCHAR(55) NOT NULL,
`component_table` VARCHAR(55) NOT NULL,
`component` VARCHAR(55) NOT NULL,
`action` VARCHAR(6) NOT NULL,
`isprimary` TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`csvi_availablefield_id`),
UNIQUE INDEX `component_name_table` (`component_name`, `component_table`, `component`, `action`)
) CHARSET=utf8 COMMENT='Available fields for CSVI'";
This will fix the index on the table. The only other way is to uninstall CSVI according to the Uninstall CSVI document and then install CSVI again. This will erase everything though.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.