Problem nach Update

Hey Leute,

habe vorhin die neuen Updates eingespielt. Bekomme nun beim starten der World folgenden Fehler:

MySQL server ver: 5.0.51a-24+lenny5MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-24+lenny5

Databasepool opened succesfuly. 2 total connections running.

Opening databasepool ‘characters’. Async threads: 1, synch threads: 2

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-24+lenny5

[ERROR]: In mysql_stmt_prepare() id: 173, sql: “DELETE FROM game_event_save WHERE eventEntry = ?”

[ERROR]: Unknown column ‘eventEntry’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 174, sql: “INSERT INTO game_event_save (eventEntry, state, next_start) VALUES (?, ? , ?)”

[ERROR]: Unknown column ‘eventEntry’ in ‘field list’

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-24+lenny5

MySQL client library: 5.0.51a

MySQL server ver: 5.0.51a-24+lenny5

Databasepool opened succesfuly. 3 total connections running.

Cannot connect to Character database localhost;3306;trinity;WDSUQLlfQgqF;characters

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘characters’.

~DatabaseWorkerPool for ‘world’.

Ich weiß nicht weiter ! Hat wer ne Idee ?

lg Syoss

Dir fehlen die game_event* Updates

Danke. Hatte die eigebtlich mit eingebatch. Habe dann die Tabellen manuell verändert !

lg Syoss

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

Ich würde einfach mal behaupten, dass du entweder die Reihenfolge nicht korrekt einhällst, oder aber Patches vergessen hast, bzw doppelt ausgeführt hast.

Hallo Micha,

Ich habe alle Patches vom Ordner updates/auth_char eingespielt. Und zwar beginnent mit 2011_04_05_00 bist 2011_04_23_01 der Reihe nach. Und bei den Oben genannten SQL-Dateien kommt ein Error. Brauche Ich noch Updates vor dem April? Sprich Charakters Updates vom März?

Ich habe jetzt noch folgende Varianten Probiert:

→ 1. Ich hab vom Ordner sql/base die characters_database.sql eingespielt und anschließend vom Updates Ordner die characters.srq Dateien der Reihe nach eingespielt und es kommt wieder ein Error bei den gleichen SQL-Dateien.

characters_database.sql

[CODE][Msg] Finished - 686 queries executed successfully


[/CODE]

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_06_00_characters_arena_team_member.sql

[CODE][Msg] Finished - 2 queries executed successfully


