Mrthdrb

What can we do to stop prior company from asking us questions?

Tiptoe or tiphoof? Adjusting words to better fit fantasy races

Did Dumbledore lie to Harry about how long he had James Potter's invisibility cloak when he was examining it? If so, why?

How do I find the solutions of the following equation?

Is HostGator storing my password in plaintext?

Failed to fetch jessie backports repository

How to be diplomatic in refusing to write code that breaches the privacy of our users

Pole-zeros of a real-valued causal FIR system

Proof of work - lottery approach

Roman Numeral Treatment of Suspensions

Why does indent disappear in lists?

How do I go from 300 unfinished/half written blog posts, to published posts?

Return the Closest Prime Number

Two monoidal structures and copowering

Is exact Kanji stroke length important?

How did Arya survive the stabbing?

How does buying out courses with grant money work?

What is the best translation for "slot" in the context of multiplayer video games?

Would this custom Sorcerer variant that can only learn any verbal-component-only spell be unbalanced?

Do the temporary hit points from the Battlerager barbarian's Reckless Abandon stack if I make multiple attacks on my turn?

How can a function with a hole (removable discontinuity) equal a function with no hole?

Is the destination of a commercial flight important for the pilot?

System.debug(JSON.Serialize(o)) Not longer shows full string

Was Spock the First Vulcan in Starfleet?

Magento 2: Same ID already exists

Magento Observer already exists errorUpgrade to 1.9.2.2 - Base table or view already exists: 1050 Table 'mage_permission_variable' already existsError when logging into user SQL Item with the same name already existsTrying to create configurable product, error product id already existsURL key for specified store already exists in Magento 2.1.1cron has started throwing and exception 'Mage_Core_Exception' with message 'Mage registry key “_singleton/admin/session” already exists'Magento 2: URL for key for specified store already exists in categoriesMagento 2 unknown error on exception.logMagento 2.2.1 Error(Item (MagentoSalesRuleModelRule) with the same ID “33” already exists)Error on system log

3

I'm having this error when entering one certain category in frontend:

Exception #0 (Exception): Item (MagentoReviewModelReviewSummary) with the same ID "519" already exists.

Any ideas what that could be about?

category error exception

share|improve this question

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  When you enter a category you have already set the category ID in the code
  
  – St3phan
  Aug 14 '17 at 13:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  After removing that product with that ID the problem is gone so there was something wrong with that product.
  
  – Webninja
  Aug 14 '17 at 15:21
  

  
  
  
  

add a comment | 

3

I'm having this error when entering one certain category in frontend:

Exception #0 (Exception): Item (MagentoReviewModelReviewSummary) with the same ID "519" already exists.

Any ideas what that could be about?

category error exception

share|improve this question

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  When you enter a category you have already set the category ID in the code
  
  – St3phan
  Aug 14 '17 at 13:13
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  After removing that product with that ID the problem is gone so there was something wrong with that product.
  
  – Webninja
  Aug 14 '17 at 15:21
  

  
  
  
  

add a comment | 

I'm having this error when entering one certain category in frontend:

Exception #0 (Exception): Item (MagentoReviewModelReviewSummary) with the same ID "519" already exists.

Any ideas what that could be about?

category error exception

share|improve this question

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

share|improve this question

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

share|improve this question

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

asked Aug 14 '17 at 12:56

WebninjaWebninja

5861930

2 Answers
2

active

oldest

votes

4

We have just had the same issue and it's due to the review_entity_summary table having duplicate records for that product id.
if you select * from review_entity_summary where entity_pk_value='519'; it will return two rows for the same store_id, if you delete one of the rows it resolves the issue.

share|improve this answer

edited Mar 15 '18 at 16:06

sv3n

9,89562455

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Have you had it just once or is the problem coming up now and then? What's the cause?
  
  – Jānis Elmeris
  Jul 25 '18 at 15:09
  

  
  
  
  

add a comment | 

0

After looking on internet for days i can't find exact solution of this.
Then i found if we change the URLKEY of the category it will not show this error so i have done this.

$category->setPath($parentCategory->getPath())
 ->setParentId($parentId)
 ->setName('test1')
 ->setIsActive(true)
 ->setUrlKey(rand(1,1000000000));

 $category->save();

