Problem bei der Datenbank und natürlich auch Charakter Batch problem

WoWEMU World � Mangos � Support � Problem bei der Datenbank und natürlich auch Charakter Batch problem

Themen-Einstellungen

Bereich wechseln

Allgemeines Talk-Bereich Privat Server Regeln Mangos Support Tipps und Tricks Anleitungsforum Downloads Trinity Core Support Tipps und Tricks Anleitungsforum Downloads ArcEmu Support Scripts Tipps und Tricks Anleitungsforum Dowloads WoW EMU (1.12.x) Support Anleitungen Tipps und Tricks Sonstiges Scripts Downloads WoWEMU (WAD) ManGOS

#1 | Problem bei der Datenbank und natürlich auch Charakter Batch problem datum

02.11.2009 23:19

Servus miteinander

Ich habe 2 folgende probleme die ich gar nicht hinbekomme, was mich tierisch auch etwas anstinkt.

Ich habe nen Linux Debian 64 bit Lamp Root. Habe ebenfalls das tutorial : http://88321.homepagemodules.de/t7165f13...-erstellen.html gemacht

Meine Probleme sind wie folgt :

bei MySQL Query Browser speise ich die full_db : TDB_0.0.5_5254 ein ... wo dabei nen haufen fehler kommen :

Script line: 25 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`level_min` tinyint(3) unsigned NOT NULL DEFAULT '0',
' at line 2
Script line: 47 Table 'trinityworld.access_requirement' doesn't exist
Script line: 49 Table 'trinityworld.access_requirement' doesn't exist
Script line: 60 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system'' at line 7
Script line: 73 Table 'trinityworld.achievement_criteria_data' doesn't exist
Script line: 75 Table 'trinityworld.achievement_criteria_data' doesn't exist
Script line: 86 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 10
Script line: 102 Table 'trinityworld.achievement_reward' doesn't exist
Script line: 104 Table 'trinityworld.achievement_reward' doesn't exist
Script line: 115 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMM' at line 2
Script line: 126 Table 'trinityworld.areatrigger_involvedrelation' doesn't exist
Script line: 128 Table 'trinityworld.areatrigger_involvedrelation' doesn't exist
Script line: 139 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 150 Table 'trinityworld.areatrigger_scripts' doesn't exist
Script line: 152 Table 'trinityworld.areatrigger_scripts' doesn't exist
Script line: 163 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`name` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEF' at line 2
Script line: 174 Table 'trinityworld.areatrigger_tavern' doesn't exist
Script line: 176 Table 'trinityworld.areatrigger_tavern' doesn't exist
Script line: 187 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`name` text,
`access_id` bigint(20) unsigned NOT NUL' at line 2
Script line: 205 Table 'trinityworld.areatrigger_teleport' doesn't exist
Script line: 207 Table 'trinityworld.areatrigger_teleport' doesn't exist
Script line: 218 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 229 Table 'trinityworld.autobroadcast' doesn't exist
Script line: 241 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 259 Table 'trinityworld.battleground_template' doesn't exist
Script line: 261 Table 'trinityworld.battleground_template' doesn't exist
Script line: 272 You have an error in your SQL syntax near 'COMMENT 'Entry of a creature',
`bg_template` mediumint(8) unsigned NOT NULL D' at line 2
Script line: 283 Table 'trinityworld.battlemaster_entry' doesn't exist
Script line: 285 Table 'trinityworld.battlemaster_entry' doesn't exist
Script line: 296 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System'' at line 6
Script line: 308 Table 'trinityworld.command' doesn't exist
Script line: 310 Table 'trinityworld.command' doesn't exist
Script line: 321 You have an error in your SQL syntax near 'COMMENT 'Global Unique Identifier',
`id` mediumint(8) unsigned NOT NULL DEFAU' at line 2
Script line: 350 Table 'trinityworld.creature' doesn't exist
Script line: 352 Table 'trinityworld.creature' doesn't exist
Script line: 353 Table 'trinityworld.creature' doesn't exist
Script line: 354 Table 'trinityworld.creature' doesn't exist
Script line: 355 Table 'trinityworld.creature' doesn't exist
Script line: 356 Table 'trinityworld.creature' doesn't exist
Script line: 357 Table 'trinityworld.creature' doesn't exist
Script line: 358 Table 'trinityworld.creature' doesn't exist
Script line: 359 Table 'trinityworld.creature' doesn't exist
Script line: 360 Table 'trinityworld.creature' doesn't exist
Script line: 361 Table 'trinityworld.creature' doesn't exist
Script line: 362 Table 'trinityworld.creature' doesn't exist
Script line: 373 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 10
Script line: 389 Table 'trinityworld.creature_addon' doesn't exist
Script line: 391 Table 'trinityworld.creature_addon' doesn't exist
Script line: 392 Table 'trinityworld.creature_addon' doesn't exist
Script line: 393 Table 'trinityworld.creature_addon' doesn't exist
Script line: 404 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`creature_id` int(11) unsigned NOT NULL DEFAULT '0' COM' at line 2
Script line: 436 Table 'trinityworld.creature_ai_scripts' doesn't exist
Script line: 438 Table 'trinityworld.creature_ai_scripts' doesn't exist
Script line: 439 Table 'trinityworld.creature_ai_scripts' doesn't exist
Script line: 450 You have an error in your SQL syntax near 'COMMENT 'Location Identifier',
`position_x` float NOT NULL DEFAULT '0',
`p' at line 2
Script line: 466 Table 'trinityworld.creature_ai_summons' doesn't exist
Script line: 468 Table 'trinityworld.creature_ai_summons' doesn't exist
Script line: 479 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'' at line 18
Script line: 503 Table 'trinityworld.creature_ai_texts' doesn't exist
Script line: 505 Table 'trinityworld.creature_ai_texts' doesn't exist
Script line: 516 You have an error in your SQL syntax near 'COMMENT 'Unique entry',
`equipentry1` mediumint(8) unsigned NOT NULL DEFAULT ' at line 2
Script line: 529 Table 'trinityworld.creature_equip_template' doesn't exist
Script line: 531 Table 'trinityworld.creature_equip_template' doesn't exist
Script line: 542 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 8
Script line: 556 Table 'trinityworld.creature_formations' doesn't exist
Script line: 558 Table 'trinityworld.creature_formations' doesn't exist
Script line: 569 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMM' at line 2
Script line: 580 Table 'trinityworld.creature_involvedrelation' doesn't exist
Script line: 582 Table 'trinityworld.creature_involvedrelation' doesn't exist
Script line: 593 You have an error in your SQL syntax near 'COMMENT 'dependent creature',
`linkedGuid` int(10) unsigned NOT NULL COMMENT ' at line 2
Script line: 604 Table 'trinityworld.creature_linked_respawn' doesn't exist
Script line: 606 Table 'trinityworld.creature_linked_respawn' doesn't exist
Script line: 617 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'' at line 12
Script line: 635 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 637 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 638 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 639 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 640 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 641 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 642 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 643 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 644 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 645 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 646 Table 'trinityworld.creature_loot_template' doesn't exist
Script line: 657 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Model related info)' at line 8
Script line: 671 Table 'trinityworld.creature_model_info' doesn't exist
Script line: 673 Table 'trinityworld.creature_model_info' doesn't exist
Script line: 684 You have an error in your SQL syntax near 'COMMENT 'Creature Identifier',
`RewOnKillRepFaction1` smallint(6) NOT NULL DE' at line 2
Script line: 703 Table 'trinityworld.creature_onkill_reputation' doesn't exist
Script line: 705 Table 'trinityworld.creature_onkill_reputation' doesn't exist
Script line: 716 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMM' at line 2
Script line: 727 Table 'trinityworld.creature_questrelation' doesn't exist
Script line: 729 Table 'trinityworld.creature_questrelation' doesn't exist
Script line: 740 You have an error in your SQL syntax near 'COMMENT 'Global Unique Identifier',
`respawntime` bigint(20) NOT NULL DEFAULT' at line 2
Script line: 753 Table 'trinityworld.creature_respawn' doesn't exist
Script line: 765 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'' at line 85
Script line: 856 Table 'trinityworld.creature_template' doesn't exist
Script line: 858 Table 'trinityworld.creature_template' doesn't exist
Script line: 859 Table 'trinityworld.creature_template' doesn't exist
Script line: 860 Table 'trinityworld.creature_template' doesn't exist
Script line: 861 Table 'trinityworld.creature_template' doesn't exist
Script line: 862 Table 'trinityworld.creature_template' doesn't exist
Script line: 863 Table 'trinityworld.creature_template' doesn't exist
Script line: 864 Table 'trinityworld.creature_template' doesn't exist
Script line: 875 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 10
Script line: 891 Table 'trinityworld.creature_template_addon' doesn't exist
Script line: 893 Table 'trinityworld.creature_template_addon' doesn't exist
Script line: 904 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts'' at line 18
Script line: 928 Table 'trinityworld.custom_texts' doesn't exist
Script line: 940 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 13
Script line: 959 Table 'trinityworld.db_script_string' doesn't exist
Script line: 961 Table 'trinityworld.db_script_string' doesn't exist
Script line: 972 You have an error in your SQL syntax near 'COMMENT 'Recommended id selection: item_level*100 + item_quality',
`item` med' at line 2
Script line: 990 Table 'trinityworld.disenchant_loot_template' doesn't exist
Script line: 992 Table 'trinityworld.disenchant_loot_template' doesn't exist
Script line: 1003 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 1021 Table 'trinityworld.event_scripts' doesn't exist
Script line: 1023 Table 'trinityworld.event_scripts' doesn't exist
Script line: 1034 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System'' at line 5
Script line: 1045 Table 'trinityworld.exploration_basexp' doesn't exist
Script line: 1047 Table 'trinityworld.exploration_basexp' doesn't exist
Script line: 1058 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'' at line 12
Script line: 1076 Table 'trinityworld.fishing_loot_template' doesn't exist
Script line: 1078 Table 'trinityworld.fishing_loot_template' doesn't exist
Script line: 1089 You have an error in your SQL syntax near 'COMMENT 'Entry of the game event',
`start_time` timestamp NOT NULL DEFAULT '0' at line 2
Script line: 1106 Table 'trinityworld.game_event' doesn't exist
Script line: 1108 Table 'trinityworld.game_event' doesn't exist
Script line: 1119 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 1130 Table 'trinityworld.game_event_battleground_holiday' doesn't exist
Script line: 1132 Table 'trinityworld.game_event_battleground_holiday' doesn't exist
Script line: 1143 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 9
Script line: 1158 Table 'trinityworld.game_event_condition' doesn't exist
Script line: 1160 Table 'trinityworld.game_event_condition' doesn't exist
Script line: 1171 You have an error in your SQL syntax near 'COMMENT 'Put negatives values to remove during event',
PRIMARY KEY (`guid`)
' at line 3
Script line: 1182 Table 'trinityworld.game_event_creature' doesn't exist
Script line: 1184 Table 'trinityworld.game_event_creature' doesn't exist
Script line: 1195 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 6
Script line: 1207 Table 'trinityworld.game_event_creature_quest' doesn't exist
Script line: 1209 Table 'trinityworld.game_event_creature_quest' doesn't exist
Script line: 1220 You have an error in your SQL syntax near 'COMMENT 'Put negatives values to remove during event',
PRIMARY KEY (`guid`)
' at line 3
Script line: 1231 Table 'trinityworld.game_event_gameobject' doesn't exist
Script line: 1233 Table 'trinityworld.game_event_gameobject' doesn't exist
Script line: 1244 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 6
Script line: 1256 Table 'trinityworld.game_event_gameobject_quest' doesn't exist
Script line: 1268 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 7
Script line: 1281 Table 'trinityworld.game_event_model_equip' doesn't exist
Script line: 1283 Table 'trinityworld.game_event_model_equip' doesn't exist
Script line: 1294 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 6
Script line: 1306 Table 'trinityworld.game_event_npc_gossip' doesn't exist
Script line: 1308 Table 'trinityworld.game_event_npc_gossip' doesn't exist
Script line: 1319 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 9
Script line: 1334 Table 'trinityworld.game_event_npc_vendor' doesn't exist
Script line: 1336 Table 'trinityworld.game_event_npc_vendor' doesn't exist
Script line: 1347 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 6
Script line: 1359 Table 'trinityworld.game_event_npcflag' doesn't exist
Script line: 1361 Table 'trinityworld.game_event_npcflag' doesn't exist
Script line: 1372 You have an error in your SQL syntax near 'COMMENT 'Id of the pool',
`event` smallint(6) NOT NULL DEFAULT '0' COMMENT 'P' at line 2
Script line: 1383 Table 'trinityworld.game_event_pool' doesn't exist
Script line: 1395 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 1406 Table 'trinityworld.game_event_prerequisite' doesn't exist
Script line: 1408 Table 'trinityworld.game_event_prerequisite' doesn't exist
Script line: 1419 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 7
Script line: 1432 Table 'trinityworld.game_event_quest_condition' doesn't exist
Script line: 1434 Table 'trinityworld.game_event_quest_condition' doesn't exist
Script line: 1445 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System'' at line 6
Script line: 1457 Table 'trinityworld.game_graveyard_zone' doesn't exist
Script line: 1459 Table 'trinityworld.game_graveyard_zone' doesn't exist
Script line: 1470 You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=1412 DEFAULT CHARSET=utf8 COMMENT='Tele Command'' at line 10
Script line: 1486 Table 'trinityworld.game_tele' doesn't exist
Script line: 1488 Table 'trinityworld.game_tele' doesn't exist
Script line: 1499 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'' at line 16
Script line: 1521 Table 'trinityworld.game_weather' doesn't exist
Script line: 1523 Table 'trinityworld.game_weather' doesn't exist
Script line: 1534 You have an error in your SQL syntax near 'COMMENT 'Global Unique Identifier',
`id` mediumint(8) unsigned NOT NULL DEFAU' at line 2
Script line: 1559 Table 'trinityworld.gameobject' doesn't exist
Script line: 1561 Table 'trinityworld.gameobject' doesn't exist
Script line: 1562 Table 'trinityworld.gameobject' doesn't exist
Script line: 1563 Table 'trinityworld.gameobject' doesn't exist
Script line: 1564 Table 'trinityworld.gameobject' doesn't exist
Script line: 1565 Table 'trinityworld.gameobject' doesn't exist
Script line: 1566 Table 'trinityworld.gameobject' doesn't exist
Script line: 1577 You have an error in your SQL syntax near 'COMMENT 'Quest Identifier',
PRIMARY KEY (`id`,`quest`)
) ENGINE=MyISAM DEFAU' at line 3
Script line: 1588 Table 'trinityworld.gameobject_involvedrelation' doesn't exist
Script line: 1590 Table 'trinityworld.gameobject_involvedrelation' doesn't exist
Script line: 1601 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'' at line 12
Script line: 1619 Table 'trinityworld.gameobject_loot_template' doesn't exist
Script line: 1621 Table 'trinityworld.gameobject_loot_template' doesn't exist
Script line: 1632 You have an error in your SQL syntax near 'COMMENT 'Quest Identifier',
PRIMARY KEY (`id`,`quest`)
) ENGINE=MyISAM DEFAU' at line 3
Script line: 1643 Table 'trinityworld.gameobject_questrelation' doesn't exist
Script line: 1645 Table 'trinityworld.gameobject_questrelation' doesn't exist
Script line: 1656 You have an error in your SQL syntax near 'COMMENT 'Global Unique Identifier',
`respawntime` bigint(20) NOT NULL DEFAULT' at line 2
Script line: 1669 Table 'trinityworld.gameobject_respawn' doesn't exist
Script line: 1681 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 1699 Table 'trinityworld.gameobject_scripts' doesn't exist
Script line: 1701 Table 'trinityworld.gameobject_scripts' doesn't exist
Script line: 1712 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'' at line 43
Script line: 1761 Table 'trinityworld.gameobject_template' doesn't exist
Script line: 1763 Table 'trinityworld.gameobject_template' doesn't exist
Script line: 1764 Table 'trinityworld.gameobject_template' doesn't exist
Script line: 1775 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 14
Script line: 1795 Table 'trinityworld.instance_template' doesn't exist
Script line: 1797 Table 'trinityworld.instance_template' doesn't exist
Script line: 1808 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchant' at line 6
Script line: 1820 Table 'trinityworld.item_enchantment_template' doesn't exist
Script line: 1822 Table 'trinityworld.item_enchantment_template' doesn't exist
Script line: 1833 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 1851 Table 'trinityworld.item_loot_template' doesn't exist
Script line: 1853 Table 'trinityworld.item_loot_template' doesn't exist
Script line: 1864 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED' at line 6
Script line: 1876 Table 'trinityworld.item_required_target' doesn't exist
Script line: 1878 Table 'trinityworld.item_required_target' doesn't exist
Script line: 1889 You have an error in your SQL syntax near 'COMMENT 'Duration in seconds. Negative value means realtime, postive value ingam' at line 130
Script line: 2036 Table 'trinityworld.item_template' doesn't exist
Script line: 2038 Table 'trinityworld.item_template' doesn't exist
Script line: 2039 Table 'trinityworld.item_template' doesn't exist
Script line: 2040 Table 'trinityworld.item_template' doesn't exist
Script line: 2041 Table 'trinityworld.item_template' doesn't exist
Script line: 2042 Table 'trinityworld.item_template' doesn't exist
Script line: 2043 Table 'trinityworld.item_template' doesn't exist
Script line: 2044 Table 'trinityworld.item_template' doesn't exist
Script line: 2045 Table 'trinityworld.item_template' doesn't exist
Script line: 2046 Table 'trinityworld.item_template' doesn't exist
Script line: 2047 Table 'trinityworld.item_template' doesn't exist
Script line: 2048 Table 'trinityworld.item_template' doesn't exist
Script line: 2059 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 20
Script line: 2085 Table 'trinityworld.locales_achievement_reward' doesn't exist
Script line: 2097 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 20
Script line: 2123 Table 'trinityworld.locales_creature' doesn't exist
Script line: 2135 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 20
Script line: 2161 Table 'trinityworld.locales_gameobject' doesn't exist
Script line: 2173 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 20
Script line: 2199 Table 'trinityworld.locales_item' doesn't exist
Script line: 2211 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 20
Script line: 2237 Table 'trinityworld.locales_npc_option' doesn't exist
Script line: 2249 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 132
Script line: 2387 Table 'trinityworld.locales_npc_text' doesn't exist
Script line: 2399 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 2417 Table 'trinityworld.locales_page_text' doesn't exist
Script line: 2429 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 2447 Table 'trinityworld.locales_points_of_interest' doesn't exist
Script line: 2459 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 84
Script line: 2549 Table 'trinityworld.locales_quest' doesn't exist
Script line: 2561 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 2579 Table 'trinityworld.milling_loot_template' doesn't exist
Script line: 2581 Table 'trinityworld.milling_loot_template' doesn't exist
Script line: 2592 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 2603 Table 'trinityworld.npc_gossip' doesn't exist
Script line: 2605 Table 'trinityworld.npc_gossip' doesn't exist
Script line: 2616 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 6
Script line: 2628 Table 'trinityworld.npc_gossip_textid' doesn't exist
Script line: 2640 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 2658 Table 'trinityworld.npc_option' doesn't exist
Script line: 2660 Table 'trinityworld.npc_option' doesn't exist
Script line: 2671 You have an error in your SQL syntax near 'COMMENT 'reference to creature_template',
`spell_id` int(10) unsigned NOT NUL' at line 2
Script line: 2688 Table 'trinityworld.npc_spellclick_spells' doesn't exist
Script line: 2690 Table 'trinityworld.npc_spellclick_spells' doesn't exist
Script line: 2701 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 84
Script line: 2791 Table 'trinityworld.npc_text' doesn't exist
Script line: 2793 Table 'trinityworld.npc_text' doesn't exist
Script line: 2794 Table 'trinityworld.npc_text' doesn't exist
Script line: 2795 Table 'trinityworld.npc_text' doesn't exist
Script line: 2806 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 9
Script line: 2821 Table 'trinityworld.npc_trainer' doesn't exist
Script line: 2823 Table 'trinityworld.npc_trainer' doesn't exist
Script line: 2824 Table 'trinityworld.npc_trainer' doesn't exist
Script line: 2835 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System'' at line 8
Script line: 2849 Table 'trinityworld.npc_vendor' doesn't exist
Script line: 2851 Table 'trinityworld.npc_vendor' doesn't exist
Script line: 2862 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System'' at line 6
Script line: 2874 Table 'trinityworld.page_text' doesn't exist
Script line: 2876 Table 'trinityworld.page_text' doesn't exist
Script line: 2887 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.' at line 13
Script line: 2906 Table 'trinityworld.pet_levelstats' doesn't exist
Script line: 2908 Table 'trinityworld.pet_levelstats' doesn't exist
Script line: 2919 You have an error in your SQL syntax near 'ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=utf8' at line 7
Script line: 2932 Table 'trinityworld.pet_name_generation' doesn't exist
Script line: 2934 Table 'trinityworld.pet_name_generation' doesn't exist
Script line: 2945 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 2963 Table 'trinityworld.pickpocketing_loot_template' doesn't exist
Script line: 2965 Table 'trinityworld.pickpocketing_loot_template' doesn't exist
Script line: 2976 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'' at line 7
Script line: 2989 Table 'trinityworld.player_classlevelstats' doesn't exist
Script line: 2991 Table 'trinityworld.player_classlevelstats' doesn't exist
Script line: 3002 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'' at line 11
Script line: 3019 Table 'trinityworld.player_levelstats' doesn't exist
Script line: 3021 Table 'trinityworld.player_levelstats' doesn't exist
Script line: 3032 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 3043 Table 'trinityworld.player_xp_for_level' doesn't exist
Script line: 3045 Table 'trinityworld.player_xp_for_level' doesn't exist
Script line: 3056 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 10
Script line: 3072 Table 'trinityworld.playercreateinfo' doesn't exist
Script line: 3074 Table 'trinityworld.playercreateinfo' doesn't exist
Script line: 3085 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 9
Script line: 3100 Table 'trinityworld.playercreateinfo_action' doesn't exist
Script line: 3102 Table 'trinityworld.playercreateinfo_action' doesn't exist
Script line: 3113 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 7
Script line: 3126 Table 'trinityworld.playercreateinfo_item' doesn't exist
Script line: 3138 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 7
Script line: 3151 Table 'trinityworld.playercreateinfo_spell' doesn't exist
Script line: 3153 Table 'trinityworld.playercreateinfo_spell' doesn't exist
Script line: 3164 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 8
Script line: 3178 Table 'trinityworld.playercreateinfo_spell_custom' doesn't exist
Script line: 3180 Table 'trinityworld.playercreateinfo_spell_custom' doesn't exist
Script line: 3191 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 10
Script line: 3207 Table 'trinityworld.points_of_interest' doesn't exist
Script line: 3209 Table 'trinityworld.points_of_interest' doesn't exist
Script line: 3220 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 9
Script line: 3235 Table 'trinityworld.pool_creature' doesn't exist
Script line: 3237 Table 'trinityworld.pool_creature' doesn't exist
Script line: 3248 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 8
Script line: 3262 Table 'trinityworld.pool_gameobject' doesn't exist
Script line: 3264 Table 'trinityworld.pool_gameobject' doesn't exist
Script line: 3275 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 7
Script line: 3288 Table 'trinityworld.pool_pool' doesn't exist
Script line: 3300 You have an error in your SQL syntax near 'COMMENT 'Pool entry',
`max_limit` int(10) unsigned NOT NULL DEFAULT '0' COMME' at line 2
Script line: 3313 Table 'trinityworld.pool_template' doesn't exist
Script line: 3315 Table 'trinityworld.pool_template' doesn't exist
Script line: 3326 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 3344 Table 'trinityworld.prospecting_loot_template' doesn't exist
Script line: 3346 Table 'trinityworld.prospecting_loot_template' doesn't exist
Script line: 3357 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 3375 Table 'trinityworld.quest_end_scripts' doesn't exist
Script line: 3377 Table 'trinityworld.quest_end_scripts' doesn't exist
Script line: 3388 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 3406 Table 'trinityworld.quest_mail_loot_template' doesn't exist
Script line: 3408 Table 'trinityworld.quest_mail_loot_template' doesn't exist
Script line: 3419 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 3437 Table 'trinityworld.quest_start_scripts' doesn't exist
Script line: 3439 Table 'trinityworld.quest_start_scripts' doesn't exist
Script line: 3450 You have an error in your SQL syntax near 'COMMENT 'faction id from Faction.dbc in this case',
`RewRepFaction2` smallint' at line 89
Script line: 3587 Table 'trinityworld.quest_template' doesn't exist
Script line: 3589 Table 'trinityworld.quest_template' doesn't exist
Script line: 3590 Table 'trinityworld.quest_template' doesn't exist
Script line: 3591 Table 'trinityworld.quest_template' doesn't exist
Script line: 3592 Table 'trinityworld.quest_template' doesn't exist
Script line: 3593 Table 'trinityworld.quest_template' doesn't exist
Script line: 3594 Table 'trinityworld.quest_template' doesn't exist
Script line: 3595 Table 'trinityworld.quest_template' doesn't exist
Script line: 3596 Table 'trinityworld.quest_template' doesn't exist
Script line: 3597 Table 'trinityworld.quest_template' doesn't exist
Script line: 3608 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 3626 Table 'trinityworld.reference_loot_template' doesn't exist
Script line: 3628 Table 'trinityworld.reference_loot_template' doesn't exist
Script line: 3639 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player Reserved N' at line 4
Script line: 3649 Table 'trinityworld.reserved_name' doesn't exist
Script line: 3661 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts'' at line 18
Script line: 3685 Table 'trinityworld.script_texts' doesn't exist
Script line: 3687 Table 'trinityworld.script_texts' doesn't exist
Script line: 3698 You have an error in your SQL syntax near 'COMMENT 'creature_template entry',
`pointid` mediumint(8) unsigned NOT NULL D' at line 2
Script line: 3714 Table 'trinityworld.script_waypoint' doesn't exist
Script line: 3716 Table 'trinityworld.script_waypoint' doesn't exist
Script line: 3727 You have an error in your SQL syntax near 'COMMENT 'SpellId of the discoverable spell',
`reqSpell` mediumint(8) unsigned' at line 2
Script line: 3740 Table 'trinityworld.skill_discovery_template' doesn't exist
Script line: 3742 Table 'trinityworld.skill_discovery_template' doesn't exist
Script line: 3753 You have an error in your SQL syntax near 'COMMENT 'SpellId of the item creation spell',
`requiredSpecialization` medium' at line 2
Script line: 3766 Table 'trinityworld.skill_extra_item_template' doesn't exist
Script line: 3768 Table 'trinityworld.skill_extra_item_template' doesn't exist
Script line: 3779 You have an error in your SQL syntax near 'COMMENT 'Area identifier',
`skill` smallint(6) NOT NULL DEFAULT '0' COMMENT '' at line 2
Script line: 3790 Table 'trinityworld.skill_fishing_base_level' doesn't exist
Script line: 3792 Table 'trinityworld.skill_fishing_base_level' doesn't exist
Script line: 3803 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 3821 Table 'trinityworld.skinning_loot_template' doesn't exist
Script line: 3823 Table 'trinityworld.skinning_loot_template' doesn't exist
Script line: 3834 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 3852 Table 'trinityworld.spell_area' doesn't exist
Script line: 3854 Table 'trinityworld.spell_area' doesn't exist
Script line: 3865 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 9
Script line: 3880 Table 'trinityworld.spell_bonus_data' doesn't exist
Script line: 3882 Table 'trinityworld.spell_bonus_data' doesn't exist
Script line: 3893 You have an error in your SQL syntax near 'COMMENT 'Spell entry',
`disable_mask` int(8) unsigned NOT NULL DEFAULT '0',
' at line 2
Script line: 3905 Table 'trinityworld.spell_disabled' doesn't exist
Script line: 3917 You have an error in your SQL syntax near 'COMMENT 'SpellId of potion',
`mask` tinyint(1) unsigned NOT NULL DEFAULT '0' ' at line 2
Script line: 3928 Table 'trinityworld.spell_elixir' doesn't exist
Script line: 3930 Table 'trinityworld.spell_elixir' doesn't exist
Script line: 3941 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant pro' at line 6
Script line: 3953 Table 'trinityworld.spell_enchant_proc_data' doesn't exist
Script line: 3955 Table 'trinityworld.spell_enchant_proc_data' doesn't exist
Script line: 3966 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'' at line 6
Script line: 3978 Table 'trinityworld.spell_learn_spell' doesn't exist
Script line: 3980 Table 'trinityworld.spell_learn_spell' doesn't exist
Script line: 3991 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spell System'' at line 7
Script line: 4004 Table 'trinityworld.spell_linked_spell' doesn't exist
Script line: 4006 Table 'trinityworld.spell_linked_spell' doesn't exist
Script line: 4017 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'' at line 12
Script line: 4035 Table 'trinityworld.spell_loot_template' doesn't exist
Script line: 4037 Table 'trinityworld.spell_loot_template' doesn't exist
Script line: 4048 You have an error in your SQL syntax near 'COMMENT 'dummy spell id',
`effectId` tinyint(3) unsigned NOT NULL DEFAULT '0'' at line 2
Script line: 4061 Table 'trinityworld.spell_pet_auras' doesn't exist
Script line: 4063 Table 'trinityworld.spell_pet_auras' doesn't exist
Script line: 4074 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 14
Script line: 4094 Table 'trinityworld.spell_proc_event' doesn't exist
Script line: 4096 Table 'trinityworld.spell_proc_event' doesn't exist
Script line: 4107 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 4118 Table 'trinityworld.spell_proc_item_enchant' doesn't exist
Script line: 4120 Table 'trinityworld.spell_proc_item_enchant' doesn't exist
Script line: 4131 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Dat' at line 5
Script line: 4142 Table 'trinityworld.spell_required' doesn't exist
Script line: 4144 Table 'trinityworld.spell_required' doesn't exist
Script line: 4155 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System'' at line 6
Script line: 4167 Table 'trinityworld.spell_script_target' doesn't exist
Script line: 4169 Table 'trinityworld.spell_script_target' doesn't exist
Script line: 4180 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 12
Script line: 4198 Table 'trinityworld.spell_scripts' doesn't exist
Script line: 4200 Table 'trinityworld.spell_scripts' doesn't exist
Script line: 4211 You have an error in your SQL syntax near 'COMMENT 'Identifier',
`target_map` smallint(5) unsigned NOT NULL DEFAULT '0',' at line 2
Script line: 4226 Table 'trinityworld.spell_target_position' doesn't exist
Script line: 4228 Table 'trinityworld.spell_target_position' doesn't exist
Script line: 4239 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED' at line 5
Script line: 4250 Table 'trinityworld.spell_threat' doesn't exist
Script line: 4252 Table 'trinityworld.spell_threat' doesn't exist
Script line: 4263 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5
Script line: 4274 Table 'trinityworld.transport_events' doesn't exist
Script line: 4286 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports'' at line 6
Script line: 4298 Table 'trinityworld.transports' doesn't exist
Script line: 4300 Table 'trinityworld.transports' doesn't exist
Script line: 4311 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 13
Script line: 4330 Table 'trinityworld.trinity_string' doesn't exist
Script line: 4332 Table 'trinityworld.trinity_string' doesn't exist
Script line: 4343 You have an error in your SQL syntax near 'COMMENT 'Core revision dumped at startup.',
`core_revision` bigint(20) unsign' at line 2
Script line: 4356 Table 'trinityworld.version' doesn't exist
Script line: 4358 Table 'trinityworld.version' doesn't exist
Script line: 4369 You have an error in your SQL syntax near 'COMMENT 'Creature GUID',
`point` mediumint(8) unsigned NOT NULL DEFAULT '0',
' at line 2
Script line: 4387 Table 'trinityworld.waypoint_data' doesn't exist
Script line: 4389 Table 'trinityworld.waypoint_data' doesn't exist
Script line: 4390 Table 'trinityworld.waypoint_data' doesn't exist
Script line: 4391 Table 'trinityworld.waypoint_data' doesn't exist
Script line: 4402 You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 14
Script line: 4422 Table 'trinityworld.waypoint_scripts' doesn't exist
Script line: 4424 Table 'trinityworld.waypoint_scripts' doesn't exist

Das ist ein Teil, es geht noch weiter .... Der Error Code ist 1146 und 1064

Wenn das nicht geht, dann geht auch nicht das Batchen von der Charakter.sql bei navicat, ebenfalls so ein langer text, ich nehme daher an das es was an der Datenbank ist. wo ich nicht zugreifen kann, Da bekomme ich unter xampp diesen Fehler :

SQL-Befehl: Bearbeiten

SET CHARACTER SET 'utf8';

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax near ''utf8'' at line 1

Wie kann ich diesen Beheben? ich bin sehr dankbar auf eure Antworten.

Liebe grüße Neorax

Antworten

#2 | RE: Problem bei der Datenbank und natürlich auch Charakter Batch problem datum

02.11.2009 23:41

Durch eine Neu installation von Xampp konnte ich das problem alleine beheben :)

Antworten

realmlist ändern � � [Suche] Core + DB für 3.1.3