Jump to content
TrinityCore

vladex

Members
  • Posts

    25
  • Joined

  • Last visited

Everything posted by vladex

  1. Everything seems to compiling and runnning fine now !. Thank you.
  2. Issue still persists after commit 17539f1cb319f0d8d089038a4b10924d145ee248 . Seems to be somewhere else. Getting the same error when trying to load Spell Rank Data. Loading Game Object Templates... >> Loaded 21567 game object templates in 616 ms Loading Game Object template addons... >> Loaded 21500 game object template addons in 201 ms Loading Transport templates... >> Loaded 30 transport templates in 13 ms Loading Transport animations and rotations... Loading Spell Rank Data... [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 '' at line 1 Error while parsing SQL. Core fix required.
  3. Sorry for being such a bother, but the problem with the SQL parsing still exists, on a different table this time it seems, I've applied all world updates , still getting when running worldserver. ou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1.
  4. Hello, I've been gone for a good while from wow and from wow emulation. I'd like to at least try to learn more about the tc code in general, is there any proper documentation from top to bottom that describes the packages, libraries and API used in the TC code ? I find the guide on atlassian a bit short. Thank you.
  5. Tested new build. Getting [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 '' at line 1 Error while parsing SQL. Core fix required. When loading Spell Rank Data. Will attempt to see if I can fix.
  6. I've just tested the new build on a fresh debian 9 VM (no other packages installed besides system utilities and gnome-core) , no errors , the only thing I've installed is the following packages: apt-get install git clang cmake make gcc g++ libmariadbclient-dev libssl1.0-dev libbz2-dev libreadline-dev libncurses-dev libboost-all-dev mysql-server p7zip Obviously taken from the guide at: https://trinitycore.atlassian.net/wiki/spaces/tc/pages/10977288/Linux+Requirements After installing the packages I've created a build directory in the trinityCore solution folder: mkdir build cd build cmake ../ -DCMAKE_INSTALL_PREFIX=/home/[your_username_here]/server_path_folder -DTOOLS=0 make make -j 8 // using this since I've only got 8 cores on this machine make install That's it. With that being said. I will test the new build to see if I still get the same runtime errors.
  7. Like I said, the error you had I usually got from compiling with a mysql version that is not installed via the installer. I do not comprehend why it doesn't work, but I'm assuming that the installer version has extra libraries for debugging/development etc. It is also the only solution that worked for me so far, I've been gone from trinity for ~ 2-3 years so I decided to check it out and see what's new, I pulled the source yesturday and got stuck at exactly the same problem (but on windows instead) . I might try to do it on my linux VM soon to see if I also get it .
  8. I have no idea why but i'm still getting the same group error as before. And the debug message is useless since it doesnt show me where is the query that errors out.
  9. Since it seems you are compiling it on linux, I am not sure this solution will work. I usually got this error on windows when using the portable mysql version. I fixed by installing the .msi installer version of mysql 5.6. You should do the same by using the .deb installer version or whatever package installer your linux distro uses.
  10. Tested new build. Still getting [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 'groups' at line 1 Error while parsing SQL. Core fix required. I've no idea where is this coming from.
  11. Managed to get past the problem by escaping MySQL reserved words . PrepareStatement(WORLD_SEL_CREATURE_TEMPLATE, "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, ctm.Ground, ctm.Swim, ctm.Flight, ctm.Rooted, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ?", CONNECTION_SYNCH); Not sure this is good enough. I am now getting : [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 'groups' at line 1 .
  12. I've just tested the new build . Getting this now : In mysql_stmt_prepare() id: 55, 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, ctm.Ground, ctm.Swim, ctm.Flight, ctm.Rooted, HoverHeight, HealthModifier, ManaModifier, ArmorModifier, DamageModifier, ExperienceModifier, RacialLeader, movementId, RegenHealth, mechanic_immune_mask, spell_school_immune_mask, flags_extra, ScriptName FROM creature_template ct LEFT JOIN creature_template_movement ctm ON ct.entry = ctm.CreatureId WHERE entry = ?"
  13. A quick inspection in the characters DB reveals that the guild_member table has a field named rank, with a record that cannot be prepared for insertion. I'm not sure what updates must be applied, but I reckon applying all updates from 'sql/old/3.3.5a/characters' folder will solve the problem. I've got the same issue at the moment, will post an update shortly.
×
×
  • Create New...