Title: SQL Error Last modified: August 20, 2016 --- # SQL Error * [amazed1313](https://wordpress.org/support/users/amazed1313/) * (@amazed1313) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/) * 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/’](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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295055) * What table is this? * Thread Starter [amazed1313](https://wordpress.org/support/users/amazed1313/) * (@amazed1313) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295060) * 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](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295064) * Which database table is being updated when the error occurs? * Thread Starter [amazed1313](https://wordpress.org/support/users/amazed1313/) * (@amazed1313) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295065) * It’s the complete file, with all tables that has been upload * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295066) * 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](https://wordpress.org/support/users/amazed1313/) * (@amazed1313) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295067) * 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](https://wordpress.org/support/users/amazed1313/) * (@amazed1313) * [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295068) * 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 * [sql](https://wordpress.org/support/topic-tag/sql/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 7 replies * 2 participants * Last reply from: [amazed1313](https://wordpress.org/support/users/amazed1313/) * Last activity: [13 years, 5 months ago](https://wordpress.org/support/topic/sql-error-12/#post-3295068) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics