Архив - только для чтения | |
| Модератор форума: andycrowz |
| Форум Корзина форума Корзина [compiled by Alo win32] (Core: 10344 + SD2: 1759 + Patches End Revision) |
| [compiled by Alo win32] |
вот смотри
DBErrors.log [cut] 2010-11-25 20:57:39 SQL: SELECT required_10342_02_mangos_command FROM db_version LIMIT 1 2010-11-25 20:57:39 query ERROR: Unknown column 'required_10342_02_mangos_command' in 'field list' 2010-11-25 20:57:39 The table `db_version` in your [WORLD] database indicates that this database is out of date! 2010-11-25 20:57:39 2010-11-25 20:57:39 [A] You have: --> `10148_01_mangos_mangos_string.sql` 2010-11-25 20:57:39 2010-11-25 20:57:39 [B] You need: --> `10342_02_mangos_command.sql` 2010-11-25 20:57:39 2010-11-25 20:57:39 You must apply all updates after [A] to [B] to use mangos with this database. 2010-11-25 20:57:39 These updates are included in the sql/updates folder. 2010-11-25 20:57:39 Please read the included [README] in sql/updates for instructions on updating. [/cut] MM MMM 2010-11-25 20:57:39 Using configuration file mangosd.conf. [/cut] 
Сообщение # 122 написано 25.11.2010 в 16:58
|
Klvirus, начинай заливать из папки sql/updates все после 10148_01_mangos_mangos_string.sql, в архиве почему-то sql не хватает, но эт не страшно
 YTDB поставишь на эту ревизию ядра и будет тебе счастья ща скажу какую реву YTDB после апдейтов накатывать Добавлено (25.11.2010, 17:07)
