Fehler beim Einbatchen!

05/28/2011 16:38 Flochecka#1
Hallo Leute,

Ich besitze die WoW Core 4.0.6a von SkyFire.

Ich bin von easy-emu auf die Creatorpage gegangen und auf Vendor erstellen.

Da wo man eben die sachen in einen vendor adden kann.

So nun hab ich die zeile kopiert also:

INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65179');

Also habe ich das mit MEHREREN zeilen gemacht (um die 100) weil ich alles von cata rein adden wollte bzw. die rüssi

Als ich dann nach 2h Fertig war dachte ich mir Batchs mal ein wird schon nit schief gehen.

Hab mir die Daumen gedrückt und habs versucht und dann kam das:

[Err] 1062 - Duplicate entry '12783-65209-0' for key 1
[Err] INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65209');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Jetze weis ich nicht mehr weiter weil ich ka habe was der will -.-

Bitte bitte helft mir :D

HTML Code:
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65179');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65180');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65181');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65182');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65183');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65269');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65270');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65271');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65272');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65273');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60418');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60419');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60420');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60421');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60422');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65214');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65215');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65216');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65217');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65218');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65219');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65220');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65221');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65222');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65223');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60601');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60602');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60603');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60604');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60605');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60413');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60414');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60415');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60416');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60417');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65204');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65205');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65206');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65207');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65208');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65209');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60423');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60424');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60425');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60426');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60427');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65239');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65240');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65241');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65242');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65243');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60458');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60459');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60460');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60451');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60452');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65229');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65230');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65231');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65232');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65233');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65234');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65235');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65236');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65237');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65238');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60473');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60474');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60475');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60476');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60477');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60468');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60469');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60470');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60471');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60472');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65244');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65245');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65246');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65247');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65248');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65249');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65250');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65251');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65252');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65253');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60438');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60439');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60440');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60441');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60442');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60428');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60429');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60430');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60431');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60432');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65209');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65210');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65211');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65212');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65213');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60463');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60464');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60465');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60466');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60467');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65259');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65260');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65261');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65262');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65263');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60478');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60479');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60480');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60481');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60482');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65194');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65195');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65196');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65197');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65198');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65189');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65190');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65191');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65192');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65193');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60443');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60444');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60445');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60446');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60447');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60448');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60449');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60450');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60451');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60452');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60238');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60629');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65034');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60632');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65069');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60630');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65021');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60594');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60231');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60586');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60236');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60593');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65068');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60559');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65132');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60566');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60235');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60557');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60228');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60512');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65040');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60508');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60229');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60509');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60227');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65107');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65112');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60661');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60666');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60673');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60226');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65082');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65076');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60645');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60659');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60651');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '69113');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '69149');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '69198');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '69112');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61033');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61026');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60794');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60801');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61031');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61035');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60232');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65117');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60786');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '60776');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67478');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65133');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '49086');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '46105');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65023');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67476');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65052');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67477');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61950');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61949');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '61945');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '64674');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '64673');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65024');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67474');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67453');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65145');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67461');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65058');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65017');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67470');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65007');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67452');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67451');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '69843');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65047');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67469');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67447');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65003');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65139');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65102');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67449');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67448');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65081');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67472');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67466');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '67465');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65064');
INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '51809');
Das ist alles zusammen :D

Wie gesagt bitte hilfe so schnell es geht ;)

MFG
Flochecka
05/28/2011 20:17 Flochecka#2
/Vote4Close hab herrausgefunden :O
05/29/2011 17:39 edward1#3
sag mal woran lag es ?
05/29/2011 18:00 °"Crazy"°#4
INSERT in REPLACE umschreiben oder erst DELETE und dann INSERT machen.

Sprich:

REPLACE INTO xxx (xx, xx) VALUES (xx,xx);

oder:

DELETE XXX (xxx) VALUES (xx);
INSERT INTO xxx (xx, xx) VALUES (xx,xx);
06/01/2011 14:25 Flochecka#5
@ Crazy! DAs is falsch :D die waren schon eingebatcht xP
06/01/2011 17:21 °"Crazy"°#6
Achja. Lern du erstmal den Unterscheid zwischen INSERT und REPLACE. Geh erstmal weiterspielen im Kindergarten, danke.
06/02/2011 12:34 Flochecka#7
ää du checkst das grad nicht? der fehler war da weil die sachen schon im vendor waren ... daher wollte der ab da nich mehr einbatchen -.-
06/02/2011 18:55 °"Crazy"°#8
Deswegen nimmt man immer REPLACE, da dort die Datensätze ersetzt werden, statt wieder reinzubringen. Ist wie F5 im Browser.

MfG
06/02/2011 21:24 MAGi!x#9
wenn

[Err] 1062 - Duplicate entry '12783-65209-0' for key 1
[Err] INSERT INTO `npc_vendor` (entry, item) VALUES ('12783', '65209');
[Msg] Finished - Unsuccessfully

dort steht ist das Problem eigentlich deutlich dargestellt. Einfach 12783-65209 DELETEn
und neu einbatchen, schon ist dein problem gelöst.

Quote:
DELETE from `npc_vendor` (entry, item) VALUES ('12783', '65179');