• Страница 1 из 1
  • 1
Архив - только для чтения
Модератор форума: andycrowz  
Worldserver
_Mehanick_
Скаут
Доброго времени суток! Я ранее писал на счет этой темы, я исправил проблему, но появилась другая
Вот Лог
Code
Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012)
Using ACE version: 6.1.4
TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

  ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
    \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
     \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
      \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
       \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                    C O R E  /\___/
http://TrinityCore.org                    \/__/

In mysql_stmt_prepare() id: 56, sql: "SELECT 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_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, unit_flags2, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, 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, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
с чем это связано? База 628 стоит, все нужные апдейты залил...

Добавлено (24.09.2012, 17:53)
---------------------------------------------
Проблема решена

Добавлено (24.09.2012, 17:59)
---------------------------------------------
Хотя нет, не решена

Code

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1 14 Mar 2012 (library: OpenSSL 1.0.1 14 Mar 2012)
Using ACE version: 6.1.4
TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

  ______                       __
/\__  _\       __          __/\ \__
\/_/\ \/ _ __ /\_\    ___ /\_\ \, _\  __  __
    \ \ \/\`'__\/\ \ /' _ `\/\ \ \ \/ /\ \/\ \
     \ \ \ \ \/ \ \ \/\ \/\ \ \ \ \ \_\ \ \_\ \
      \ \_\ \_\  \ \_\ \_\ \_\ \_\ \__\\/`____ \
       \/_/\/_/   \/_/\/_/\/_/\/_/\/__/ `/___/> \
                    C O R E  /\___/
http://TrinityCore.org                   \/__/

Realm running as realm ID 1
Using World DB: TDB 335.49
Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
Using DataDir ./Data/
VMap support included. LineOfSight:1, getHeight:1, indoorCheck:1 PetLOS:1
VMap data directory is: ./Data/vmaps
Loading Trinity strings...
>> Loaded 960 Trinity strings from table trinity_string in 80 ms
Initialize data stores...
>> Initialized 96 data stores in 2580 ms
Using ruRU DBC Locale as default. All available DBC locales: ruRU  
Loading spell dbc data corrections...
>> Loading spell dbc data corrections  in 20 ms
Loading SpellInfo store...
>> Loaded spell custom attributes in 80 ms
Loading SkillLineAbilityMultiMap Data...
>> Loaded 10219 SkillLineAbility MultiMap Data in 0 ms
Loading spell custom attributes...
>> Loaded spell custom attributes in 50 ms
Loading GameObject models...
>> Loaded 2321 GameObject models in 20 ms
Loading Script Names...
>> Loaded 2020 Script Names in 11614 ms
Loading Instance Template...
>> Loaded 88 instance templates in 0 ms
Loading instances...
>> Loaded instances in 2090 ms
Loading Localization strings...
>> Loaded 29984 creature locale strings in 412 ms
>> Loaded 18002 gameobject locale strings in 290 ms
>> Loaded 37411 Item locale strings in 452 ms
>> Loaded 2192 Item set name locale strings in 90 ms
>> Loaded 9500 Quest locale strings in 1466 ms
>> Loaded 7419 NpcText locale strings in 616 ms
>> Loaded 1849 PageText locale strings in 250 ms
>> Loaded 3495 gossip_menu_option locale strings in 130 ms
>> Loaded 494 points_of_interest locale strings in 50 ms
>> Localization strings loaded in 3756 ms
Loading Page Texts...
>> Loaded 2079 page texts in 120 ms
Loading Game Object Templates...
>> Loaded 19348 game object templates in 444 ms
Loading Spell Rank Data...
>> Loaded 5593 spell rank records in 110 ms
Loading Spell Required Data...
>> Loaded 41 spell required records in 10 ms
Loading Spell Group types...
>> Loaded 455 spell group definitions in 20 ms
Loading Spell Learn Skills...
>> Loaded 99 Spell Learn Skills from DBC in 0 ms
Loading Spell Learn Spells...
>> Loaded 19 spell learn spells + 572 found in DBC in 40 ms
Loading Spell Proc Event conditions...
>> Loaded 1087 extra and 61 custom spell proc event conditions in 80 ms
Loading Spell Proc conditions and data...
>> Loaded 0 spell proc conditions and data. DB table `spell_proc` is empty.
Loading Spell Bonus Data...
>> Loaded 341 extra spell bonus data in 40 ms
Loading Aggro Spells Definitions...
>> Loaded 106 SpellThreatEntries in 20 ms
Loading Spell Group Stack Rules...
>> Loaded 49 spell group stack rules in 10 ms
Loading NPC Texts...
>> Loaded 7465 npc texts in 402 ms
Loading Enchant Spells Proc datas...
>> Loaded 42 enchant proc data definitions in 20 ms
Loading Item Random Enchantments Table...
>> Loaded 28691 Item Enchantment definitions in 202 ms
Loading Disables
>> Loaded 4 disables in 0 ms
Loading Items...
[1054] Unknown column 'SoundOverrideSubclass' in 'field list'
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
Сообщение # 1 написано 24.09.2012 в 17:59
Thermaplugg
Database Developer
про первую ошибку:
Code
-- / sql / old / 3.3.5a / 2012_08_30_00_world_creature_template.sql
ALTER TABLE `creature_template` ADD `unit_flags2` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `unit_flags`;
-- / sql / old / 3.3.5a / 2012_09_07_01_world_creature_template.sql
UPDATE `creature_template` SET `unit_flags2`=`unit_flags2`|0x800; -- UNIT_FLAG2_REGENERATE_POWER

про вторую:
Code
-- / sql / old / 3.3.5a / 2012_09_13_00_world_item_template.sql
ALTER TABLE `item_template` CHANGE unk0 SoundOverrideSubclass tinyint(3) NOT NULL DEFAULT '-1';
Сообщение # 2 отредактировано MENZ411 - Понедельник, 24.09.2012, 18:14
Miхer
Brian Viveros
Quote (_Mehanick_)
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

Апдейты залить нужно, не?
Сообщение # 3 написано 24.09.2012 в 21:58
_Mehanick_
Скаут
привет всем снова прошу помощи после тогдашнего компилирования ядра все было нормально
тогда все апы залили
Но теперь выскакивает другая ошибка
Code
>> Loaded 15 faction change reputation pairs in 21 ms
Loading faction change title pairs...
[1146] Table 'world.player_factionchange_titles' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
не могу найти ап
З.Ы теперь новое ядро и чистая база
Сообщение # 4 отредактировано _Mehanick_ - Воскресенье, 07.10.2012, 13:29
Nosmoking
Скаут
Quote (_Mehanick_)
привет всем снова прошу помощи после тогдашнего компилирования ядра все было нормально
тогда все апы залили
Но теперь выскакивает другая ошибка
Code
>> Loaded 15 faction change reputation pairs in 21 ms
Loading faction change title pairs...
[1146] Table 'world.player_factionchange_titles' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
не могу найти ап
З.Ы теперь новое ядро и чистая база


Code
ALTER TABLE `item_template` CHANGE unk0 SoundOverrideSubclass tinyint(3) NOT NULL DEFAULT '-1';
Сообщение # 5 отредактировано Nosmoking - Понедельник, 08.10.2012, 01:37
Thermaplugg
Database Developer
http://wowjp.net/forum/126-232027-1#3601222 +апы от ядра... и вуаля
Сообщение # 6 написано 08.10.2012 в 02:54
  • Страница 1 из 1
  • 1
Поиск: