BeLove
-
Posts
57 -
Joined
-
Last visited
-
Days Won
2
Posts posted by BeLove
-
-
1) Disabled strict mode
2) Dropped world db
3) Updated core to TrinityCore rev. 1f9f59b4b3b9+ 2017-11-30 23:36:45 +0100
4) Installed fresh TDB, all world updates are applied after first server start (without errors)
5) Issue still exist - a lot of NPC still "died" and spawned only after ".respawn" command
-
Ok I found that I can bring back my NPC via .respawn command. Looking for the root is this issue
-
Hi guys. I have a pretty strange issue.
I have a totally fresh installation - TrinityCore rev. 1f9f59b4b3b9+ 2017-11-30 23:36:45 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (with all DB updates), no patches (except next one):
---
update game_event set start_time = '1971-01-01 00:00:00', end_time = '1972-01-01 00:00:00' where eventEntry in (22, 17, 13, 31, 48, 49, 55, 56, 57, 58, 59, 60);
ALTER TABLE game_event MODIFY COLUMN start_time timestamp NOT NULL DEFAULT '1971-01-01 00:00:00', MODIFY COLUMN end_time timestamp NOT NULL DEFAULT '1972-01-01 00:00:00';
--
This one is required for my MySQL server (and my chars database is old but updated).
And... most of NPC in cities like Stormwind doesn't exist. If im trying to do list cre (e.g. auctioneer in Stormwind)
list cre 8670
79706 - Auctioneer Chilton X:-8824.280273 Y:665.710999 Z:97.467400 MapId:0
Found creatures 8670: 1and after that
go cre |cffffffff|Hcreature:79706|h[Auctioneer Chilton X:-8824.280273 Y:665.710999 Z:97.467400 MapId:0]|h|r [Player: Risk (GUID Full: 0x000000000000bc41 Type: Player Low: 48193) (Account: 3) X: -8829.995117 Y: 632.190308 Z: 94.203384 Map: 0 (Восточные королевства) Area: 1519 (Штормград)
I cannot see anyone. I note that list cre command does't say anything about values like "GUID Full" by no reason. Probably I'm thinking about issue in "Grid unload" functionality (bugged in my case? I have 4 gb ram / 4 gb swap)
Do you have any ideas? Thanks.
P.S. I'm pretty sure that this case related only to my installation - that is why I didn't created this issue @ github
-
Compiled/updated today (clean db TDB_full_434.04_2013_02_14.sql + all from updates_04 and clean core 2013-02-27 03:30:53 +0100 (480c6cf4dd89)) - bug still exist.
-
Wryshu, I mean this bug affected all users and it's a mistake was made by developers (db is updated but some source code isn't modified). Just wait when developers fix it or try to fix self
P.S. I fixed it, but my solution isn't correct. W8 for fix in repo.
-
Subj is actual. Compiled today:
Using SSL version: OpenSSL 1.0.1c 10 May 2012 (library: OpenSSL 1.0.1c 10 May 2012)Using ACE version: 6.0.3TrinityCore rev. 2013-02-25 05:38:34 +0200 (20e913efa685) (Unix, Release) (worldserver-daemon)<Ctrl-C> to stop.______ __/__ _ __ __/ __/_/ / _ __ /_ ___ /_ , _ __ __/`'__/ /' _ `/ / / // / / _ __ _ _ _ _ _ __/`____/_//_/ /_//_//_//_//__/ `/___/>C O R E /___/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, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"Unknown column 'trainer_spell' in 'field list'DatabasePool tc434_world_tdb NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.Using last TDB. (TDB_full_434.04_2013_02_14.sql + updates_04).
P.S. Field trainer_spell is removed in 051_2013_01_29_00_world_creature_template_434.sql:1:ALTER TABLE `creature_template` DROP `trainer_spell`; (updates_03)
-
please mention also how many people online..
im now testing 11335 and this is the results ( still counting)
Online for 9 hours, 54 minutes, 3 seconds
Max players this uptime session: 989
Trinity Revision: 11335+ Database Version: TDB 335.11.36
custom patches: Ac1
every day in the evening 900-960
-
11268 - uptime 6 days (with AC2, PvP Ranks, WG, GH and other patches)
-
Last news
TrinityCore Rev: 10827, max online - 656, uptime - 2d 10 hours.
And crash
I'm think it normal, may it's LFG, i don't have last commit for crash fix. -
TC>s info
TC>TrinityCore Rev: 10827+ Release Hash: 5efce03a11a4+ (Unix, little-endian)
Online players: 35 (max: 612)
Active connections: 35 (max: 625) Queued connections: 0 (max: 0)
Server uptime: 1 Day(s) 18 Hour(s) 32 Minute(s) 17 Second(s).
Update time diff: 49.
no one crashes after last start.
-
1
-
I'm think it normal, may it's LFG, i don't have last commit for crash fix.
No NPC at Stormwind [3.3.5a]
in Help and Support
Posted
Thanks for reply, I know that this issue only exists for me. Just probably it's some common thing that can happen. BTW I note that in debug mode I see a lot of errors related to mmap loading and want to re-extract all data files.