Results 1 to 4 of 4

Thread: Duplicate Entry Errors - Should I worry?

  1. #1
    jjwdesign's Avatar
    jjwdesign is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Orlando, FL
    Posts
    503

    Default Duplicate Entry Errors - Should I worry?

    I've noticed several (dozen a day) MySQL errors from our Sugar CRM error log file. They seem to be from a mix of users and a mix of module objects. I wonder if these have anything to do with the Tracker module and/or some of our Networking issues that have been causing people to have to "re-click" a link or submit button. The amazing thing is that nobody has complained, yet. Should I worry?

    Code:
    Wed Nov 12 14:14:29 2008 [23423][5be26f76-f52a-f956-d90f-481f0c338cc5][ERROR] MySQL error 1062: Duplicate entry '1c67f164-5931-b696-635a-45919e6c8795' for key 1
    Wed Nov 12 14:14:39 2008 [23453][1e800ee0-0486-d630-dd99-48035e42dbe5][ERROR] MySQL error 1062: Duplicate entry '8fa2f97d-546f-d594-1f01-4863be5b59f0' for key 1
    Wed Nov 12 14:15:28 2008 [23440][1e800ee0-0486-d630-dd99-48035e42dbe5][ERROR] MySQL error 1062: Duplicate entry '8fa2f97d-546f-d594-1f01-4863be5b59f0' for key 1
    Wed Nov 12 14:16:49 2008 [23423][b7836814-8d47-8021-931a-466d8e6f12f6][ERROR] MySQL error 1062: Duplicate entry 'a2e94dd0-1661-6ff1-ee95-48bd42da29d1' for key 1
    Wed Nov 12 14:17:27 2008 [23423][b7836814-8d47-8021-931a-466d8e6f12f6][ERROR] MySQL error 1062: Duplicate entry '779870d5-c0f7-a27d-5150-48d10ee19fa9' for key 1
    Wed Nov 12 14:19:07 2008 [23484][5be26f76-f52a-f956-d90f-481f0c338cc5][ERROR] MySQL error 1062: Duplicate entry 'e901d9d4-95d5-8338-8756-489357d5cd3e' for key 1
    Wed Nov 12 14:21:25 2008 [23492][2c90492b-7531-1594-eb6c-4579c2b4b0af][ERROR] MySQL error 1062: Duplicate entry 'cdfea71d-97c2-1f6f-4311-490f0d6ab834' for key 1
    Wed Nov 12 14:21:37 2008 [23461][2c90492b-7531-1594-eb6c-4579c2b4b0af][ERROR] MySQL error 1062: Duplicate entry 'cdfea71d-97c2-1f6f-4311-490f0d6ab834' for key 1
    Wed Nov 12 14:28:08 2008 [23523][2c90492b-7531-1594-eb6c-4579c2b4b0af][ERROR] MySQL error 1062: Duplicate entry '26272a3a-9f6c-a9c9-9e61-458c1142e52a' for key 1
    Wed Nov 12 14:28:31 2008 [23523][2c90492b-7531-1594-eb6c-4579c2b4b0af][ERROR] MySQL error 1062: Duplicate entry '26272a3a-9f6c-a9c9-9e61-458c1142e52a' for key 1
    Wed Nov 12 14:30:52 2008 [23625][5be26f76-f52a-f956-d90f-481f0c338cc5][ERROR] MySQL error 1062: Duplicate entry 'd68afa4c-f9ed-4a80-df69-480df70770fb' for key 1
    Wed Nov 12 14:31:40 2008 [23615][2c90492b-7531-1594-eb6c-4579c2b4b0af][ERROR] MySQL error 1062: Duplicate entry 'bf79d8cf-e105-7567-9938-491856d963ec' for key 1
    SugarForge Projects:
    JJWDesign Google Maps
    JJWDesign Tools and Reports

    Follow my blog postings at JJW Design.

  2. #2
    jjwdesign's Avatar
    jjwdesign is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Orlando, FL
    Posts
    503

    Default Re: Duplicate Entry Errors - Should I worry?

    I assume this is due to networking issues, which have caused people to click on the save buttons more than once.
    SugarForge Projects:
    JJWDesign Google Maps
    JJWDesign Tools and Reports

    Follow my blog postings at JJW Design.

  3. #3
    jjwdesign's Avatar
    jjwdesign is offline Sugar Community Member
    Join Date
    Dec 2006
    Location
    Orlando, FL
    Posts
    503

    Default Re: Duplicate Entry Errors - Should I worry?

    Bump...bump...
    SugarForge Projects:
    JJWDesign Google Maps
    JJWDesign Tools and Reports

    Follow my blog postings at JJW Design.

  4. #4
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: Duplicate Entry Errors - Should I worry?

    Quote Originally Posted by jjwdesign View Post
    I assume this is due to networking issues, which have caused people to click on the save buttons more than once.
    Hi Jeff

    Probably this is the reason of this MySQL error, once the error warned is duplicate entry.

    Regards
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. avoid duplicate entry in relationship table
    By velocitygirl in forum Help
    Replies: 2
    Last Post: 2008-09-10, 07:53 PM
  2. error when trying to upgrade to 5.0.0e with a duplicate entry
    By carlatpg in forum Installation and Upgrade Help
    Replies: 1
    Last Post: 2008-06-19, 01:53 PM
  3. Replies: 0
    Last Post: 2006-09-19, 01:12 AM
  4. Primary Key ID field duplicate entry upon import
    By andrewstuart in forum Help
    Replies: 1
    Last Post: 2005-04-04, 07:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •