Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 7.x > Portal Engine > Duplicate Customer error on registration check step?

View modes:

Member

matt-awg - 1/22/2014 4:06:05 PM

Duplicate Customer error on registration check step?

I have a simple cart that is based off the demo ecommerce site. I have not customized anything. If I put stuff in my cart and go to Step 2 of 6 - Registration check and then select the guest/anonymous checkout option and enter the email address of an existing customer - when I hit next I get an error page with this message:
Cannot insert duplicate key row in object 'dbo.COM_Customer' with unique index 'IX_COM_Customer_CustomerEmail'

Is this a bug? At the very least, shouldn't a more friendly error appear within the cart instead of a fatal unhandled exception error page? I would think at least it would switch them to the login option and suggest they login since their email is already on file? Is there some configuration setting or something I am missing?

Thanks!


Kentico Customer Success	kentico_martind2 - 1/24/2014 6:16:03 PM RE:Duplicate Customer error on registration check step? Hello Matt, I wasn't able to reproduce this issue running Kentico 7.70, so I would recommend you to apply the latest hotfix. Best Regards, Martin Danko


Member	matt-awg - 1/24/2014 9:28:43 PM RE:Duplicate Customer error on registration check step? Thanks Martin for the suggestion but I tried upgrading to 7.72 just now and still I get the same problem. Any ideas? Just let me know if you need any more information.

Kentico Consulting

Kentico_RichardS - 1/26/2014 4:13:54 AM

RE:Duplicate Customer error on registration check step?

Hi,

Thank you for your message.

I had a chance to independently test it myself of a fresh Kentico instance.
I will write you the steps I did so you can eventually guide me ->

1) Install E-commerce template
2) Create a customer with testing e-mail
3) Log out and put some item to shopping cart
4) Choose anonymious customer and fill it the first name, last name and e-mail I crated in step 2.
5) After hitting next no error has been shown -> I can also see that a new customer has been created in the E-commerce -> Customers section. I can also see that both customers have same e-mail. Can this issue be somehow related to your db? Can you check the CMS_Customer table and see if there are any constrains of e-mail column?

Kind regards,
Richard Sustek


Member	matt-awg - 1/27/2014 10:39:26 AM RE:Duplicate Customer error on registration check step? Thanks Richard... This is a multi-site Kentico installation and I think what happened is I changed the existing index: 'IX_COM_Customer_CustomerEmail' to be unique because it was a requirement for another site. I removed the "unique" constraint on that index and it worked fine. Thanks again, Matt

Top