Сообщение # 123 написано 25.11.2010 в 17:07
|
Klvirus, ты смотри по названию что куда заливать
вот к примеру 10148_01_mangos_mangos_string.sql в базу mangos заливать а если будет написано characters, realmd или scriptdev2 то это уже в соответсвующую базу... из-за этого ошбики могут быть
Сообщение # 125 написано 25.11.2010 в 17:10
|
AlO,
[cut] There was an error while executing a query. The query and the error message has been logged at: C:\Documents and Settings\Admin\Application Data\SQLyog\sqlyog.err. Please click on "Open Error File..." to open the error file.[/cut] Добавлено (25.11.2010, 17:15)
Сообщение # 128 написано 25.11.2010 в 17:15
|
AlO,
[cut] [Err] 1054 - Unknown column 'required_10171_01_mangos_mangos_string' in 'db_version' [Err] ALTER TABLE db_version CHANGE COLUMN required_10171_01_mangos_mangos_string required_10197_01_mangos_playercreateinfo bit; [Msg] Finished - Unsuccessfully -------------------------------------------------- [/cut]
Сообщение # 130 написано 25.11.2010 в 17:19
|
залей тогда это в базу
Code ALTER TABLE db_version CHANGE COLUMN required_10148_01_mangos_mangos_string required_10342_02_mangos_command bit; ALTER TABLE playercreateinfo ADD COLUMN orientation float NOT NULL default '0' AFTER position_z; ALTER TABLE item_template CHANGE COLUMN Faction Flags2 int(10) unsigned NOT NULL default '0'; DELETE FROM spell_area WHERE spell = 58600; UPDATE npc_vendor SET ExtendedCost = abs(ExtendedCost) WHERE ExtendedCost < 0; ALTER TABLE npc_vendor CHANGE COLUMN `ExtendedCost` `ExtendedCost` mediumint(8) unsigned NOT NULL default '0'; UPDATE playercreateinfo SET orientation= 5.696318 WHERE race=4 and class<>6; UPDATE playercreateinfo SET orientation= 6.177156 WHERE race=3 and class<>6; UPDATE playercreateinfo SET orientation= 2.70526 WHERE race=5 and class<>6; UPDATE playercreateinfo SET orientation= 5.316046 WHERE race=10 and class<>6; UPDATE playercreateinfo SET orientation= 2.083644 WHERE race=11 and class<>6; UPDATE playercreateinfo SET orientation= 3.659973 WHERE class=6; DELETE FROM playercreateinfo_spell WHERE spell=1843 ; DELETE FROM playercreateinfo_spell WHERE spell=21084; -- humans INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (1, 1, 68398, 'Opening'), (1, 2, 20154, 'Seal of Righteousness'), (1, 2, 68398, 'Opening'), (1, 4, 68398, 'Opening'), (1, 5, 68398, 'Opening'), (1, 8, 68398, 'Opening'), (1, 8, 71761, 'Deep Freeze Immunity State'), (1, 9, 18822, 'Improved Enslave Demon'), (1, 9, 68398, 'Opening'), (1, 9, 75445, 'Demonic Immolate'); -- dwarf INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (3, 1, 68398, 'Opening'), (3, 2, 20154, 'Seal of Righteousness'), (3, 2, 68398, 'Opening'), (3, 3, 68398, 'Opening'), (3, 4, 68398, 'Opening'), (3, 5, 68398, 'Opening'); -- night elfs INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (4, 1, 21009, 'Elusiveness'), (4, 1, 68398, 'Opening'), (4, 3, 21009, 'Elusiveness'), (4, 3, 68398, 'Opening'), (4, 4, 21009, 'Elusiveness'), (4, 4, 68398, 'Opening'), (4, 5, 21009, 'Elusiveness'), (4, 5, 68398, 'Opening'), (4, 11, 66530, 'Improved Barkskin (Passive)'), (4, 11, 68398, 'Opening'); -- gnome INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (7, 1, 68398, 'Opening'), (7, 4, 68398, 'Opening'), (7, 8, 68398, 'Opening'), (7, 8, 71761, 'Deep Freeze Immunity State'), (7, 9, 18822, 'Improved Enslave Demon'), (7, 9, 68398, 'Opening'), (7, 9, 75445, 'Demonic Immolate'); -- orc INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (2, 1, 68398, 'Opening'), (2, 3, 68398, 'Opening'), (2, 4, 68398, 'Opening'), (2, 7, 65222, 'Command'), (2, 7, 68398, 'Opening'), (2, 7, 75461, 'Flame Shock Passive'), (2, 9, 18822, 'Improved Enslave Demon'), (2, 9, 68398, 'Opening'), (2, 9, 75445, 'Demonic Immolate'); -- undead INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (5, 1, 68398, 'Opening'), (5, 4, 68398, 'Opening'), (5, 5, 68398, 'Opening'), (5, 8, 68398, 'Opening'), (5, 8, 71761, 'Deep Freeze Immunity State'), (5, 9, 18822, 'Improved Enslave Demon'), (5, 9, 68398, 'Opening'), (5, 9, 75445, 'Demonic Immolate'); -- tauren INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (6, 1, 68398, 'Opening'), (6, 3, 68398, 'Opening'), (6, 7, 68398, 'Opening'), (6, 7, 75461, 'Flame Shock Passive'), (6, 11, 66530, 'Improved Barkskin (Passive)'), (6, 11, 68398, 'Opening'); -- troll INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (8, 1, 68398, 'Opening'), (8, 3, 68398, 'Opening'), (8, 4, 68398, 'Opening'), (8, 5, 68398, 'Opening'), (8, 7, 68398, 'Opening'), (8, 7, 75461, 'Flame Shock Passive'), (8, 8, 68398, 'Opening'), (8, 8, 71761, 'Deep Freeze Immunity State'); -- bloodelf INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (10, 2, 20154, 'Seal of Righteousness'), (10, 2, 68398, 'Opening'), (10, 3, 68398, 'Opening'), (10, 4, 68398, 'Opening'), (10, 5, 68398, 'Opening'), (10, 8, 68398, 'Opening'), (10, 9, 18822, 'Improved Enslave Demon'), (10, 9, 68398, 'Opening'), (10, 9, 75445, 'Demonic Immolate'); -- drarenei INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (11, 1, 68398, 'Opening'), (11, 2, 20154, 'Seal of Righteousness'), (11, 2, 68398, 'Opening'), (11, 3, 68398, 'Opening'), (11, 5, 68398, 'Opening'), (11, 7, 68398, 'Opening'), (11, 7, 75461, 'Flame Shock Passive'), (11, 8, 68398, 'Opening'), (11, 8, 71761, 'Deep Freeze Immunity State'); -- dk INSERT IGNORE INTO playercreateinfo_spell (race, class, Spell, Note) VALUES (1, 6, 68398, 'Opening'), (2, 6, 68398, 'Opening'), (3, 6, 68398, 'Opening'), (4, 6, 68398, 'Opening'), (5, 6, 68398, 'Opening'), (6, 6, 68398, 'Opening'), (7, 6, 68398, 'Opening'), (8, 6, 68398, 'Opening'), (10, 6, 68398, 'Opening'), (11, 6, 68398, 'Opening'); DELETE FROM playercreateinfo_action WHERE action IN (117, 21084, 159, 2070, 4540); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (1, 1, 1, 78, 0), (1, 1, 9, 59752, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (1, 2, 1, 20154, 0); DELETE FROM playercreateinfo_action WHERE class=5 AND race=1 AND button IN (0,1,2); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (1, 5, 0, 585, 0), (1, 5, 1, 2050, 0); DELETE FROM playercreateinfo_action WHERE class=8 AND race=1 AND button IN (0,1,2); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (1, 8, 0, 133, 0), (1, 8, 1, 168, 0); DELETE FROM playercreateinfo_action WHERE class=9 AND race=1 AND button IN (0,1,2); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (1, 9, 0, 686, 0), (1, 9, 1, 687, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (2, 1, 1, 78, 0), (2, 1, 2, 20572, 0); DELETE FROM playercreateinfo_action where race=2 AND class=9; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (2, 9, 0, 686, 0), (2, 9, 1, 687, 0), (2, 9, 2, 33702, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (3, 1, 2, 20594, 0), (3, 1, 3, 2481, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (3, 2, 1, 20154, 0); DELETE FROM playercreateinfo_action WHERE class=5 AND race=3 AND button IN (0,1,2,3,4); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (3, 5, 0, 585, 0), (3, 5, 1, 2050, 0), (3, 5, 2, 20594, 0), (3, 5, 3, 2481, 0); DELETE FROM playercreateinfo_action WHERE class=1 AND race=4; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (4, 1, 0, 6603, 0), (4, 1, 1, 78, 0), (4, 1, 108, 6603, 0), (4, 1, 2, 58984, 0), (4, 1, 72, 6603, 0), (4, 1, 73, 78, 0), (4, 1, 74, 58984, 0), (4, 1, 84, 6603, 0), (4, 1, 96, 6603, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (4, 3, 81, 58984, 0); DELETE FROM playercreateinfo_action WHERE race=4 AND class=4 AND button=10; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (4, 4, 4, 58984, 0); DELETE FROM playercreateinfo_action WHERE race=4 AND class=5 ; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (4, 5, 0, 585, 0), (4, 5, 1, 2050, 0), (4, 5, 2, 58984, 0), (4, 5, 81, 58984, 0); DELETE FROM playercreateinfo_action WHERE race=4 AND class=11 ; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (4, 11, 0, 5176, 0), (4, 11, 1, 5185, 0), (4, 11, 108, 6603, 0), (4, 11, 2, 58984, 0), (4, 11, 72, 6603, 0), (4, 11, 74, 58984, 0), (4, 11, 84, 6603, 0), (4, 11, 96, 6603, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (5, 1, 1, 78, 0), (5, 1, 2, 20577, 0); DELETE FROM playercreateinfo_action where race=5 AND class=8; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (5, 8, 0, 133, 0), (5, 8, 1, 168, 0), (5, 8, 2, 20577, 0); DELETE FROM playercreateinfo_action where race=5 AND class=9; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (5, 9, 0, 686, 0), (5, 9, 1, 687, 0), (5, 9, 2, 20577, 0); DELETE FROM playercreateinfo_action where race=5 AND class=5; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (5, 5, 0, 585, 0), (5, 5, 1, 2050, 0), (5, 5, 2, 20577, 0); UPDATE playercreateinfo_action SET button=2 WHERE race=6 AND class=1 AND button=3; UPDATE playercreateinfo_action SET button=75 WHERE race=6 AND class=3 AND button=76; UPDATE playercreateinfo_action SET button=75 WHERE race=6 AND class=7 AND button=76; DELETE FROM playercreateinfo_action WHERE race=6 AND class=11; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (6, 11, 0, 5176, 0), (6, 11, 1, 5185, 0), (6, 11, 108, 6603, 0), (6, 11, 2, 20549, 0), (6, 11, 72, 6603, 0), (6, 11, 75, 20549, 0), (6, 11, 84, 6603, 0), (6, 11, 96, 6603, 0); DELETE FROM playercreateinfo_action WHERE race=7 AND class=1 AND button in (82,10); DELETE FROM playercreateinfo_action WHERE race=7 AND class=4 AND button in (10); DELETE FROM playercreateinfo_action WHERE race=7 AND class=8; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (7, 8, 0, 133, 0), (7, 8, 1, 168, 0); DELETE FROM playercreateinfo_action WHERE race=7 AND class=9; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (7, 9, 0, 686, 0), (7, 9, 1, 687, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (8, 1, 1, 78, 0), (8, 1, 2, 26297, 0); INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (8, 4, 76, 26297, 0); DELETE FROM playercreateinfo_action WHERE race=8 AND class=5; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (8, 5, 0, 585, 0), (8, 5, 1, 2050, 0), (8, 5, 2, 26297, 0); DELETE FROM playercreateinfo_action WHERE race=8 AND class=8; INSERT IGNORE INTO playercreateinfo_action (race, class, button, action, type) VALUES (8, 8, 0, 133, 0), (8, 8, 1, 168, 0), (8, 8, 2, 26297, 0); -- 21084 replace of 20154 at learn judgements DELETE FROM spell_learn_spell WHERE SpellID = 21084; INSERT INTO spell_learn_spell VALUES (20271,21084,1), (53407,21084,1), (53408,21084,1); -- 21084 replace of 20154 at learn judgements DELETE FROM spell_chain WHERE first_spell = 20154; INSERT INTO spell_chain VALUES (20154,0,20154,1,0), (21084,20154,20154,2,0); DELETE FROM `spell_proc_event` WHERE entry in (20154, 21084); INSERT INTO `spell_proc_event` VALUES (20154, 0x01, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); DROP TABLE IF EXISTS `reputation_reward_rate`; CREATE TABLE `reputation_reward_rate` ( `faction` mediumint(8) unsigned NOT NULL default '0', `quest_rate` float NOT NULL default '1', `creature_rate` float NOT NULL default '1', `spell_rate` float NOT NULL default '1', PRIMARY KEY (`faction`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ALTER TABLE auctionhouse ADD COLUMN houseid int(11) unsigned NOT NULL default '0' AFTER id; UPDATE auctionhouse, mangos.creature AS c, mangos.creature_template AS ct SET houseid = CASE ct.faction_A WHEN 12 THEN 1 /* human */ WHEN 29 THEN 6 /* orc, and generic for horde */ WHEN 55 THEN 2 /* dwarf/gnome, and generic for alliance */ WHEN 68 THEN 4 /* undead */ WHEN 80 THEN 3 /* n-elf */ WHEN 104 THEN 5 /* trolls */ WHEN 120 THEN 7 /* booty bay, neutral */ WHEN 474 THEN 7 /* gadgetzan, neutral */ WHEN 534 THEN 2 /* Alliance Generic */ WHEN 855 THEN 7 /* everlook, neutral */ WHEN 1604 THEN 6 /* b-elfs, */ WHEN 1638 THEN 2 /* exodar, alliance */ ELSE 0 /* auction will canceled at loading */ END WHERE auctionhouse.auctioneerguid = c.guid AND c.id = ct.entry; ALTER TABLE auctionhouse DROP COLUMN auctioneerguid; DROP TABLE IF EXISTS auction; RENAME TABLE auctionhouse TO auction; DROP TABLE IF EXISTS `reputation_spillover_template`; CREATE TABLE `reputation_spillover_template` ( `faction` smallint(6) unsigned NOT NULL default '0' COMMENT 'faction entry', `faction1` smallint(6) unsigned NOT NULL default '0' COMMENT 'faction to give spillover for', `rate_1` float NOT NULL default '0' COMMENT 'the given rep points * rate', `rank_1` tinyint(3) unsigned NOT NULL default '0' COMMENT 'max rank, above this will not give any spillover', `faction2` smallint(6) unsigned NOT NULL default '0', `rate_2` float NOT NULL default '0', `rank_2` tinyint(3) unsigned NOT NULL default '0', `faction3` smallint(6) unsigned NOT NULL default '0', `rate_3` float NOT NULL default '0', `rank_3` tinyint(3) unsigned NOT NULL default '0', `faction4` smallint(6) unsigned NOT NULL default '0', `rate_4` float NOT NULL default '0', `rank_4` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`faction`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain'; ALTER TABLE creature_template CHANGE COLUMN modelid_A modelid_1 mediumint(8) unsigned NOT NULL default '0'; ALTER TABLE creature_template CHANGE COLUMN modelid_A2 modelid_2 mediumint(8) unsigned NOT NULL default '0'; ALTER TABLE creature_template CHANGE COLUMN modelid_H modelid_3 mediumint(8) unsigned NOT NULL default '0'; ALTER TABLE creature_template CHANGE COLUMN modelid_H2 modelid_4 mediumint(8) unsigned NOT NULL default '0'; UPDATE creature_template SET modelid_3=0 WHERE entry=1; ALTER TABLE creature_model_info ADD COLUMN modelid_alternative mediumint(8) unsigned NOT NULL default '0' AFTER modelid_other_gender; ALTER TABLE creature_model_info ADD COLUMN modelid_other_team mediumint(8) unsigned NOT NULL default '0' AFTER modelid_alternative; DROP TABLE IF EXISTS `event_id_scripts`; CREATE TABLE `event_id_scripts` ( `id` mediumint(8) NOT NULL, `ScriptName` char(64) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Script library scripted events'; ALTER TABLE instance_template CHANGE COLUMN `script` `ScriptName` varchar(128) NOT NULL default ''; RENAME TABLE areatrigger_scripts TO scripted_areatrigger; RENAME TABLE event_id_scripts TO scripted_event_id; Добавлено (25.11.2010, 17:40)
Сообщение # 133 написано 25.11.2010 в 17:40
|
AlO,
[Err] 1054 - Unknown column 'required_10148_01_mangos_mangos_string' in 'db_version' [Err] ALTER TABLE db_version CHANGE COLUMN required_10148_01_mangos_mangos_string required_10342_02_mangos_command bit; [Msg] Finished - Unsuccessfully -------------------------------------------------- также может обясниш что по порядку заливать всё заного залью???
Сообщение # 134 написано 25.11.2010 в 17:41
|
AlO,
Терь такая [cut] 2010-11-25 22:24:51 SQL: SELECT required_10051_01_characters_character_aura FROM character_db_version LIMIT 1 2010-11-25 22:24:51 query ERROR: Unknown column 'required_10051_01_characters_character_aura' in 'field list' 2010-11-25 22:24:51 The table `character_db_version` in your [CHARACTER] database indicates that this database is out of date! 2010-11-25 22:24:51 2010-11-25 22:24:51 [A] You have: --> `10568_01_characters_character_tutorial.sql` 2010-11-25 22:24:51 2010-11-25 22:24:51 [B] You need: --> `10051_01_characters_character_aura.sql` 2010-11-25 22:24:51 2010-11-25 22:24:51 You must apply all updates after [A] to [B] to use mangos with this database. 2010-11-25 22:24:51 These updates are included in the sql/updates folder. 2010-11-25 22:24:51 Please read the included [README] in sql/updates for instructions on updating. [/cut]
Сообщение # 142 написано 25.11.2010 в 18:26
|
AlO, смотри терь всё сделал чото токо терь идёт вот когда запускается сервер идёт идёт там и вот это появляется
2010-11-25 22:36:13 ERROR:Error in creature_template table, probably sql file format was updated (there should be 83 fields in sql).
Сообщение # 144 написано 25.11.2010 в 18:37
|
так как я давно уже не компилил и этих ReadMe нету уже 
| |||