Jump to content

System Error Log


vidmarc
 Share

Recommended Posts

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'

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...