[/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_02_characters_arena_team.sql

[CODE][Msg] Finished - 2 queries executed successfully


[/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]

2011_04_11_00_characters_corpse.sql

[CODE][Err] 1054 - Unknown column ‘player’ in ‘corpse’

[Err] ALTER TABLE corpse

CHANGE `guid` `corpseGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',

CHANGE `player` `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',

CHANGE `map` `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map 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',

CHANGE `guild` `guildId` int(10) unsigned NOT NULL DEFAULT '0',

CHANGE `corpse_type` `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',

CHANGE `instance` `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier';

[Msg] Finished - Unsuccessfully


[/CODE]

2011_04_13_00_characters_creature_respawn.sql

[CODE][Err] 1054 - Unknown column ‘instance’ in ‘creature_respawn’

[Err] ALTER TABLE creature_respawn

CHANGE `respawntime` `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',

CHANGE `instance` `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier';

[Msg] Finished - Unsuccessfully

--------------------------------------------------[/CODE]

2011_04_13_01_characters_gameobject_respawn.sql

[CODE][Err] 1054 - Unknown column ‘instance’ in ‘gameobject_respawn’

[Err] ALTER TABLE gameobject_respawn

CHANGE `respawntime` `respawnTime` int(10) unsigned NOT NULL DEFAULT '0',

CHANGE `instance` `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier';

[Msg] Finished - Unsuccessfully

--------------------------------------------------[/CODE]

2011_04_14_00_characters.sql

[CODE][Err] 1091 - Can’t DROP ‘instance’; check that column/key exists

[Err] ALTER TABLE corpse

DROP PRIMARY KEY,

DROP KEY `idx_type`,

DROP KEY `instance`,

DROP KEY `Idx_player`,

DROP KEY `Idx_time`;

[Msg] Finished - Unsuccessfully

--------------------------------------------------[/CODE]

2011_04_15_00_characters_characters.sql

[CODE][Msg] Finished - 2 queries executed successfully

--------------------------------------------------[/CODE]

2011_04_19_00_characters.sql

[CODE][Err] 1054 - Unknown column ‘player’ in ‘gm_surveys’

[Err] ALTER TABLE gm_surveys

CHANGE `surveyid` `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,

CHANGE `player` `guid` int(10) unsigned NOT NULL DEFAULT '0',

CHANGE `overall_comment` `overallComment` longtext NOT NULL,

CHANGE `timestamp` `createTime` int(10) unsigned NOT NULL DEFAULT '0';

[Msg] Finished - Unsuccessfully

--------------------------------------------------[/CODE]

2011_04_23_00_characters_corpse.sql

[CODE][Msg] Finished - 2 queries executed successfully

--------------------------------------------------[/CODE]

2011_04_23_01_characters_character_banned.sql

[CODE][Msg] Finished - 2 queries executed successfully


[/CODE]

Normalerweiße müsste es doch mit einer Original Datenbank von Trinit funktionieren?

→ 2. Von GitHub habe Ich mir die TDB_335.11.39_2011_04_02 heruntergeladen und von dort die characters_2011_03_05_2011_04_02.sql Datei auf eine Leere characters Tabelle eingespielt und es kommen folgende Errors:

[CODE][Err] 1146 - Table ‘characters.channels’ doesn’t exist

[Err] – 2011_03_11_00_characters_channels.sql

ALTER TABLE channels CHANGE COLUMN m_name name varchar(128) NOT NULL,

CHANGE COLUMN m_team team int(10) unsigned NOT NULL,

CHANGE COLUMN m_announce announce tinyint(3) unsigned NOT NULL DEFAULT ‘1’,

CHANGE COLUMN m_ownership ownership tinyint(3) unsigned NOT NULL DEFAULT ‘1’,

CHANGE COLUMN m_password password varchar(32) DEFAULT NULL,

CHANGE COLUMN BannedList bannedList text,

CHANGE COLUMN last_used lastUsed int(10) unsigned NOT NULL;

[Msg] Finished - Unsuccessfully


[/CODE]

→ 3. Jetzt habe Ich nochmal von der Aktuellen TrinityCore im Ordner sql\base die characters_database.sql eingespielt und anschließend versucht die characters_2011_03_05_2011_04_02.sql von TDB_335.11.39_2011_04_02 einzubatchen aber es kommt wieder ein Error.

[CODE][Err] 1054 - Unknown column ‘m_name’ in ‘channels’

[Err] – 2011_03_11_00_characters_channels.sql

ALTER TABLE channels CHANGE COLUMN m_name name varchar(128) NOT NULL,

CHANGE COLUMN m_team team int(10) unsigned NOT NULL,

CHANGE COLUMN m_announce announce tinyint(3) unsigned NOT NULL DEFAULT ‘1’,

CHANGE COLUMN m_ownership ownership tinyint(3) unsigned NOT NULL DEFAULT ‘1’,

CHANGE COLUMN m_password password varchar(32) DEFAULT NULL,

CHANGE COLUMN BannedList bannedList text,

CHANGE COLUMN last_used lastUsed int(10) unsigned NOT NULL;

[Msg] Finished - Unsuccessfully


[/CODE]

Ich weiß echt nicht mehr weiter. Normal müsste es doch einspielen gehen, wenn Ich alle SQL-Dateien von der Aktuellen Trinity Core hernehme…

Mit freundlichen Grüßen


BerndeDGF

Hab mir jetzt nicht alles durchgelesen, aber ein typischer Fehler ist es die character_XXX SQL einzuspielen, obwohl das neueste world_update Packet eingespielt wurde.

Daher brauchst du diese Updates nicht. Wenn du dir die SQL-Files nämlich anschaust wirst du festellen, das all diese änderungen die das SQL-File machen will bereits gemacht wurden.

Hoffe das hilft dir weiter

Grüsse Player

Hallo Player321,

aber was ist dann mit denn Fehlern wie

[Err] 1054 - Unknown column

Jetzt ist aber folgendes Problem aufgetretten, beim Starten der worldserver.exe kommt er bis Load Items… und dann Crasht der Worldserver. Ab und zu lädt die worldserver.exe komplett alles und als der Worldserver dann Online ist Crasht dieser. Das nächste mal startet kommt er wieder nur bis Load Items… und nicht weiter…

Ich habe bereits ein Trinity Ticket aufgegeben, aber vll. wisst Ihr dazu ja auch schon was und hier wäre es ja Deutsch /emoticons/default_wink.png http://www.trinitycore.org/t/trinitycore/ticket/1345

Ich hab euch einmal die Crash txt Files mit hochgeladen.

Mit freundlichen Grüßen


Bernde

Archive_worldserver.exe_1-5_15-12-16.txt

Archive_worldserver.exe_1-5_15-12-40.txt

Hallo evtl. hast du dir mittlerweile die Datenbank “kaputtgebatcht”, hab ich mal bei nem Kumpel gesehen. Er hat dassebe wie du probiert und ein teil der SQL-Files wurde ausgeführt,

der andere Teil nicht. Danach hatte er auch diverse Fehler/Crashs.

Ich würds mal ebben mit einer komplett neuen Datenbank probieren. Zumindest die characters db neumachen.

Grüsse Player

Characters, World und Realmd neu gemacht und selber Crash bei Loading Items…

Funktioniert bei jemandem die Neue Core die man sich gerade herunterladen kann?? /emoticons/default_huh.png

Finito!

trinity@lvps178-77-101-79:~$ screen -AmdS auth ./authserver

trinity@lvps178-77-101-79:~$ screen -AmdS world ./worldserver

tut sich nix

Das sich nichts tut liegt daran, dass du nicht sehen kannst, was im screen passiert.

Mach mal top -u USERNAME

Das Username entspricht dem Usernamen in Linux, den du derzeit verwendest. Bist du nach dem Trinity Tutorial gegangen, sollte es wow sein. Also top -u wow

Dort kannst du sehen, ob ein Prozess (in Linux deamon) läuft, der authserver und worldserver heißt. Wenn dem so ist, solltest du die erst einmal killen. Dazu, wenn du in diesem top bist, drückst du “k” und dann die Zahl, die am Anfang der Zeile vor dem Deamon steht. Hast du nichts mehr laufen, was authserver oder worldserver heißt, kannst du das Top mit “q” wieder verlassen. Geh nun in den Ordner bin. Wenn du dort bist, machst du “./worldserver” und schaust, ob ohne Fehler gestartet wird. Läuft das bis zum Ende durch und bringt keinen Fehler, machst du STRG+C und anschließend “./authserver” und schaust dort ebenfalls, ob Fehler passieren oder nicht.

Gibts einen Fehler, kannst du dich hier wieder melden. Gibts keinen Fehler, kannst du wieder wie oben beschrieben im screen starten.

/home/trinity/server/etc/worldserver.conf

Verify that the file exists and has ‘[worldserver]’ written in the top of the file!

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘’.

kommt wenn ich ./worldserver eingebe

trinity@lvps178-77-101-79:~/TrinityCore/server/bin$ ./worldserver

Invalid or missing configuration file : /home/trinity/server/etc/worldserver.conf

Verify that the file exists and has ‘[worldserver]’ written in the top of the file!

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘’.

trinity@lvps178-77-101-79:~/TrinityCore/server/bin$ ./authserver

Invalid or missing configuration file : /home/trinity/server/etc/authserver.conf

Verify that the file exists and has ‘[authserver]’ written in the top of the file!

~DatabaseWorkerPool for ‘’.

trinity@lvps178-77-101-79:~/TrinityCore/server/bin$

Du solltest ja einen Ordner mit Namen “etc” haben. Dort sind zwei Dateien drin die mit .dist enden. Die musst du umbenennen und das .dist am Ende raus nehmen.

hab ich bereits

/home/trinity/TrinityCore/server/etc

authserver.conf

worldserver.conf

habs hingekriegt

ntEntry, state, next_start) VALUES (?, ? , ?)"

[ERROR]: Unknown column ‘eventEntry’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 165, sql: “DELETE FROM game_event_condition_save WHERE eventEntry = ?”

[ERROR]: Unknown column ‘eventEntry’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 166, sql: “DELETE FROM game_event_condition_save WHERE eventEntry = ? AND condition_id = ?”

[ERROR]: Unknown column ‘eventEntry’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 167, sql: “INSERT INTO game_event_condition_save (eventEntry, condition_id, done) VALUES (?, ?, ?)”

[ERROR]: Unknown column ‘eventEntry’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 168, sql: “INSERT INTO arena_team (arenaTeamId, name, captainGuid, type, rating, backgroundColor, emblemStyle, emblemColor, borderStyle, borderColor) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”

[ERROR]: Unknown column ‘rating’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 174, sql: “UPDATE arena_team SET rating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ?, rank = ? WHERE arenaTeamId = ?”

[ERROR]: Unknown column ‘rating’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 175, sql: “UPDATE arena_team_member SET personalRating = ?, weekGames = ?, weekWins = ?, seasonGames = ?, seasonWins = ? WHERE arenaTeamId = ? AND guid = ?”

[ERROR]: Unknown column ‘personalRating’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 176, sql: “REPLACE INTO character_arena_stats (guid, slot, matchMakerRating) VALUES (?, ?, ?)”

[ERROR]: Unknown column ‘matchMakerRating’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 180, sql: “INSERT INTO character_battleground_data (guid, instanceId, team, joinX, joinY, joinZ, joinO, joinMapId, taxiStart, taxiEnd, mountSpell) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 183, sql: “INSERT INTO character_homebind (guid, mapId, zoneId, posX, posY, posZ) VALUES (?, ?, ?, ?, ?, ?)”

[ERROR]: Unknown column ‘mapId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 184, sql: “UPDATE character_homebind SET mapId = ?, zoneId = ?, posX = ?, posY = ?, posZ = ? WHERE guid = ?”

[ERROR]: Unknown column ‘mapId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 187, sql: “INSERT INTO corpse (corpseGuid, guid, posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”

[ERROR]: Unknown column ‘corpseGuid’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 188, sql: “DELETE FROM corpse WHERE corpseGuid = ?”

[ERROR]: Unknown column ‘corpseGuid’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 189, sql: “DELETE FROM corpse WHERE guid = ? AND corpseType <> 0”

[ERROR]: Unknown column ‘corpseType’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 190, sql: “DELETE FROM corpse WHERE corpseType = 0 OR time < (UNIX_TIMESTAMP(NOW()) - ?)”

[ERROR]: Unknown column ‘corpseType’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 193, sql: “REPLACE INTO creature_respawn (guid, respawnTime, instanceId) VALUES (?, ?, ?)”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 194, sql: “DELETE FROM creature_respawn WHERE guid = ? AND instanceId = ?”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 196, sql: “DELETE FROM creature_respawn WHERE instanceId = ?”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 200, sql: “REPLACE INTO gameobject_respawn (guid, respawnTime, instanceId) VALUES (?, ?, ?)”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 201, sql: “DELETE FROM gameobject_respawn WHERE guid = ? AND instanceId = ?”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 202, sql: “DELETE FROM gameobject_respawn WHERE instanceId = ?”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 206, sql: “REPLACE INTO gm_tickets (ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)”

[ERROR]: Unknown column ‘ticketId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 207, sql: “DELETE FROM gm_tickets WHERE ticketId = ?”

[ERROR]: Unknown column ‘ticketId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 209, sql: “INSERT INTO gm_surveys (guid, surveyId, mainSurvey, overallComment, createTime) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP(NOW()))”

[ERROR]: Unknown column ‘guid’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 211, sql: “INSERT INTO lag_reports (guid, lagType, mapId, posX, posY, posZ) VALUES (?, ?, ?, ?, ?, ?)”

[ERROR]: Unknown column ‘guid’ in ‘field list’

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-3

[ERROR]: In mysql_stmt_prepare() id: 4, sql: “SELECT guid FROM characters WHERE name = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 11, sql: “SELECT guid, name FROM characters WHERE name LIKE CONCAT(‘%’, ?, ‘%’)”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 13, sql: “SELECT characters.name FROM characters, character_banned WHERE character_banned.guid = ? AND character_banned.guid = characters.guid”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 72, sql: “SELECT account FROM characters WHERE name = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 75, sql: “SELECT name, class FROM characters WHERE guid = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 76, sql: “SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?”

[ERROR]: Unknown column ‘matchMakerRating’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 138, sql: “SELECT name, level, class, zone, account FROM characters WHERE guid = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 139, sql: “SELECT announce, ownership, password, bannedList FROM channels WHERE name = ? AND team = ?”

[ERROR]: Unknown column ‘announce’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 150, sql: “SELECT type, time, data FROM account_data WHERE accountId = ?”

[ERROR]: Unknown column ‘accountId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 156, sql: “SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial WHERE accountId = ?”

[ERROR]: Table ‘characters.account_tutorial’ doesn’t exist

[ERROR]: In mysql_stmt_prepare() id: 157, sql: “SELECT 1 FROM account_tutorial WHERE accountId = ?”

[ERROR]: Table ‘characters.account_tutorial’ doesn’t exist

[ERROR]: In mysql_stmt_prepare() id: 182, sql: “UPDATE character_battleground_data SET instanceId = 0”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 186, sql: “SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseType <> 0”

[ERROR]: Unknown column ‘posX’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 191, sql: “UPDATE corpse SET instanceId = 0 WHERE instanceId > 0 AND instanceId NOT IN (SELECT id FROM instance)”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 192, sql: “SELECT guid, respawnTime, instanceId FROM creature_respawn”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 197, sql: “SELECT MAX(respawnTime), instanceId FROM creature_respawn WHERE instanceId > 0 GROUP BY instanceId”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 198, sql: “DELETE FROM creature_respawn WHERE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 199, sql: “SELECT guid, respawnTime, instanceId FROM gameobject_respawn”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 204, sql: “DELETE FROM gameobject_respawn WHERE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 205, sql: “SELECT ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed FROM gm_tickets”

[ERROR]: Unknown column ‘ticketId’ in ‘field list’

MySQL client library: 5.1.49

MySQL server ver: 5.1.49-3

[ERROR]: In mysql_stmt_prepare() id: 4, sql: “SELECT guid FROM characters WHERE name = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 11, sql: “SELECT guid, name FROM characters WHERE name LIKE CONCAT(‘%’, ?, ‘%’)”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 13, sql: “SELECT characters.name FROM characters, character_banned WHERE character_banned.guid = ? AND character_banned.guid = characters.guid”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 72, sql: “SELECT account FROM characters WHERE name = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 75, sql: “SELECT name, class FROM characters WHERE guid = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 76, sql: “SELECT matchMakerRating FROM character_arena_stats WHERE guid = ? AND slot = ?”

[ERROR]: Unknown column ‘matchMakerRating’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 138, sql: “SELECT name, level, class, zone, account FROM characters WHERE guid = ?”

[ERROR]: Can’t find file: ‘characters’ (errno: 2)

[ERROR]: In mysql_stmt_prepare() id: 139, sql: “SELECT announce, ownership, password, bannedList FROM channels WHERE name = ? AND team = ?”

[ERROR]: Unknown column ‘announce’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 150, sql: “SELECT type, time, data FROM account_data WHERE accountId = ?”

[ERROR]: Unknown column ‘accountId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 156, sql: “SELECT tut0, tut1, tut2, tut3, tut4, tut5, tut6, tut7 FROM account_tutorial WHERE accountId = ?”

[ERROR]: Table ‘characters.account_tutorial’ doesn’t exist

[ERROR]: In mysql_stmt_prepare() id: 157, sql: “SELECT 1 FROM account_tutorial WHERE accountId = ?”

[ERROR]: Table ‘characters.account_tutorial’ doesn’t exist

[ERROR]: In mysql_stmt_prepare() id: 182, sql: “UPDATE character_battleground_data SET instanceId = 0”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 186, sql: “SELECT posX, posY, posZ, orientation, mapId, displayId, itemCache, bytes1, bytes2, guildId, flags, dynFlags, time, corpseType, instanceId, phaseMask, corpseGuid, guid FROM corpse WHERE corpseType <> 0”

[ERROR]: Unknown column ‘posX’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 191, sql: “UPDATE corpse SET instanceId = 0 WHERE instanceId > 0 AND instanceId NOT IN (SELECT id FROM instance)”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 192, sql: “SELECT guid, respawnTime, instanceId FROM creature_respawn”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 197, sql: “SELECT MAX(respawnTime), instanceId FROM creature_respawn WHERE instanceId > 0 GROUP BY instanceId”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 198, sql: “DELETE FROM creature_respawn WHERE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 199, sql: “SELECT guid, respawnTime, instanceId FROM gameobject_respawn”

[ERROR]: Unknown column ‘instanceId’ in ‘field list’

[ERROR]: In mysql_stmt_prepare() id: 204, sql: “DELETE FROM gameobject_respawn WHERE instanceId > 0 AND instanceId NOT IN (SELECT instanceId FROM instance)”

[ERROR]: Unknown column ‘instanceId’ in ‘where clause’

[ERROR]: In mysql_stmt_prepare() id: 205, sql: “SELECT ticketId, guid, name, message, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, completed, escalated, viewed FROM gm_tickets”

[ERROR]: Unknown column ‘ticketId’ in ‘field list’

Databasepool opened succesfuly. 3 total connections running.

Cannot connect to Character database 127.0.0.1;3306;test;test;characters

~DatabaseWorkerPool for ‘’.

~DatabaseWorkerPool for ‘characters’.

~DatabaseWorkerPool for ‘world’.

Hast du irgendwelche Datenbanken erstellt? Wenn nicht, dann schau dir den Teil im wiki nochmal an.