|
Архив - только для чтения |
| Модератор форума: andycrowz |
| Форум Корзина форума Корзина YTDB база не идет |
| YTDB база не идет |
Код In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? WHERE entry = ?" Unknown column 'faction' in 'field list' In mysql_stmt_prepare() id: 68, sql: "UPDATE creature SET zoneId = ?, areaId = ? WHERE guid = ?" Unknown column 'zoneId' in 'field list' In mysql_stmt_prepare() id: 69, sql: "UPDATE gameobject SET zoneId = ?, areaId = ? WHERE guid = ?" Unknown column 'zoneId' in 'field list' По моей теории не работает так как в тринити новой колонки faction, а в старой были faction_A и faction_H и тд... Может есть у кого нормальная база YTDB под новые ревы тринитикоре? Просто TDB не вариант ставить... Добавлено (10.02.2015, 21:29) Код In mysql_stmt_prepare() id: 68, sql: "UPDATE creature SET zoneId = ?, areaId = ? WHERE guid = ?" Unknown column 'zoneId' in 'field list' In mysql_stmt_prepare() id: 69, sql: "UPDATE gameobject SET zoneId = ?, areaId = ? WHERE guid = ?" Unknown column 'zoneId' in 'field list'
Сообщение # 1 написано 10.02.2015 в 21:29
|
Код DROP TABLE IF EXISTS `creature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature` ( `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1', `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', `equipment_id` tinyint(3) NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120', `spawndist` float NOT NULL DEFAULT '0', `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0', `curhealth` int(10) unsigned NOT NULL DEFAULT '1', `curmana` int(10) unsigned NOT NULL DEFAULT '0', `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', `npcflag` int(10) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_map` (`map`), KEY `idx_id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=200001 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; нету у них zoneid... Добавлено (10.02.2015, 23:27) Цитата Dinoza (  )ALTER TABLE `таблица` ADD COLUMN `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier'; Как пример спасибо поправил, перезалью апдейты щас еще все на всякий, как это может сказаться на работе сервера если что ? Добавлено (10.02.2015, 23:28) Код Unknown column 'move_type' in 'field list' In mysql_stmt_prepare() id: 34, sql: "SELECT id, point, delay, move_type, action, action_chance FROM waypoint_data WHERE wpguid = ?" Unknown column 'move_type' in 'field list' In mysql_stmt_prepare() id: 54, sql: "SELECT entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction, npcflag, speed_walk, speed_run, scale, rank, dmgschool, BaseAttackTime, RangeAttackTime, BaseVariance, RangeVariance, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?" Unknown column 'BaseVariance' in 'field list' Добавлено (10.02.2015, 23:33)
Сообщение # 5 написано 10.02.2015 в 23:33
|
Дошли до spell.dbc
 Код spelldifficulty_dbc: spell 71356 at field id:2108 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 71803 at field id:2108 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 72111 at field id:2136 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 72125 at field id:2136 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 70816 at field id:2146 at spellid0 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 72233 at field id:2146 at spellid1 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 72234 at field id:2146 at spellid2 does not exist in SpellStore (spell.dbc), loaded as 0 spelldifficulty_dbc: spell 72235 at field id:2146 at spellid3 does not exist in SpellStore (spell.dbc), loaded as 0
Сообщение # 8 написано 11.02.2015 в 22:52
|
| |||
| |||