Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: kumpleto on November 13, 2012, 10:27:37 AM

Title: Upgrade Won't Migrate All Categories
Post by: kumpleto on November 13, 2012, 10:27:37 AM
I'm trying to migrate my tables from V1.1.3 to V2.0.12f, however, it won't move all the categories and subcategories and returning me this error during migration:

vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '4-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '4','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )
vmError: TableCategory_categories::store failed - Duplicate entry '1-0' for key 'i_category_parent_id' SQL=INSERT INTO `jos_virtuemart_category_categories` ( `category_parent_id`,`category_child_id`,`ordering` ) VALUES ( '1','0','0' )


Got no idea about this error and it's really giving me a pain in the ass with this issue.  Followed the position posted in here but to no avail.


Badly needed help! tnx
Title: Re: Upgrade Won't Migrate All Categories
Post by: chetanmadaan on November 22, 2012, 21:28:58 PM
Do a fresh instal.. could be because the category with that ID already exist.
Text only | Text with Images