System Error Log

[vidmarc]

I've just checked my new installion and I'm seeing a lot of system errors. Any suggestions?

Quote

22 May 2018, 16:47    File: [products.import.inc.php] Line: [221] "INSERT INTO `CubeCart_seo_urls` (`path`,`item_id`,`type`) VALUES ('','78','prod');" - Duplicate entry '' for key 'PRIMARY'
    22 May 2018, 16:47    File: [products.import.inc.php] Line: [221] "INSERT INTO `CubeCart_seo_urls` (`path`,`item_id`,`type`) VALUES ('','79','prod');" - Duplicate entry '' for key 'PRIMARY'
    22 May 2018, 16:47    File: [products.import.inc.php] Line: [221] "INSERT INTO `CubeCart_seo_urls` (`path`,`item_id`,`type`) VALUES ('','80','prod');" - Duplicate entry '' for key 'PRIMARY'
    22 May 2018, 16:47    File: [products.import.inc.php] Line: [221] "INSERT INTO `CubeCart_seo_urls` (`path`,`item_id`,`type`) VALUES ('','81','prod');" - Duplicate entry '' for key 'PRIMARY'
    22 May 2018, 16:47    File: [products.import.inc.php] Line: [221] "INSERT INTO `CubeCart_seo_urls` (`path`,`item_id`,`type`) VALUES ('','82','prod');" - Duplicate entry '' for key 'PRIMARY'
    22 May 2018, 16:47    File: [products.import.inc.php] Line: [221] "INSERT INTO `CubeCart_seo_urls` (`path`,`item_id`,`type`) VALUES ('','83','prod');" - Duplicate entry '' for key 'PRIMARY'

 

[Noodleman]

Happen all the time.. ignore it. The DB indexes prevent duplicates. 

[bsmither]

There seems to have been a misunderstanding about the import data.

(`path`,`item_id`,`type`) VALUES ('','78','prod')

The value for 'path' is missing. The 'path' column is required to be unique (being PRIMARY). So, attempting to INSERT/UPDATE a record where some other record already has an empty string as its value will fail to be INSERTed/UPDATEd.

Either add a path in your CSV, or perhaps CubeCart's importer is failing to automatically create a path if it is missing.