View Single Post
  #5  
Old 1st August 2006, 12:18
comedit comedit is offline
Member
 
Join Date: May 2006
Posts: 57
Thanks: 0
Thanked 1 Time in 1 Post
Default Stuck at SQL: #1062 - Duplicate entry '2' for key 1

gettind smarter by the minute I have decided to set up a second server and then install rsync to avoid problems as mentioned above:

So i did the perfect setup debian 3.1, installed 2.2.5
(allthough the manual is great, you feel a big relief and satisfaction when its working).

I have replace the /root/ispconfig and /home/admispconfig on the new server and then tried the sql dump (first on commandline then PHPadmin:

This is what I don't understand what is wrong here ?

SQL-query:

INSERT INTO `dns_a` ( `doc_id` , `doctype_id` , `host` , `ip_adresse` )
VALUES ( 2, 1018, 'kigaro', '81.58.147.208' )

MySQL retourneerde: Documentatie
#1062 - Duplicate entry '2' for key 1



Since it says duplicate entry I deleted the second one is this list 3,1018,'www','81.58.147.208' .

But that's just trial and error and basically not right

Any suggestions ?
Reply With Quote