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

Bioaim

Plebs
 View Profile  See their activity

  • Posts

    11

  • Joined

  • Last visited

 Content Type 

Posts posted by Bioaim

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

    in Help and Support

    Posted

    thank you very much, auth is working now...

     

    but i have worldserver problems:

     

    Realm running as realm ID 1
    Using World DB: TDB 335.51
    Will clear `logs` table of entries older than 1209600 seconds every 10 minutes.
    Using DataDir ./
    WORLD: MMap data directory is: ./mmaps
    VMap support included. LineOfSight: 1, getHeight: 1, indoorCheck: 1
    VMap data directory is: ./vmaps
    Loading Trinity strings...
    >> Loaded 1026 Trinity strings from table trinity_string in 3 ms
    Initialize data stores...
    >> Initialized 98 data stores in 202 ms
    Using deDE DBC Locale as default. All available DBC locales: deDE
    Loading spell dbc data corrections...
    >> Loaded spell dbc data corrections in 3 ms
    Loading SpellInfo store...
    >> Loaded spell custom attributes in 28 ms
    Loading SkillLineAbilityMultiMap Data...
    >> Loaded 10219 SkillLineAbility MultiMap Data in 3 ms
    Loading spell custom attributes...
    >> Loaded spell custom attributes in 17 ms
    Loading GameObject models...
    Loading Script Names...
    >> Loaded 2149 Script Names in 99 ms
    Loading Instance Template...
    >> Loaded 83 instance templates in 1 ms
    Loading instances...
    >> Loaded instances in 2 ms
    Loading Localization strings...
    >> Localization strings loaded in 4 ms
    Loading Account Roles and Permissions...
    >> Loaded 47 permission definitions, 39 role definitions and 4 group definitions in 1 ms
    Loading Page Texts...
    >> Loaded 1834 page texts in 8 ms
    Loading Game Object Templates...
    >> Loaded 19061 game object templates in 178 ms
    Loading Spell Rank Data...
    >> Loaded 5593 spell rank records in 8 ms
    Loading Spell Required Data...
    >> Loaded 41 spell required records in 1 ms
    Loading Spell Group types...
    >> Loaded 461 spell group definitions in 1 ms
    Loading Spell Learn Skills...
    >> Loaded 99 Spell Learn Skills from DBC in 3 ms
    Loading Spell Learn Spells...
    >> Loaded 8 spell learn spells + 572 found in DBC in 3 ms
    Loading Spell Proc Event conditions...
    >> Loaded 1085 extra and 59 custom spell proc event conditions in 4 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 332 extra spell bonus data in 1 ms
    Loading Aggro Spells Definitions...
    >> Loaded 106 SpellThreatEntries in 1 ms
    Loading Spell Group Stack Rules...
    >> Loaded 53 spell group stack rules in 1 ms
    Loading NPC Texts...
    >> Loaded 6044 npc texts in 161 ms
    Loading Enchant Spells Proc datas...
    >> Loaded 42 enchant proc data definitions in 1 ms
    Loading Item Random Enchantments Table...
    >> Loaded 28607 Item Enchantment definitions in 39 ms
    Loading Disables
    >> Loaded 802 disables in 3 ms
    Loading Items...
    >> Loaded 37294 item templates in 1123 ms
    Loading Item set names...
    >> Loaded 2481 item set names in 4 ms
    Loading Creature Model Based Info Data...
    >> Loaded 24142 creature model based info in 47 ms
    Loading Creature templates...
    >> Loaded 29923 creature definitions in 715 ms
    Loading Equipment templates...
    [1054] Unknown column 'id' in 'field list'
    Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.

     

     

    Then worldserver.exe crashes and a window appears with " worldserver.exe doens't work anymore" ( i dont know the exaclty translation, im an austrian )

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

    in Help and Support

    Posted

    okay guys, i fixed the problem with the binaries now!

     

    But now there is an error with autobroadcast or something:

     

    TrinityCore rev. 9664c0ab5cc7+ 2013-05-30 13:18:29 +0200 (master branch) (Win32, Release) (authserver)
    <Ctrl-C> to stop.

    Using configuration file authserver.conf.
    OpenSSL 1.0.1e 11 Feb 2013 (Library: OpenSSL 1.0.1e 11 Feb 2013)
    Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.
    MySQL client library: 5.5.9
    MySQL server ver: 5.5.27
    Connected to MySQL database at 127.0.0.1
    MySQL client library: 5.5.9
    MySQL server ver: 5.5.27
    Connected to MySQL database at 127.0.0.1
    In mysql_stmt_prepare() id: 69, sql: "SELECT id, weight, text FROM autobroadcast WHERE realmid = ? OR realmid = -1"
    Table 'auth.autobroadcast' doesn't exist
    DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
    Cannot connect to database

     

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

    in Help and Support

    Posted · Edited by Bioaim

    Do i have to use that MySQL Community Server or am i allowed to use local MySQL via xampp ?

     

    edit:

     

    when i import the create_mysql.sql file the first line USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ; gets an error, only when i delete this line i am able to execute the script.

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

    in Help and Support

    Posted

    hi guys,

     

    i followed the installation guide for trinity core. i installed all the tools, compiled the source, installed the database, extracted vmaps and configured the auth- and worldserver.conf files .

     

    But when i want to start the authserver.exe it gives me an error.  ( the console doesn't do anything )

     

     

    my bin/Release folder contains the following files:

    • dbc
    • maps
    • vmaps
    • ace.dll
    • authserver.conf
    • authserver.exe
    • libeay32.dll
    • libmysql.dll
    • ssleay32.dll
    • worldserver.conf
    • world.server.exe
    • mapextractor.exe
    • vmap4assembler.exe
    • vmap4extractor.exe

     

     

    I hope anyone can help me to get the server started.

     

    sincerely,

     

    bioaim

×
×
  • Create New...