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

Djokx

Members
 View Profile  See their activity

  • Posts

    23

  • Joined

  • Last visited

 Content Type 

Posts posted by Djokx

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

    in Help and Support

    Posted

    Hi,

    So I just made a new install of TrinityCore on my new server.

    I'm using Debian 6.0 64Bytes and I've a problem with the lauch of authserver :

    
Using configuration file /home/Serveur/etc/authserver.conf.

Opening DatabasePool 'auth'. Asynchronous connections: 1, synchronous connections: 1.

MySQL client library: 5.1.61

MySQL server ver: 5.1.61-0+squeeze1

[ERROR]: In mysql_stmt_prepare() id: 11, sql: "UPDATE account SET sessionkey = ?, last_ip = ?, last_login = NOW(), locale = ?, failed_logins = 0, os = ? WHERE username = ?"

[ERROR]: Unknown column 'os' in 'field list'

MySQL client library: 5.1.61

MySQL server ver: 5.1.61-0+squeeze1

[ERROR]: In mysql_stmt_prepare() id: 0, sql: "SELECT id, name, address, port, icon, flag, timezone, allowedSecurityLevel, population, gamebuild FROM realmlist WHERE flag <> 3 ORDER BY name"

[ERROR]: Unknown column 'flag' in 'field list'

[ERROR]: In mysql_stmt_prepare() id: 17, sql: "SELECT id, sessionkey, last_ip, locked, v, s, expansion, mutetime, locale, recruiter, os FROM account WHERE username = ?"

[ERROR]: Unknown column 'os' in 'field list'

DatabasePool auth NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.

Cannot connect to database

    I actually well conf the authserver.conf with :

    LoginDatabaseInfo = "127.0.0.1;3306;root;MyPassword;auth"

    Do you know where the problem could come from ?

    Thanks,

    Djokx.

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

    in Help and Support

    Posted · Edited by Djokx

    This one -> http://code.google.c...ls.zip&can=1&q= [8902] Maptools.zip

    And i just ran mapextractor.exe.

    Right, used the TDB full but I have an error on the server starting on :

    Loading Quests...

    SQL: SELECT Id, Method, Level, MinLevel, MaxLevel, ....

    ERROR: [1054] Unknown column 'Id' in 'field list'

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

    in Help and Support

    Posted

    Hi,

    I know that this question has already been ask many times but I didn't find a working answer.

    So I put my DBC/Maps/vMaps in the "DirData" directory.

    I extract them from my 3.3.5.12340 client with http://code.google.com/p/trinitycore/downloads/detail?name=%5B8902%5D%20Maptools.zip&can=1&q=

    And when I try to run the ./worldserver, an error appears.

    /root/DirData/dbc/Spell.dbc (exists, but has 234 fields instead of 234) Possible wrong client version.

    I also update the world database with the spell updates :

    ~/TrinityCore/sql/updates/world# mysql -uroot -p***** --database world < 2011_12_18_02_world_spell_script_names.sql

    ~/TrinityCore/sql/updates/world# mysql -uroot -p***** --database world < 2011_12_16_00_world_spell_bonus_data.sql

    ~/TrinityCore/sql/updates/world# mysql -uroot -p***** --database world < 2011_12_10_00_world_spell_proc_event.sql

    ~/TrinityCore/sql/updates/world# mysql -uroot -p***** --database world < 2011_11_29_00_world_spell_script.sql

    ~/TrinityCore/sql/updates/world#

    But the problem is still here ...

    Can someone give me a path ? Thanks !

    Djokx.

×
×
  • Create New...