Fixing sql #1062 duplicate content error

  • pvijeh

    (@pvijeh)


    10 years, 4 months ago

    Hello,

    I am trying to upload one of my site’s sql databases using phpmyadmin– however i get the following error:

    #1062 – Duplicate entry ‘153’ for key ‘id’

    Does anyone know how to solve this error?

Viewing 4 replies - 1 through 4 (of 4 total)
  • catacaustic

    (@catacaustic)

    10 years, 4 months ago

    Yes, it’s quite easy – but can be a bit scary.

    Any time that you’re restoring like that, you need to delete any existing database tables that you’ll be importing. The import creats everything itself, so the database needs to be empty before you start.

    Thread Starter pvijeh

    (@pvijeh)

    10 years, 4 months ago

    Hey Catacaustic,

    thanks for the reply.

    I should have mentioned that I am trying to upload to a new blank database.

    — dig the cat photo btw.

    Anyone else got some ideas?

    catacaustic

    (@catacaustic)

    10 years, 4 months ago

    OK, so does the error give you any more information? Most times the error message will include a line of where the error has occured.

    If that’s not there you can manually go through the SQL dump file and find everything with an ID of 153 and see if there’s any overlap in the tables anywhere. There could be if there was some error in the export process, so it’s worth a look.

    Thread Starter pvijeh

    (@pvijeh)

    10 years, 4 months ago

    Hey thanks a lot for the help- i appreciate it.

    this is what phpmyadmin spits out:

    ——————————————————

    SQL query:

    — — Dumping data for table wp_nxs_log — INSERT INTO wp_nxs_log (id, date, act, nt, type, msg, extInfo) VALUES (153, ‘2013-11-01 16:39:11’, ‘Scheduled’, ‘Twitter (moving to new york)’, ‘BI’, ‘ PostID:(3078)’, ”), (154, ‘2013-11-01 16:39:35’, ‘Posted’, ‘<span style=”color:#014A76″>Plurk</span> – moving to new york’, ‘S’, ‘OK – Message Posted ‘, ‘ | PostID: 3078 – Is This New York”s Smallest Apartment? ‘), (155, ‘2013-11-01 16:39:36’, ‘Posted’, ‘<span style=”color:#014A76″>Tumblr</span> – moving to new york tumblr’, ‘S’, ‘OK – Message Posted ‘, ‘ | PostID: 3078 – Is This New York”s Smallest Apartment? |im’), (156, ‘2013-11-01 16:39:37’, ‘Posted’, ‘<span style=”color:#00FFFF”>Twitter</span> – moving to new york’, ‘S’, ‘OK – Message Posted ‘, ”), (157, ‘2013-11-01 16:39:44’, ‘Posted’, ‘<span style=”color:#000080″>StumbleUpon</span> – moving to new york’, ‘S’, ‘OK – Message Posted ‘, ‘ | PostID: 3078 – Is This New York”s Smallest Apartment? ‘), (158, ‘2013-11[…]

    MySQL said: Documentation

    #1062 – Duplicate entry ‘153’ for key ‘id’

    ————————————————-

    i have tried to go through the sql file and delete some stuff in a text editor– but i have not gotten that to work so far. I am not really sure what i should be deleting and what i should leave alone.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Fixing sql #1062 duplicate content error’ is closed to new replies.