You last visited: Today at 06:46
Advertisement
Fehler beim Einbatchen!
Discussion on Fehler beim Einbatchen! within the WoW Private Server forum part of the World of Warcraft category.
05/28/2011, 16:38
#1
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
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
05/28/2011, 20:17
#2
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
/Vote4Close hab herrausgefunden :O
05/29/2011, 17:39
#3
elite*gold: 0
Join Date: Mar 2010
Posts: 60
Received Thanks: 3
sag mal woran lag es ?
05/29/2011, 18:00
#4
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
INSERT in REPLACE umschreiben oder erst DELETE und dann INSERT machen.
06/01/2011, 14:25
#5
elite*gold: 0
Join Date: Aug 2010
Posts: 168
Received Thanks: 8
@ Crazy! DAs is falsch
die waren schon eingebatcht xP
06/01/2011, 17:21
#6
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
Achja. Lern du erstmal den Unterscheid zwischen INSERT und REPLACE. Geh erstmal weiterspielen im Kindergarten, danke.
06/02/2011, 12:34
#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 -.-
06/02/2011, 18:55
#8
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
Deswegen nimmt man immer REPLACE, da dort die Datensätze ersetzt werden, statt wieder reinzubringen. Ist wie F5 im Browser.
06/02/2011, 21:24
#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');
Fehler beim V PC
01/05/2011 - Metin2 - 1 Replies
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 hab ich bei dem wächter des dorfplatzes was geändert hab reboot gemacht und jez bekomm ich immer so ein komischen fehler da steht imemr irgendwas von "rename core" ich kann das nciht so schnell abtippenbitte ich brauch hilfe!!:rtfm:
Mysql fehler beim einbatchen
07/11/2010 - WoW Private Server - 10 Replies
wollte gerade meine neue world einbatchen, un siehe da bekomme diesen fehler
The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working
Beim Eigenen Server Fehler beim Verbinden mit dem Server
02/24/2010 - Metin2 Private Server - 3 Replies
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 über pn danke
Problem beim einbatchen von NPCs
12/31/2009 - WoW Private Server - 5 Replies
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 habe ich das auch schon sehr oft gemacht.
Allerdings kommt beim einbatchen in Navicat ein Error:
1146 - Table 'world.creature_names' doesn't exist
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`,...
All times are GMT +2. The time now is 06:49 .
Fehler beim Einbatchen!
