Categories
View Replies (1)

Resolved Error on updating VM3 Available Fields

  1. gjr
    gjr
  2. RO CSVI
  3. Friday, 08 January 2016
  4.  Subscribe via email
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.
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!