Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

kcraptor82

Plebs
 View Profile  See their activity

  • Posts

    5

  • Joined

  • Last visited

 Content Type 

Posts posted by kcraptor82

  1. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted

    I just love how much support is asked for (and, received) for the UNSUPPORTED 4.3.4 branch... especially people who have no business trying to run 4.3.4.

     

    I do appreciate the answers, and I know that 4.3.4 is unsupported. I also know that their is better support for 3.3.5, but I don't want to run that atm. Just because something is not supported, that doesn't mean that it shouldn't even be messed with. If that was the logic, then the fine folks here wouldn't even bother to have anything related to 4.3.4 on their site. So if you have nothing helpful to contribute, then please keep your negative comments to yourself!

    Chazy Chaz, I really do appreciate the information you have given. That made more sense and do appreciate you spending the time to explain that to me. When I first done this I must of cloned the wrong thing, but after carefully going over everything again and realizing what I did, I got it working! There are alot of spell errors and such, but hey, I knew what I was getting into when I went with the unsupported 4.3.4 branch. I did try the way you explained, and tried the Git Bash. Anyhow thank you again for all your help. I have another question, and yes it does involve the 4.3.4 branch, but that is for another post. I really want to learn more about how this system works and want to contribute.

  2. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted

    So far I have re-followed the guide, but I am on the section where you have to import the SQL files.

    I imported: C:TrinitySourcesqlbasecharacters_database.sql - and it came up with a "Warning" Your query produced 2 warnings. Warnings from last query:

    Anybody else have this issue?


     

     

    kcraptor82, if you want to compile and use 4.3.4 branch, first you must select that branch on your local repository. Use "git checkout 4.3.4" in your repo folder to switch to that branch. And compile again ofc, and extract dbc, maps, vmaps from 4.3.4 game client.

     

    I went and redone the clone, but how would I of done this if I hadn't. I looked thru the git options, but couldn't figure out where this "git checkout" was. Also I have the dbc, maps, & vmaps ready.

     

     

     

    The best way to run 4.3.4 is using the last DB release commit to compile and be able to use the full db without single sql updates, and wait to sync the updates that are not importable by the moment (in 4.3.4_DB_Alpha repository will be updated with syncs). Use this "b95b19b3cb21f0b51481c71b77ac58bf7268b2c4" to compile from.

     

    I am using this DB from: http://www.trinitycore.org/f/files/download/9-tdb-full-434/ - I got TDB_full_434.05_2013_07_17.7z

     

    How would I wait to sync? I already cloned all directories required. Plus what would I do with this "b95b19b3cb21f0b51481c71b77ac58bf7268b2c4"?

  3. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted · Edited by kcraptor82

     

    I thought I did the 4.3.4 branch when I ran the Git Clone.

     

    Part of guide I followed: http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-GitCloning

     

    Fill in the data as follows:
    Repository to clone: https://github.com/TrinityCore/TrinityCore.git

    Destination: C:TrinitySource

    Subdirectory to create: <none> (delete anything in this field)

    Branch: 4.3.4 (The Master branch is currently the 3.3.5a Wrath of the Lich King server, so be sure to select 4.3.4 for Cata)

    Personal Repository: Yes

     
    Either way, I may have mistakenly done the master one. I will go thru the guide again, thank you for pointing that out.

  4. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted

    No matter what I do, and have redone it several times, looked over guides, search forums, but yet still can't find a answer that I could understand. Everything seems to work, but can't get the darn worldserver to start! I keep getting this:

     

    C:TrinityCore>worldserver
    Using configuration file worldserver.conf.
    Using SSL version: OpenSSL 1.0.1e 11 Feb 2013 (library: OpenSSL 1.0.1e 11 Feb 20
    13)
    Using ACE version: 6.1.4
    TrinityCore rev. b4d2796e3322 2013-07-27 02:37:48 +0200 (master branch) (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_entr
    y_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3,
     modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, fac
    tion_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg,
    dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_cl
    ass, 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, resista
    nce3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spe
    ll5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName
    , MovementType, InhabitType, HoverHeight, Health_mod, Mana_mod, Armor_mod, Racia
    lLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6,
     movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM cre
    ature_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 127.0.0.1;3306;root;********;world
     
    C:TrinityCore>

     

    I have done this:

     

    Recompiled

     

    Git the source again

     

    Done exactly what this guides tells me to do: http://collab.kpsn.org/display/tc/How-To_Win+4.3.4#How-To_Win4.3.4-ConfigurationFiles

     

    Yes, I have looked over this: http://www.trinitycore.org/f/topic/1518-trouble-with-your-trinity-install-readme-1st-faqs/

     

    Have searched forums, and still can't find an answer that I can understand!

     

    I know SQL is running, I have it running all the time and can connect just fine using HeidiSQL, etc.

     

    Loaded this DB: TDB_full_434.05_2013_07_17.sql (3 times with and without updates!)

     

    Loaded these updates from the following folders:

    *C:TrinitySourcesqlupdatescharacters

    *C:TrinitySourcesqlupdatesworld

    *C;TrinityDBupdates

     

    I have also did the Git Pull command to make sure all files were up to date on the TrinitySource & TrinityDB folders.

     

    So please don't complain that I am trying to use the 4.3.4 DB. I know it is beta, I know it will have problems, but I just want the stupid thing to start! I have been using repacks and now I wanted to try and see the wonderful work that the Trinity Team has done without someone already screwing with it with a repack. Thanks

×
×
  • Create New...