Results 1 to 1 of 1

Thread: MySQL error 1062: Duplicate entry...

  1. #1
    kirkdrob is offline Member
    Join Date
    May 2010
    Posts
    5

    Default MySQL error 1062: Duplicate entry...

    Recently upgraded from 5.0 to 5.5.1 After successful upgrade I was reviewing the logs and found :

    Mon Mar 14 22:33:21 2011 [12841][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:33:21 2011 [20643][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:33:21 2011 [12839][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:33:22 2011 [15715][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:33:33 2011 [15714][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:33:46 2011 [20640][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:33:46 2011 [20641][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:34:03 2011 [20648][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:34:03 2011 [20648][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:34:04 2011 [20642][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:38:11 2011 [12841][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:38:12 2011 [20643][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:44:23 2011 [15715][6fdd19a6-adea-5b27-7a5c-4a89ba1abadf][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'
    Mon Mar 14 22:44:23 2011 [23794][-none-][ERROR] MySQL error 1062: Duplicate entry '401647' for key 'PRIMARY'

    I can't track down when its happening because it's constant! Does the first [..] give me useful info to track this down. The second [..] happens to be my UserID. I fear this is severely slowing down my system and may be causing some of my other gliches.

    Linux Fedora 11
    MySQL 5.1.47
    PHP 5.2.13

    I get so much great info from these forums but I had to post.

    Did some research in the MySQL Forum and found this:
    mysqlcheck --auto-repair=true -uroot -p <dbname>

    Found the errors and corrected them. No more complaints from sugar
    Last edited by kirkdrob; 2011-03-17 at 11:35 PM. Reason: SOLVED!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 2010-04-27, 06:37 AM
  2. MySQL error 1060: Duplicate column name
    By sneen in forum Deutsche
    Replies: 4
    Last Post: 2008-10-24, 08:58 AM
  3. 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
  4. MySQL Error 1062 on creation of record
    By monsta in forum Help
    Replies: 9
    Last Post: 2007-10-01, 08:50 AM
  5. Mysql error 1062 on sending campaigns
    By emaggi in forum Help
    Replies: 0
    Last Post: 2006-11-29, 04:15 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
  •