SQL Error 1062

  • Resolved nsuydam1

    (@nsuydam1)


    15 years, 10 months ago

    Hello all,

    I’m having problems restoring my database from a backup. I changed my hosting account to a different url, and I want to upload my content again. I backed up everything, and have started uploading from myPHPadmin, but I get this error:

    SQL query:

    INSERT INTO wp_bas_refer
    VALUES ( 2520, ‘…flickr address…’ ) ;

    MySQL said: Documentation
    #1062 – Duplicate entry ‘2520’ for key 1

    I’ve searched high and wide for an answer, but I can’t seem to come up with anything that helps. Any ideas?

    Thanks!

    Nick S.

Viewing 7 replies - 1 through 7 (of 7 total)
  • vtxyzzy

    (@vtxyzzy)

    15 years, 10 months ago

    Looks like that entry already exists in the wp_bas_refer table.

    Thread Starter nsuydam1

    (@nsuydam1)

    15 years, 10 months ago

    Any idea how to correct that? Can I just delete that entry somehow?

    vtxyzzy

    (@vtxyzzy)

    15 years, 10 months ago

    You can delete rows from phpMyAdmin.

    Back up your database first!

    Just click on the table you want to change so the rows are showing. Then, click the red X next to a row.

    If you want to delete multiple rows, mark the ones to delete in the check-boxes, then scroll down to the bottom of the list and click the red X there.

    Thread Starter nsuydam1

    (@nsuydam1)

    15 years, 10 months ago

    Thanks! But I just tried deleting entry 2520 from the wp_bas_refer file as you explain above, and then uploading the backup file again, and I get the same error, same entry and everything. This is getting pretty annoying!

    vtxyzzy

    (@vtxyzzy)

    15 years, 10 months ago

    Well, you may have duplicate rows in your backup file.

    Thread Starter nsuydam1

    (@nsuydam1)

    15 years, 10 months ago

    Thanks, yep seems to have worked! Can’t believe I didn’t think of that sooner….

    Thanks again,

    Nick

    vtxyzzy

    (@vtxyzzy)

    15 years, 10 months ago

    You are welcome!

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘SQL Error 1062’ is closed to new replies.