CRHASH

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

ah i guess it was some time last i compiled heh

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

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

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

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

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

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