Добавлено (31.03.2011, 21:25) --------------------------------------------- пример у меня стоит
YTDB_0.14.2_R590_MaNGOS_R11278_SD2_R2003_ACID_R308_RuDB_38.8 Full
как мне привязать ядро ?
ManGOS_R10967_ScriptDev2_r1918 (core rev.12 "small quest rewrite" mod by lanc) for 3.3.5a 12340
Добавлено (31.03.2011, 21:33) --------------------------------------------- или на пример стоит YTDB_0.13.8_R560_MaNGOS_R10344_SD2_R1777_ACID_R304_RuDB_R38.2
хочу обновить на YTDB_0.14.2_R590_MaNGOS_R11278_SD2_R2003_ACID_R308_RuDB_R38.8.7
Добавлено (01.04.2011, 02:37) --------------------------------------------- HeisenBeRG, нафиг мне компилить если могу взять от судо http://www.wow-info.net/forum/37-2665-1
Сообщение отредактировал Olivers - П`ятниця, 01.04.2011, 02:38
базу обнавил, поставил YTDB_0.14.2_R590_MaNGOS_R11278_SD2_R2003_ACID_R308_RuDB_R38.8.7 патом ядро тоже ManGOS_R10967_ScriptDev2_r1918 (core rev.12 "small quest rewrite" mod by lanc) for 3.3.5a 12340
запускаю сервер пишет
2011-04-01 11:00:28 Using configuration file mangosd.conf. 2011-04-01 11:00:28 World Database: 127.0.0.1;3308;root;amber;mangos 2011-04-01 11:00:28 MySQL client library: 5.1.49 2011-04-01 11:00:28 MySQL server ver: 5.1.45-community 2011-04-01 11:00:28 ERROR:SQL: SELECT required_10864_01_mangos_spell_proc_event FROM db_version LIMIT 1 2011-04-01 11:00:28 ERROR:query ERROR: Unknown column 'required_10864_01_mangos_spell_proc_event' in 'field list' 2011-04-01 11:00:28 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date! 2011-04-01 11:00:28 ERROR: 2011-04-01 11:00:28 ERROR: [A] You have: --> `11234_01_mangos_command.sql` 2011-04-01 11:00:28 ERROR: 2011-04-01 11:00:28 ERROR: [B] You need: --> `10864_01_mangos_spell_proc_event.sql` 2011-04-01 11:00:28 ERROR: 2011-04-01 11:00:28 ERROR:You must apply all updates after [A] to [B] to use mangos with this database. 2011-04-01 11:00:28 ERROR:These updates are included in the sql/updates folder. 2011-04-01 11:00:28 ERROR:Please read the included [README] in sql/updates for instructions on updating.
2011-04-01 16:32:50 Using configuration file mangosd.conf. 2011-04-01 16:32:50 World Database: 127.0.0.1;3308;root;amber;mangos 2011-04-01 16:32:50 MySQL client library: 5.1.49 2011-04-01 16:32:50 MySQL server ver: 5.1.45-community 2011-04-01 16:32:50 ERROR:SQL: SELECT required_10951_01_mangos_spell_proc_event FROM db_version LIMIT 1 2011-04-01 16:32:50 ERROR:query ERROR: Unknown column 'required_10951_01_mangos_spell_proc_event' in 'field list' 2011-04-01 16:32:50 ERROR:The table `db_version` in your [WORLD] database indicates that this database is out of date! 2011-04-01 16:32:50 ERROR: 2011-04-01 16:32:50 ERROR: [A] You have: --> `11234_01_mangos_command.sql` 2011-04-01 16:32:50 ERROR: 2011-04-01 16:32:50 ERROR: [B] You need: --> `10951_01_mangos_spell_proc_event.sql` 2011-04-01 16:32:50 ERROR: 2011-04-01 16:32:50 ERROR:You must apply all updates after [A] to [B] to use mangos with this database. 2011-04-01 16:32:50 ERROR:These updates are included in the sql/updates folder. 2011-04-01 16:32:50 ERROR:Please read the included [README] in sql/updates for instructions on updating.
ALTER TABLE db_version CHANGE COLUMN required_11234_01_mangos_command required_10951 _01_mangos_spell_proc_event bit; Ошибка [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' _01_mangos_spell_proc_event bit' at line 1 [Err] ALTER TABLE db_version CHANGE COLUMN required_11234_01_mangos_command required_10951 _01_mangos_spell_proc_event bit; [Msg] Finished - Unsuccessfully
это залилось
-- -- Table structure for table `db_version` --
DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) NOT NULL, `creature_ai_version` varchar(120) default NULL, `cache_id` int(10) default '0', `required_10951_01_mangos_spell_proc_event` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
-- -- Dumping data for table `db_version` --
LOCK TABLES `db_version` WRITE; /*!40000 ALTER TABLE `db_version` DISABLE KEYS */; INSERT INTO `db_version` VALUES ('YTDB_0.14.2_R590_MaNGOS_R11278_SD2_R2003_ACID_R308_RuDB_R38.8','ACID 3.0.8 - Full Release for Mangos (3.3.5a Client)',590,'\0'); /*!40000 ALTER TABLE `db_version` ENABLE KEYS */; UNLOCK TABLES;
ну шас вот проблема
2011-04-02 08:20:33 ERROR:SQL: SELECT required_10862_01_characters_mail FROM character_db_version LIMIT 1 2011-04-02 08:20:33 ERROR:query ERROR: Table 'characters2.character_db_version' doesn't exist 2011-04-02 08:20:33 ERROR:SQL: SELECT * FROM character_db_version LIMIT 1 2011-04-02 08:20:33 ERROR:query ERROR: Table 'characters2.character_db_version' doesn't exist 2011-04-02 08:20:33 ERROR:The table `character_db_version` in your [CHARACTER] database is missing or corrupt. 2011-04-02 08:20:33 ERROR:MaNGOS cannot find the version info needed to check that the db is up to date. 2011-04-02 08:20:33 ERROR: 2011-04-02 08:20:33 ERROR:This revision of mangos requires a database updated to: 2011-04-02 08:20:33 ERROR:`10862_01_characters_mail.sql` 2011-04-02 08:20:33 ERROR: 2011-04-02 08:20:33 ERROR:Reinstall your [CHARACTER] database with the included sql file in the sql folder.
Olivers, в папке с ядром есть папка sql/updates там ищи в названии characters... ну или удали таблицу characters и в папке sql есть characters.sql его залей и все будет норм)
2011-04-04 11:08:20 Loading Creature templates... 2011-04-04 11:08:21 ERROR:Error in creature_template table, probably sql file format was updated (there should be 90 fields in sql).
Olivers, надо все sql залить из папки addition туда куда надо (там написано в какую базу заливать) и v01_vehicle_data.sql или что-то подобное их там либо 3 либо 5 ***.sql файлов напоследок) (то есть в самую последнюю очередь)
Сообщение отредактировал Alo - Понеділок, 04.04.2011, 20:43
![[FaNaT1K]](/img/noava.jpg "[FaNaT1K]")
