SQL Error

  • amazed1313

    (@amazed1313)


    13 years, 5 months ago

    Dear supporters,

    I am trying to move with my worpress. i’ve read that I shall overwrite the old domain name in the SQL file – what I did, but now I’m getting this:

    ERROR 1062 (23000) at line 54669: Duplicate entry ‘http://mrssimple.de/’ for key ‘name’

    when I try to upload the SQL.
    I’ve seen topics with simular problems, but notw with the keyname. My SQL file doesn’t even have a line 54669 T_T

    Can somebody please help me?

    Best wishes

    Amazed

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

    (@esmi)

    13 years, 5 months ago

    What table is this?

    Thread Starter amazed1313

    (@amazed1313)

    13 years, 5 months ago

    Hello Esmi,

    what do you mean with “table” – I don’t even know where line 54669 is supposed to be because my file only has got 43333 lines 🙁 I’m really lost in this SQL thing

    esmi

    (@esmi)

    13 years, 5 months ago

    Which database table is being updated when the error occurs?

    Thread Starter amazed1313

    (@amazed1313)

    13 years, 5 months ago

    It’s the complete file, with all tables that has been upload

    esmi

    (@esmi)

    13 years, 5 months ago

    I understand that but we need more details – such as what table is being updated when this error occurs. Try looking at the full error message.

    Thread Starter amazed1313

    (@amazed1313)

    13 years, 5 months ago

    So, I’m really about to cry soon 😀

    What I did:

    I uploaded the original SQL, which was no problem. In the SQL I’ve changed

    the “siteurl” in the Option table, then I logged into my Admin Panel, I installed the “Search & Replace” plugin in, I wrote my old domain, replaced it with my new but it says no entrys found:

    Suche nach Beiträgen …
    … in Tabelle posts, field post_content: – 0 Einträge gefunden.
    Suche nach ID …
    … in Tabelle posts, field ID: – 0 Einträge gefunden.
    … in Tabelle posts, field post_parent: – 0 Einträge gefunden.
    … in Tabelle postmeta, field post_id: – 0 Einträge gefunden.
    … in Tabelle term_relationships, field object_id: – 0 Einträge gefunden.
    … in Tabelle comments, field comment_post_ID: – 0 Einträge gefunden.
    Suche nach GUID …
    … in Tabelle posts, field guid: – 0 Einträge gefunden.
    Suche nach Titeln …
    … in Tabelle posts, field post_title: – 0 Einträge gefunden.
    … in Tabelle posts, field post_name: – 0 Einträge gefunden.
    Suche nach Auszügen …
    … in Tabelle posts, field post_excerpt: – 0 Einträge gefunden.
    Suche nach Metadaten …
    … in Tabelle postmeta, field meta_value: – 0 Einträge gefunden.
    Suche nach modifizierten Kommentartexten …
    … in Tabelle comments, field comment_content: – 0 Einträge gefunden.
    Suche nach modifizierten Kommentarautoren …
    … in Tabelle comments, field comment_author: – 0 Einträge gefunden.
    Suche nach modifizierten Kommentarautoren E-Mail-Adressen …
    … in Tabelle comments, field comment_author_email: – 0 Einträge gefunden.
    Suche nach modifizierten Kommentarautoren URLs …
    … in Tabelle comments, field comment_author_url: – 0 Einträge gefunden.
    Suche nach Kommentarzähler …
    … in Tabelle posts, field comment_count: – 0 Einträge gefunden.
    Suche nach Kategoriebeschreibung …
    … in Tabelle term_taxonomy, field description: – 0 Einträge gefunden.
    Suche nach Tags …
    … in Tabelle terms, field name: – 0 Einträge gefunden.
    … in Tabelle terms, field slug: – 0 Einträge gefunden.
    Suche nach User-ID …
    … in Tabelle users, field ID: – 0 Einträge gefunden.
    … in Tabelle usermeta, field user_id: – 0 Einträge gefunden.
    … in Tabelle posts, field post_author: – 0 Einträge gefunden.
    … in Tabelle comments, field user_id: – 0 Einträge gefunden.
    … in Tabelle links, field link_owner: – 0 Einträge gefunden.
    Suche nach User-Login …
    … in Tabelle users, field user_login: – 0 Einträge gefunden.
    … in Tabelle users, field user_nicename: – 0 Einträge gefunden.

    and all my links in the page link to my old domain even the “to my site” in the admin Panel.

    Do you know what I do wrong?

    Thread Starter amazed1313

    (@amazed1313)

    13 years, 5 months ago

    Ha, wait! I found it! I had the www in the search, but it’s just http:// :o)

    So it seems to be working now … hopefully :o)

    Thanks!

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

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

Tags