Guten Abend,
und zwar habe Ich folgendes Problem. Wollte meine World und Characters Datenbank Updaten auf die 11802. Die es Aktuell bei GitHub zum Downloaden gibt. Die World Updates konnte Ich ohne einen einzigen Fehler einspielen und meine Alte World Datenbank aktualisieren. Bei der Charakters Datenbank kommen bei folgenden SQL-Dateien folgende Fehler und Ich weiß nicht mehr weiter…
Als MySQL Programm benutze Ich: Navicat for MySQL
2011_04_05_00_characters_arena_team_misc.sql
[CODE][Err] 1060 - Duplicate column name ‘rating’
[Err] – Update arena_team table
ALTER TABLE arena_team
CHANGE arenateamid
arenaTeamId
INT(10) UNSIGNED DEFAULT ‘0’ NOT NULL,
CHANGE captainguid
captainGuid
INT(10) UNSIGNED DEFAULT ‘0’ NOT NULL,
CHANGE BackgroundColor
backgroundColor
INT(10) UNSIGNED DEFAULT ‘0’ NOT NULL,
CHANGE EmblemStyle
emblemStyle
TINYINT(3) UNSIGNED DEFAULT ‘0’ NOT NULL,
CHANGE EmblemColor
emblemColor
INT(10) UNSIGNED DEFAULT ‘0’ NOT NULL,
CHANGE BorderStyle
borderStyle
TINYINT(3) UNSIGNED DEFAULT ‘0’ NOT NULL,
CHANGE BorderColor
borderColor
INT(10) UNSIGNED DEFAULT ‘0’ NOT NULL,
ADD COLUMN rating
SMALLINT(5) UNSIGNED NOT NULL AFTER type
,
ADD COLUMN seasonGames
SMALLINT(5) UNSIGNED DEFAULT ‘0’ NOT NULL AFTER rating
,
ADD COLUMN seasonWins
SMALLINT(5) UNSIGNED DEFAULT ‘0’ NOT NULL AFTER seasonGames
,
ADD COLUMN weekGames
SMALLINT(5) UNSIGNED DEFAULT ‘0’ NOT NULL AFTER seasonWins
,
ADD COLUMN weekWins
SMALLINT(5) UNSIGNED DEFAULT ‘0’ NOT NULL AFTER weekGames
,
ADD COLUMN rank
INT(10) UNSIGNED NOT NULL AFTER weekWins
;
[Msg] Finished - Unsuccessfully
--------------------------------------------------[/CODE]
2011_04_08_00_characters_battleground_data.sql
[CODE][Err] 1054 - Unknown column ‘instance_id’ in ‘character_battleground_data’
[Err] ALTER TABLE character_battleground_data
CHANGE `instance_id` `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier',
CHANGE `join_map` `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
CHANGE `join_x` `joinX` float NOT NULL DEFAULT '0',
CHANGE `join_y` `joinY` float NOT NULL DEFAULT '0',
CHANGE `join_z` `joinZ` float NOT NULL DEFAULT '0',
CHANGE `join_o` `joinO` float NOT NULL DEFAULT '0',
CHANGE `taxi_start` `taxiStart` int(10) unsigned NOT NULL DEFAULT '0',
CHANGE `taxi_end` `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0',
CHANGE `mount_spell` `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0';
[Msg] Finished - Unsuccessfully
--------------------------------------------------[/CODE]
2011_04_08_01_characters_character_homebind.sql
[CODE][Err] 1054 - Unknown column ‘map’ in ‘character_homebind’
[Err] ALTER TABLE character_homebind
CHANGE `map` `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
CHANGE `zone` `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
CHANGE `position_x` `posX` float NOT NULL DEFAULT '0',
CHANGE `position_y` `posY` float NOT NULL DEFAULT '0',
CHANGE `position_z` `posZ` float NOT NULL DEFAULT '0';
[Msg] Finished - Unsuccessfully
[/CODE]
2011_04_08_03_characters_arena_team_member.sql
[CODE][Err] 1054 - Unknown column ‘character_arena_stats.personalRating’ in ‘field list’
[Err] UPDATE arena_team_member
INNER JOIN character_arena_stats ON arena_team_member.guid = character_arena_stats.guid
INNER JOIN arena_team ON arena_team.arenaTeamId = arena_team_member.arenaTeamId AND (slot = 0 AND TYPE = 2 OR slot = 1 AND TYPE = 3 OR slot = 2 AND TYPE = 5)
SET arena_team_member.personalRating = character_arena_stats.personalRating;
[Msg] Finished - Unsuccessfully
--------------------------------------------------[/CODE]
Die anderen SQL-Dateien kann ich Ohne Fehler einspielen. Testweise habe Ich mal die worldserver.exe und authserver.exe gestartet und die Core läuft trotz dieser einspielfehler bei der Charakters Datenbank. Zwar ist mir in der DBErrors.log aufgefallen das es einige Probleme mit der creature_template beziehungsweise creature_equip_template Tabelle gibt:
[CODE]2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33473) with equipment_id
1903 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33476) with equipment_id
1904 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37578) with equipment_id
2442 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33383) with equipment_id
1897 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33538) with equipment_id
1905 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33541) with equipment_id
1906 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37125) with equipment_id
2450 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33543) with equipment_id
1907 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37129) with equipment_id
1924 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37134) with equipment_id
2446 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 786) with equipment_id
1999 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33558) with equipment_id
1908 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33559) with equipment_id
1909 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33564) with equipment_id
1912 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37670) with equipment_id
2440 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33588) with equipment_id
1913 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33639) with equipment_id
1971 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33285) with equipment_id
1890 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33312) with equipment_id
1967 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33355) with equipment_id
1853 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33384) with equipment_id
1898 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33417) with equipment_id
1900 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33438) with equipment_id
1901 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37577) with equipment_id
2441 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33561) with equipment_id
1910 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33562) with equipment_id
1911 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 813) with equipment_id
1998 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33592) with equipment_id
1969 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33641) with equipment_id
1947 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33643) with equipment_id
1914 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33678) with equipment_id
1972 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33683) with equipment_id
1973 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 947) with equipment_id
1997 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33744) with equipment_id
1919 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33745) with equipment_id
1920 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33746) with equipment_id
1921 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33747) with equipment_id
1922 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33748) with equipment_id
1897 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33749) with equipment_id
1923 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33780) with equipment_id
1925 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33785) with equipment_id
1926 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33972) with equipment_id
1927 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33973) with equipment_id
1927 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33974) with equipment_id
1927 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38131) with equipment_id
2446 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34078) with equipment_id
2465 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34090) with equipment_id
1974 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34179) with equipment_id
1915 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34728) with equipment_id
1930 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34771) with equipment_id
1932 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34780) with equipment_id
1975 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34789) with equipment_id
1933 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34880) with equipment_id
1936 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34919) with equipment_id
1976 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34955) with equipment_id
1937 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34976) with equipment_id
1977 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34999) with equipment_id
1978 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35001) with equipment_id
1938 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35002) with equipment_id
1979 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35008) with equipment_id
1938 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35020) with equipment_id
1937 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35022) with equipment_id
1977 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35072) with equipment_id
1939 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35113) with equipment_id
1940 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35216) with equipment_id
1975 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35268) with equipment_id
1975 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35269) with equipment_id
1975 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35318) with equipment_id
1941 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35319) with equipment_id
1942 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35321) with equipment_id
1943 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35364) with equipment_id
1944 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35365) with equipment_id
1944 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35444) with equipment_id
1926 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35472) with equipment_id
1933 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35476) with equipment_id
1980 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35483) with equipment_id
1933 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35494) with equipment_id
1981 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35495) with equipment_id
1982 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35499) with equipment_id
1933 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35508) with equipment_id
1951 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35573) with equipment_id
1981 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 2805) with equipment_id
1999 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35574) with equipment_id
1982 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35576) with equipment_id
1983 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35578) with equipment_id
1984 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35580) with equipment_id
1985 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35587) with equipment_id
1986 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36119) with equipment_id
1987 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36120) with equipment_id
1988 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36121) with equipment_id
1989 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36124) with equipment_id
1990 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36656) with equipment_id
1914 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36892) with equipment_id
2444 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37034) with equipment_id
2452 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37123) with equipment_id
2448 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37124) with equipment_id
2449 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37146) with equipment_id
2453 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37496) with equipment_id
2455 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38000) with equipment_id
1924 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38487) with equipment_id
2443 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38492) with equipment_id
2445 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 39675) with equipment_id
2464 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40184) with equipment_id
2458 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40253) with equipment_id
2459 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40352) with equipment_id
2463 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40374) with equipment_id
2463 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40391) with equipment_id
2462 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 12496) with equipment_id
1999 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 13438) with equipment_id
1881 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 13443) with equipment_id
1882 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 13447) with equipment_id
1883 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 13777) with equipment_id
1883 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 15062) with equipment_id
1945 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 15089) with equipment_id
1945 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 16694) with equipment_id
1938 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 17252) with equipment_id
2455 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 18705) with equipment_id
1946 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 18712) with equipment_id
1947 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 20031) with equipment_id
1932 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 20416) with equipment_id
1983 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 21336) with equipment_id
1948 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 21368) with equipment_id
1949 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 22861) with equipment_id
1864 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33335) with equipment_id
1993 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33468) with equipment_id
1902 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33762) with equipment_id
1924 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34808) with equipment_id
1935 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34987) with equipment_id
1978 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35458) with equipment_id
1980 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 35575) with equipment_id
1936 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37029) with equipment_id
2454 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25572) with equipment_id
1951 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 18697) with equipment_id
2457 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 22541) with equipment_id
1882 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 22698) with equipment_id
1881 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 22735) with equipment_id
1883 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40392) with equipment_id
2460 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25196) with equipment_id
1958 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24686) with equipment_id
1951 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25976) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 26253) with equipment_id
1963 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25170) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25063) with equipment_id
1956 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25003) with equipment_id
1953 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24976) with equipment_id
1950 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24966) with equipment_id
1957 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24978) with equipment_id
1951 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24979) with equipment_id
1952 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25977) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25132) with equipment_id
1952 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33306) with equipment_id
1891 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33382) with equipment_id
1896 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24918) with equipment_id
1983 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24919) with equipment_id
1953 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 24955) with equipment_id
1983 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25035) with equipment_id
1954 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25037) with equipment_id
1955 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25069) with equipment_id
1957 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25486) with equipment_id
1988 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 26089) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 26090) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 26091) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 26092) with equipment_id
1962 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 27893) with equipment_id
1888 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25243) with equipment_id
1959 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25276) with equipment_id
1960 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 25328) with equipment_id
1961 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 28801) with equipment_id
1964 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 29937) with equipment_id
1889 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 31216) with equipment_id
1965 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 31321) with equipment_id
1834 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 31824) with equipment_id
1881 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 31960) with equipment_id
1883 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 31965) with equipment_id
1882 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33225) with equipment_id
1966 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33361) with equipment_id
1892 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33403) with equipment_id
1899 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33593) with equipment_id
1970 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33738) with equipment_id
1916 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33739) with equipment_id
1917 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33740) with equipment_id
1918 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 33743) with equipment_id
1912 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34127) with equipment_id
1928 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34794) with equipment_id
1934 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 34734) with equipment_id
1931 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 36657) with equipment_id
1907 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37149) with equipment_id
2451 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 37122) with equipment_id
2447 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38298) with equipment_id
2447 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38299) with equipment_id
2448 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38303) with equipment_id
2449 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 38304) with equipment_id
2450 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 39371) with equipment_id
1943 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40419) with equipment_id
1905 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 39368) with equipment_id
2464 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40416) with equipment_id
2461 not found in table creature_equip_template
, set to no equipment.
2011-04-30 22:30:50 Table creature_template
lists creature (Entry: 40420) with equipment_id
1905 not found in table creature_equip_template
, set to no equipment.[/CODE]
Ich hoffe das Ihr mir bei meinen Fehlern mit denn Arena SQL-Dateien weiterhelfen könnt. Mit dem creature_template Problem habe Ich schon einige Themen und Posts gefunden wie
http://www.trinitycore.org/f/index.php?/topic/2743-starting-worldserver-db-errors/page__p__16336__hl__creature_template__fromsearch__1#entry16336
http://www.trinitycore.org/f/index.php?/topic/2737-database-problem/
Dort Steht das man alle World Updates in sql\updates\world einspielen soll, aber das habe ich gemacht und Ich wollte jetzt noch nicht auf diese Themen posten, da mein Englisch etwas schlecht ist.
Mit freundlichen Grüßen
BerndeDGF