[Compile or cmake problems]

See http://www.trinitycore.org/f/topic/10854-visual-studio-2013-express-deprecation-windows/

 

 

I have the same problem, even though i uninstalled express and installed the community one.

 

error LNK1181: cannot open input file 'C:mysql_libslib_32libmysql.lib' bnetserver

error LNK1181: cannot open input file 'C:mysql_libslib_32libmysql.lib' worldserver

 

Same error but different error code, i guess..

 

I also forgot to mention that i got 4 warnings in express that i also got in community

 

warning C4065: switch statement contains 'default' but no 'case' labels MovementHandler.cpp

warning C4065: switch statement contains 'default' but no 'case' labels VehicleHandler.cpp

warning C4065: switch statement contains 'default' but no 'case' labels MovementStructures.cpp

warning C4065: switch statement contains 'default' but no 'case' labels WorldSession.cpp

 

// CRHASH

[Compile or cmake problems]

See http://www.trinitycore.org/f/topic/10854-visual-studio-2013-express-deprecation-windows/

ah i guess it was some time last i compiled heh

[Compile or cmake problems]

Hello !

I am getting compiling errors in vs 13 express

 

error LNK1104: cannot open file 'C:mysql_libslib_64libmysql.lib' bnetserver

error LNK1104: cannot open file 'C:mysql_libslib_64libmysql.lib' worldserver

 

I have tried both C:/mysql_libs/lib_64/libmysql.lib and C:/mysql_libs/lib_32/libmysql.lib in cmake under MYSQL_LIBRARY

 

Also i've done the things you need to do in vs 13 

change to  release and win32

right click ALL_BUILD and clean and then start the build

 

And yes i have extracted the actual mysql_libs folder to the c root.

 

And if it makes any difference i am trying to compile the 6.x

 

// CRHASH

 

Edit: and i don`t get any errors in cmake

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

I have solved my problem.

This is how i did it:

Deleted my world and added this sql file first TDB_full_434.05_2013_07_17.sql

Then downloaded this https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha and updated everything

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

If you downloaded as zip, the rev will not show.

that explains it

 

Edit:

I recombiled with cloning the branch this time

And the same database errors come up when i start worldserver

In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? WHERE entry = ?"
Unknown column 'faction' in 'field list'
In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextID FROM creature_text"
Unknown column 'BroadcastTextID' in 'field list'
In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'
In mysql_stmt_prepare() id: 54, 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, exp_unk, faction, 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_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, 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, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'faction' in 'field list'

but now the worldserver looks like this

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1g 7 Apr 2014 (library: OpenSSL 1.0.1g 7 Apr 2014)
Using ACE version: 6.1.4
TrinityCore rev. 3b9da8498fe2 2014-05-04 12:10:52 +0200 (4.3.4 branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
     /`'__/  /' _ `/   / / / 
        /   / /     _  _ 
      _ _   _ _ _ _ __/`____ 
      /_//_/   /_//_//_//_//__/ `/___/> 
                                 C O R E  /___/
http://TrinityCore.org                    /__/

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;ascent;world

so is their anyone that could help me with the database 

 

Edit:

solved one error by adding the 2013_08_30_01_world_command.sql file from TrinityCoresqlold3.3.5aTDB52_to_TDB53_updatesworld

this one

In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'

Edit

Solved this one

In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextID FROM creature_text"
Unknown column 'BroadcastTextID' in 'field list'

by adding this one 2014_05_04_00_world_creature_template from TrinityCoresqlupdatesworld

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

if you had done that properly, it would show an actual revision, but, that doesn't even matter, since 4.3.4 is NOT SUPPORTED, do you not know what that means?

ok i can try and compile again and see. But that does not change the database error i guess . Yes i know 4.3.4 is not supported and buggy as hell.

 

// CRHASH

 

Edit: does it matter if i download the zip manually or clone it with git

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

TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)

So first thing is first.

http://www.trinitycore.org/f/topic/345-howto-properly-install-git-on-windows-fix-trinitycore-rev-1970-01-01-000000-0000/

I've done that, could not start compile without doing that.

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

Hello

Just finished my first compile of the 4.3.4 trinitycore, and i have some problem starting the worldserver.

 

Here's my worldserver log file

Using configuration file worldserver.conf.
Using SSL version: OpenSSL 1.0.1g 7 Apr 2014 (library: OpenSSL 1.0.1g 7 Apr 2014)
Using ACE version: 6.1.4
TrinityCore rev. unknown 1970-01-01 00:00:00 +0000 (Archived branch) (Win32, Release) (worldserver-daemon)
<Ctrl-C> to stop.

 ______                       __
/__  _       __          __/ __
/_/ / _ __ /_    ___ /_ , _  __  __
     /`'__/  /' _ `/   / / / 
        /   / /     _  _ 
      _ _   _ _ _ _ __/`____ 
      /_//_/   /_//_//_//_//__/ `/___/> 
                                 C O R E  /___/
http://TrinityCore.org                    /__/

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;ascent;world

And the DBErrors file with the actual error

In mysql_stmt_prepare() id: 16, sql: "UPDATE creature_template SET faction = ? WHERE entry = ?"
Unknown column 'faction' in 'field list'
In mysql_stmt_prepare() id: 3, sql: "SELECT entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextID FROM creature_text"
Unknown column 'BroadcastTextID' in 'field list'
In mysql_stmt_prepare() id: 53, sql: "SELECT name, permission, help FROM command"
Unknown column 'permission' in 'field list'
In mysql_stmt_prepare() id: 54, 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, exp_unk, faction, 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_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, type_flags2, 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, Mana_mod_extra, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, mechanic_immune_mask, flags_extra, ScriptName FROM creature_template WHERE entry = ?"
Unknown column 'faction' in 'field list'

My Worldserver.conf looks like this with the mysql settings

#
#    LoginDatabaseInfo
#    WorldDatabaseInfo
#    CharacterDatabaseInfo
#        Description: Database connection settings for the world server.
#        Example:     "hostname;port;username;password;database"
#                     ".;somenumber;username;password;database" - (Use named pipes on Windows
#                                                                 "enable-named-pipe" to [mysqld]
#                                                                 section my.ini)
#                     ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
#                                                                           Unix/Linux)
#        Default:     "127.0.0.1;3306;trinity;trinity;auth"       - (LoginDatabaseInfo)
#                     "127.0.0.1;3306;trinity;trinity;world"      - (WorldDatabaseInfo)
#                     "127.0.0.1;3306;trinity;trinity;characters" - (CharacterDatabaseInfo)

LoginDatabaseInfo     = "127.0.0.1;3306;root;ascent;auth"
WorldDatabaseInfo     = "127.0.0.1;3306;root;ascent;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"

Auth starts up correctly and uses the same login

# MYSQL SETTINGS
#
#    LoginDatabaseInfo
#        Description: Database connection settings for the realm server.
#        Example:     "hostname;port;username;password;database"
#                     ".;somenumber;username;password;database" - (Use named pipes on Windows
#                                                                 "enable-named-pipe" to [mysqld]
#                                                                 section my.ini)
#                     ".;/path/to/unix_socket;username;password;database" - (use Unix sockets on
#                                                                           Unix/Linux)
#        Default:     "127.0.0.1;3306;trinity;trinity;auth"

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

I have used the auth_database and the characters_database from TrinityCore-4.3.4sqlbase

And TDB_full_434.05_2013_07_17 for world

 

 

// CRHASH