I use random function to add category in database with random no using ->setUrlKey(rand(1,1000000000)); you can add any thing in this like duplicate category name with some random no etc.
and errors gone if it helps you give an UP. thanks

share|improve this answer

answered yesterday

Asad UllahAsad Ullah

7211

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f189075%2fmagento-2-same-id-already-exists%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

4

We have just had the same issue and it's due to the review_entity_summary table having duplicate records for that product id.
if you select * from review_entity_summary where entity_pk_value='519'; it will return two rows for the same store_id, if you delete one of the rows it resolves the issue.

share|improve this answer

edited Mar 15 '18 at 16:06

sv3n

9,89562455

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Have you had it just once or is the problem coming up now and then? What's the cause?
  
  – Jānis Elmeris
  Jul 25 '18 at 15:09
  

  
  
  
  

add a comment | 

4

We have just had the same issue and it's due to the review_entity_summary table having duplicate records for that product id.
if you select * from review_entity_summary where entity_pk_value='519'; it will return two rows for the same store_id, if you delete one of the rows it resolves the issue.

share|improve this answer

edited Mar 15 '18 at 16:06

sv3n

9,89562455

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Have you had it just once or is the problem coming up now and then? What's the cause?
  
  – Jānis Elmeris
  Jul 25 '18 at 15:09
  

  
  
  
  

add a comment | 

We have just had the same issue and it's due to the review_entity_summary table having duplicate records for that product id.
if you select * from review_entity_summary where entity_pk_value='519'; it will return two rows for the same store_id, if you delete one of the rows it resolves the issue.

share|improve this answer

edited Mar 15 '18 at 16:06

sv3n

9,89562455

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

share|improve this answer

edited Mar 15 '18 at 16:06

sv3n

9,89562455

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

edited Mar 15 '18 at 16:06

sv3n

9,89562455

edited Mar 15 '18 at 16:06

sv3n

9,89562455

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

answered Mar 15 '18 at 15:40

BevMitchellBevMitchell

412

0

After looking on internet for days i can't find exact solution of this.
Then i found if we change the URLKEY of the category it will not show this error so i have done this.

$category->setPath($parentCategory->getPath())
 ->setParentId($parentId)
 ->setName('test1')
 ->setIsActive(true)
 ->setUrlKey(rand(1,1000000000));

 $category->save();

I use random function to add category in database with random no using ->setUrlKey(rand(1,1000000000)); you can add any thing in this like duplicate category name with some random no etc.
and errors gone if it helps you give an UP. thanks

share|improve this answer

answered yesterday

Asad UllahAsad Ullah

7211

add a comment | 

0

After looking on internet for days i can't find exact solution of this.
Then i found if we change the URLKEY of the category it will not show this error so i have done this.

$category->setPath($parentCategory->getPath())
 ->setParentId($parentId)
 ->setName('test1')
 ->setIsActive(true)
 ->setUrlKey(rand(1,1000000000));

 $category->save();

I use random function to add category in database with random no using ->setUrlKey(rand(1,1000000000)); you can add any thing in this like duplicate category name with some random no etc.
and errors gone if it helps you give an UP. thanks

share|improve this answer

answered yesterday

Asad UllahAsad Ullah

7211

add a comment | 

After looking on internet for days i can't find exact solution of this.
Then i found if we change the URLKEY of the category it will not show this error so i have done this.

$category->setPath($parentCategory->getPath())
 ->setParentId($parentId)
 ->setName('test1')
 ->setIsActive(true)
 ->setUrlKey(rand(1,1000000000));

 $category->save();

I use random function to add category in database with random no using ->setUrlKey(rand(1,1000000000)); you can add any thing in this like duplicate category name with some random no etc.
and errors gone if it helps you give an UP. thanks

share|improve this answer

answered yesterday

Asad UllahAsad Ullah

7211

$category->setPath($parentCategory->getPath())
 ->setParentId($parentId)
 ->setName('test1')
 ->setIsActive(true)
 ->setUrlKey(rand(1,1000000000));

 $category->save();

share|improve this answer

answered yesterday

Asad UllahAsad Ullah

7211

answered yesterday

Asad UllahAsad Ullah

7211

answered yesterday

Asad UllahAsad Ullah

7211