DarthDepa
-
Posts
45 -
Joined
-
Last visited
Posts posted by DarthDepa
-
-
Because you tried to pass incorrect arguments.
account create name password
account set gmlevel name 3 -1
Oh, yeah!!! *.* you are my savior. Thanks a lot...
I have to delete account and create it again or the manual query is enought, in order to set that account as GM?
Thanks.
-
Because to create one gm account you must use console command, not insert the gm account directly into database.
Yes, sure Infact I used:
account create name password 3 -1
but it didn't work... So I did it manually (I don't know if it works, because I can't try now).
-
It was:
mysql> SELECT * from rbac_account_groups; +-----------+---------+---------+ | accountId | groupId | realmId | +-----------+---------+---------+ | 1 | 1 | -1 | +-----------+---------+---------+
According to your suggest:UPDATE rbac_account_groups SET groupId=3 WHERE accountId=1; mysql> SELECT * from rbac_account_groups; +-----------+---------+---------+ | accountId | groupId | realmId | +-----------+---------+---------+ | 1 | 3 | -1 | +-----------+---------+---------+
Right?From worldserver prompt I typed:account create name password 3 -1
Why this not work? DB problem?Thanks a lot to each of you! Really... -
Depa Marco: we are aware of the db errors. If you wanna help fixing them, submit fixes to https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/ (either PR or issue)
Thanks a lot
Only one question more: all seams right, in-game. But when I type .gm on (my account is GM level 3, in all realms), is sais me:
There is no such subcommand
Why??
Thanks a lot!!
-
You are right! Sorry... Now world server start!
But there are a lot of "error"/"warnings" about missing content in the DB (see Server.txt).
Why?
Tonight, I will check if is all right "in game"
Thanks a lot. -
No you are not, TC 4.3.4 DON'T needs / search for trainer_spell column on creature_template.
src/434/src$ rgrep trainer_spell *
server/game/Entities/Player/Player.cpp:TrainerSpellState Player::GetTrainerSpellState(TrainerSpell const* trainer_spell) const
server/game/Entities/Player/Player.cpp: if (!trainer_spell)
server/game/Entities/Player/Player.cpp: if (!trainer_spell->learnedSpell)
server/game/Entities/Player/Player.cpp: if (!HasSpell(trainer_spell->learnedSpell))
server/game/Entities/Player/Player.cpp: if (trainer_spell->reqSkill && GetBaseSkillValue(trainer_spell->reqSkill) < trainer_spell->reqSkillValue)
server/game/Entities/Player/Player.cpp: if (getLevel() < trainer_spell->reqLevel)
server/game/Entities/Player/Player.cpp: if (!trainer_spell->learnedSpell)
server/game/Entities/Player/Player.cpp: if (!IsSpellFitByClassAndRace(trainer_spell->learnedSpell))
server/game/Entities/Player/Player.cpp: if (uint32 prevSpell = sSpellMgr->GetPrevSpellInChain(trainer_spell->learnedSpell))
server/game/Entities/Player/Player.cpp: SpellsRequiringSpellMapBounds spellsRequired = sSpellMgr->GetSpellsRequiredForSpellBounds(trainer_spell->learnedSpell);
server/game/Entities/Player/Player.cpp: if (!trainer_spell->learnedSpell)
server/game/Entities/Player/Player.cpp: SpellInfo const* learnedSpellInfo = sSpellMgr->GetSpellInfo(trainer_spell->learnedSpell);
server/game/Entities/Player/Player.h: TrainerSpellState GetTrainerSpellState(TrainerSpell const* trainer_spell) const;
server/game/Handlers/NPCHandler.cpp: TrainerSpellData const* trainer_spells = unit->GetTrainerSpells();
server/game/Handlers/NPCHandler.cpp: if (!trainer_spells)
server/game/Handlers/NPCHandler.cpp: WorldPacket data(SMSG_TRAINER_LIST, 8+4+4+trainer_spells->spellList.size()*38 + strTitle.size()+1);
server/game/Handlers/NPCHandler.cpp: data << uint32(trainer_spells->trainerType);
server/game/Handlers/NPCHandler.cpp: data << uint32(trainer_spells->spellList.size());
server/game/Handlers/NPCHandler.cpp: for (TrainerSpellMap::const_iterator itr = trainer_spells->spellList.begin(); itr != trainer_spells->spellList.end(); ++itr)
server/game/Handlers/NPCHandler.cpp: TrainerSpellData const* trainer_spells = unit->GetTrainerSpells();
server/game/Handlers/NPCHandler.cpp: if (!trainer_spells)
server/game/Handlers/NPCHandler.cpp: TrainerSpell const* trainer_spell = trainer_spells->Find(spellId);
server/game/Handlers/NPCHandler.cpp: if (!trainer_spell)
server/game/Handlers/NPCHandler.cpp: if (_player->GetTrainerSpellState(trainer_spell) != TRAINER_SPELL_GREEN)
server/game/Handlers/NPCHandler.cpp: uint32 nSpellCost = uint32(floor(trainer_spell->spellCost * _player->GetReputationPriceDiscount(unit)));
server/game/Handlers/NPCHandler.cpp: if (trainer_spell->IsCastable())
server/game/Handlers/NPCHandler.cpp: _player->CastSpell(_player, trainer_spell->spell, true);
src/trinitycore/src$ rgrep trainer_spell *
server/game/Entities/Creature/Creature.h: uint32 trainer_spell;
server/game/Entities/Player/Player.cpp:TrainerSpellState Player::GetTrainerSpellState(TrainerSpell const* trainer_spell) const
server/game/Entities/Player/Player.cpp: if (!trainer_spell)
server/game/Entities/Player/Player.cpp: if (!trainer_spell->learnedSpell)
server/game/Entities/Player/Player.cpp: if (!HasSpell(trainer_spell->learnedSpell))
server/game/Entities/Player/Player.cpp: if (trainer_spell->reqSkill && GetBaseSkillValue(trainer_spell->reqSkill) < trainer_spell->reqSkillValue)
server/game/Entities/Player/Player.cpp: if (getLevel() < trainer_spell->reqLevel)
server/game/Entities/Player/Player.cpp: if (!trainer_spell->learnedSpell)
server/game/Entities/Player/Player.cpp: if (!IsSpellFitByClassAndRace(trainer_spell->learnedSpell))
server/game/Entities/Player/Player.cpp: if (uint32 prevSpell = sSpellMgr->GetPrevSpellInChain(trainer_spell->learnedSpell))
server/game/Entities/Player/Player.cpp: SpellsRequiringSpellMapBounds spellsRequired = sSpellMgr->GetSpellsRequiredForSpellBounds(trainer_spell->learnedSpell);
server/game/Entities/Player/Player.cpp: if (!trainer_spell->learnedSpell)
server/game/Entities/Player/Player.cpp: SpellInfo const* learnedSpellInfo = sSpellMgr->GetSpellInfo(trainer_spell->learnedSpell);
server/game/Entities/Player/Player.h: TrainerSpellState GetTrainerSpellState(TrainerSpell const* trainer_spell) const;
server/game/Globals/ObjectMgr.cpp: "dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, "
server/game/Globals/ObjectMgr.cpp: creatureTemplate.trainer_spell = fields[37].GetUInt32();
server/game/Globals/ObjectMgr.cpp: if (cInfo->trainer_spell != difficultyInfo->trainer_spell)
server/game/Globals/ObjectMgr.cpp: TC_LOG_ERROR(LOG_FILTER_SQL, "Creature (Entry: %u) has different `trainer_spell` in difficulty %u mode (Entry: %u).", cInfo->Entry, diff + 1, cInfo->DifficultyEntry[diff]);
server/game/Handlers/NPCHandler.cpp: TrainerSpellData const* trainer_spells = unit->GetTrainerSpells();
server/game/Handlers/NPCHandler.cpp: if (!trainer_spells)
server/game/Handlers/NPCHandler.cpp: WorldPacket data(SMSG_TRAINER_LIST, 8+4+4+trainer_spells->spellList.size()*38 + strTitle.size()+1);
server/game/Handlers/NPCHandler.cpp: data << uint32(trainer_spells->trainerType);
server/game/Handlers/NPCHandler.cpp: data << uint32(trainer_spells->spellList.size());
server/game/Handlers/NPCHandler.cpp: for (TrainerSpellMap::const_iterator itr = trainer_spells->spellList.begin(); itr != trainer_spells->spellList.end(); ++itr)
server/game/Handlers/NPCHandler.cpp: TrainerSpellData const* trainer_spells = unit->GetTrainerSpells();
server/game/Handlers/NPCHandler.cpp: if (!trainer_spells)
server/game/Handlers/NPCHandler.cpp: TrainerSpell const* trainer_spell = trainer_spells->Find(spellId);
server/game/Handlers/NPCHandler.cpp: if (!trainer_spell)
server/game/Handlers/NPCHandler.cpp: if (_player->GetTrainerSpellState(trainer_spell) != TRAINER_SPELL_GREEN)
server/game/Handlers/NPCHandler.cpp: uint32 nSpellCost = uint32(floor(trainer_spell->spellCost * _player->GetReputationPriceDiscount(unit)));
server/game/Handlers/NPCHandler.cpp: if (trainer_spell->IsCastable())
server/game/Handlers/NPCHandler.cpp: _player->CastSpell(_player, trainer_spell->spell, true);
server/shared/Database/Implementation/WorldDatabase.cpp: PrepareStatement(WORLD_SEL_CREATURE_TEMPLATE, "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 = ?", CONNECTION_SYNCH);
server/scripts/Commands/cs_reload.cpp: cInfo->trainer_spell = fields[36].GetUInt32();
Ok... I try to compile again the CORE... I will tell you result...
Thanks a lot
-
I'm using 4.3.4 CORE and DB... The latest one for both, cloned this morning...
Simply importing TDB 4.3.4-5 is not enough because, doing this, I get that error... -
I tryed used newer 4.3.4 (5) DB and the lates Core sources but, I got some errors (I did the checkout to branch 4.3.4, first of all).
After compiling (as the same way) the sources (with no error) I followed this steps:- Import " create_mysql.sql " file in the source directory - Import " auth_database.sql " and " characters_database.sql" in the source directory - Import " TDB_full_434.05_2013_07_17.sql " file to world db - Import " TrinityCore_4.3.4_DB_Alpha/updates " SQLs files (there is only " 000_version.sql ")
I can start correctly authserver but when I try to start worldserver, I get this error:
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 world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database...
but I'm sure that connection's parameters are correct! They are the same as authserver.
Where is the problem?
Thanks in advance. -
The guide works however you have to do
git checkout 1b8d917ea9
in the core repo because that's the hash of the last database sync (https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/commit/25736316c80c72fccc11943917a64f54274ed753)
Anyway, I'll release TDB 4.3.4_5 and TDB 3.3.5_52 today or tomorrow.
Thanks a lot, Nay
I will check as soon as possible...
Anyone can confirm that in this way it works?
-
I don't know why you keep telling people to follow the guide. I've said several times, the guide DOES NOT work. If you follow it as written the core will not start. If you import the sql files in "updates" then it will start but with tons of errors.
The problem you run into, after getting around the "table does not exist" issue with importing the updates is that your playercreate_* tables are empty so you can't speak, use GM commands and you start with the wrong gear / spells.
If you want more help developing and testing the 4.3.4 branch then someone really needs to fix the guide and the SQL files.
Right!
Anyway, I will try some methods and, if one of those will work, I will post it here, immediatly!
Thanks for all support.
Have a nice day.
-
No, you don't follow guide, guide tells you DON'T run:
2. for file in TrinityCore_4.3.4/sql/updates/world/*.sql; do mysql -u root -p world < $file; done
I know, but without that step Worldserver didn't start! It wasn't able to find some tables...
I read in some post/issues that is necessary to upload those files...
-
I follwed the guide and the server not work at all (read my first post)
I will try Thugly's solution and report here the result... It will not cost me anything... If works, we have found a solution... If not works, we check again for another procedure...
Anyway, you are right: Cata situation is a mess...
I hope that will be possible to get it running as soon as possible, with a correct (and maybe unique) guide... -
There are no updates in the "old3.3.5a" folders labeled "4.3.4" in the cataclysm repo.
I think he meant:
https://github.com/TrinityCore/TrinityCore/tree/4.3.4/sql/updates/world
-
first install TDB_full_434.04_2013_02_14.sql full world
then check updates in the source directory , you need to install some of the 3.3.5a sql files , these are marked with "4.3.4" at the end I think from memory
there are 5 or 6 of them .
then from your DB directory install the updates for your build making sure you install the updates with the correct date I believe there will be 4 folders
of updates choose the latest and install them in order making sure you do not miss any out
Ok, thanks a lot.
I will check as soon as possible and report here result.
Have a nice day.
-
Hi.
I'm trying to create a server with 4.3.4 branch.
I saw, on this forum and on github repository's pages, that there are some problems with the creation of "world" database.
I follow this sequence:1. mysql -u root -p world < ~/TrinityDB/TDB_full_434.04_2013_02_14.sql 2. for file in TrinityCore_4.3.4/sql/updates/world/*.sql; do mysql -u root -p world < $file; done 3. mysql -u root -p world < ~/TrinityDB/TrinityCore_4.3.4_DB_Alpha/tools/world_updates.sql
Last one SQL file is created by the script "merge_linux.sh" (follow the ufficial guide).
At step 2, I get some errors:ERROR 1146 (42S02) at line 4: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 12: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 1: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 1: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 8: Table 'world.creature_ai_scripts' doesn't exist ERROR 1054 (42S22) at line 4: Unknown column 'race' in 'playercreateinfo_spell' ERROR 1146 (42S02) at line 1: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 3: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 114: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 15: Table 'world.creature_ai_scripts' doesn't exist ERROR 1062 (23000) at line 3: Duplicate entry '6-11-0' for key 'PRIMARY' ERROR 1146 (42S02) at line 81: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 97: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 42: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 1: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 79: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 2: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 87: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 33: Table 'world.creature_ai_scripts' doesn't exist ERROR 1054 (42S22) at line 314: Unknown column 'Dispel' in 'field list' ERROR 1146 (42S02) at line 13: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 3: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 9: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 1: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 4: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 75: Table 'world.creature_ai_scripts' doesn't exist ERROR 1062 (23000) at line 73: Duplicate entry '7094' for key 'PRIMARY' ERROR 1146 (42S02) at line 2: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 13: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 15: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 4: Table 'world.creature_ai_scripts' doesn't exist ERROR 1146 (42S02) at line 2: Table 'world.creature_ai_scripts' doesn't exist
At step 3, I get:
ERROR 1054 (42S22) at line 964: Unknown column 'equipment_id' in 'field list'
Server start correctly, with some WARNINGS, but I can connect with a client to it.
If I create a character, h doesn't have any dress or arms, at the start!
Which is the correct procedure to import DB?
Thanks a lot in advance.
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
Perfect All works fine, now...
Thanks a lot to all of you! Really...