Register for your free account! | Forgot your password?

Go Back   elitepvpers > World of Warcraft > WoW Private Server
You last visited: Today at 07:47

  • Please register to post and access all features, it's quick, easy and FREE!

 

Fehler beim Einbatchen!

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
Question Fehler beim Einbatchen!

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

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

Wie gesagt bitte hilfe so schnell es geht

MFG
Flochecka



Flochecka is offline  
Old   #2
 
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
/Vote4Close hab herrausgefunden :O


Flochecka is offline  
Old   #3
 
elite*gold: 0
Join Date: Mar 2010
Posts: 60
Received Thanks: 3
sag mal woran lag es ?
edward1 is offline  
Old   #4
 
elite*gold: 2703
Join Date: Jul 2010
Posts: 6,451
Received Thanks: 1,232
INSERT in REPLACE umschreiben oder erst DELETE und dann INSERT machen.

Sprich:

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

oder:

DELETE *** (***) VALUES (xx);
INSERT INTO *** (xx, xx) VALUES (xx,xx);


°"Crazy"° is offline  
Old   #5
 
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
@ Crazy! DAs is falsch die waren schon eingebatcht xP
Flochecka is offline  
Old   #6
 
elite*gold: 2703
Join Date: Jul 2010
Posts: 6,451
Received Thanks: 1,232
Achja. Lern du erstmal den Unterscheid zwischen INSERT und REPLACE. Geh erstmal weiterspielen im Kindergarten, danke.
°"Crazy"° is offline  
Old   #7
 
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
ää du checkst das grad nicht? der fehler war da weil die sachen schon im vendor waren ... daher wollte der ab da nich mehr einbatchen -.-
Flochecka is offline  
Old   #8
 
elite*gold: 2703
Join Date: Jul 2010
Posts: 6,451
Received Thanks: 1,232
Deswegen nimmt man immer REPLACE, da dort die Datensätze ersetzt werden, statt wieder reinzubringen. Ist wie F5 im Browser.

MfG
°"Crazy"° is offline  
Old   #9
 
elite*gold: 0
Join Date: Jun 2011
Posts: 147
Received Thanks: 13
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');


MAGi!x is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Fehler beim V PC
Hey liebes Forum, Ich hab bei mir im Filezilla die Locale Big5 datei editiert. Also usr/rain/channel/share_data/locale/hongkong/quest locale big5 da...
1 Replies - Metin2 Main - Discussions / Questions
Mysql fehler beim einbatchen
wollte gerade meine neue world einbatchen, un siehe da bekomme diesen fehler The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB'...
10 Replies - WoW Private Server
Beim Eigenen Server Fehler beim Verbinden mit dem Server
Hallo, Habe ein Problem wenn cih mein Metin2 Starten will komm da Fehler beim verbinden mit dem Server bitte um Hilfe über Team Viewer daten gibts...
3 Replies - Metin2 PServer - Discussions / Questions
Problem beim einbatchen von NPCs
Hallo liebe Com, ich habe mir auf wow-v.com ein Monster erstellt dass ich gerne in mein WoW einfügen will. Ich weiss wie das geht und mit Waffen...
5 Replies - WoW Private Server



All times are GMT +1. The time now is 07:47.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.