ikir

Fixed updating to lastest trinity core again

@Nay So it was a DB problem not my fault, right? If i compile the source again, it should be fine... i will try soon, wish me luck :-P

I've downloaded compiled trinity core as usuale with those commands: cd ~/Downloads rm -d -f -r ./TrinityCore git clone git://github.com/TrinityCore/TrinityCore.git ./TrinityCore cd ~/Downloads/TrinityCore git checkout 3.3.5 Compiled this way sudo chown -R `whoami` $HOME/Applications/trinityserver rm -d -f -r ~/Downloads/TrinityCore/build mkdir ~/Downloads/TrinityCore/build cd ~/Downloads/TrinityCore/build export PATH=/usr/local:/usr:$PATH /usr/local/bin/cmake ../ -GXcode \ -DPREFIX="$HOME/Applications/trinityserver" \ -DWITH_COREDEBUG=0 \ -DWITH_WARNINGS=1 \ -DTOOLS=1 \ -DSERVERS=1 \ -DSCRIPTS=1 \ -DUSE_SCRIPTPCH=1 \ -DUSE_COREPCH=1 \ -DOPENSSL_CRYPTO_LIBRARIES="/usr/local/lib/libcrypto.a" \ -DOPENSSL_SSL_LIBRARIES="/usr/local/lib/libssl.a" \ -DMYSQL_LIBRARY="$HOME/Applications/trinityserver/mysql/lib/libmysqlclient.a" \ -DMYSQL_CONFIG="$HOME/Applications/trinityserver/mysql/bin/mysql_config" \ -DBoost_THREAD_LIBRARY_DEBUG="/usr/local/lib/libboost_thread.a" \ -DBoost_PROGRAM_OPTIONS_LIBRARY_DEBUG="/usr/local/lib/libboost_program_options.a" \ -DBoost_SYSTEM_LIBRARY_RELEASE="/usr/local/lib/libboost_system.a" \ -DBoost_PROGRAM_OPTIONS_LIBRARY_RELEASE="/usr/local/lib/libboost_program_options.a" \ -DBoost_SYSTEM_LIBRARY_DEBUG="/usr/local/lib/libboost_system.a" \ -DBoost_THREAD_LIBRARY_RELEASE="/usr/local/lib/libboost_thread.a" \ -DMYSQL_CONFIG="$HOME/Applications/trinityserver/mysql/bin/mysql_config" \ -DCMAKE_C_FLAGS="-m64 -Ofast" \ -DCMAKE_CXX_FLAGS="-m64 -Ofast" xcodebuild -alltargets clean xcodebuild -target install -config Release -arch x86_64 -sdk macosx10.9 -jobs $(sysctl -n hw.ncpu) Always done that to compile/update. Without touching the databases if i run my server with updated world server i got error on characters database posted in the older thread. If i start brand new i got this issue instead.

How i managed to do that? :-) World DB is 3.3.5 i've compiled as usuale using 3.3.5 branch.

Hi all again, sorry to open a new thread but after my problems i've restarted with a bran new DB but i keep getting error applying automatic updates. I'm quite desperate now. Using configuration file /usr/local/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.2a 19 Mar 2015 (library: OpenSSL 1.0.2a 19 Mar 2015) Using Boost version: 1.58.0 Database Auth is empty, auto populating it... >> Applying '/Users/ikirserver/Applications/trinityserver/sql/base/auth_database.sql'... Warning: Using a password on the command line interface can be insecure. >> Done! Database Character is empty, auto populating it... >> Applying '/Users/ikirserver/Applications/trinityserver/sql/base/characters_database.sql'... Warning: Using a password on the command line interface can be insecure. >> Done! Database World is empty, auto populating it... >> Applying 'TDB_full_335.58_2015_03_21.sql'... Warning: Using a password on the command line interface can be insecure. >> Done! Updating Auth database... >> Auth database is up-to-date! Containing 11 new and 24 archived updates. Updating Character database... >> Applying update "2015_05_08_00_characters.sql" '0F14B78'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_05_22_00_characters.sql" '65B8215'... Warning: Using a password on the command line interface can be insecure. >> Applied 2 queries. Containing 3 new and 22 archived updates. Updating World database... DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/old/3.3.5a/world" isn't existing, skipped! >> Applying update "2015_03_21_00_world.sql" 'C53246C'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_21_01_world.sql" '0432783'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_21_02_world.sql" '6D86E0C'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_22_00_world.sql" 'D96C821'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_22_01_world.sql" '629EE57'... Warning: Using a password on the command line interface can be insecure. ERROR 1146 (42S02) at line 22: Table 'world.quest_template_addon' doesn't exist Applying of file '/Users/ikirserver/Applications/trinityserver/sql/updates/world/2015_03_22_01_world.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Could not update the World database, see log for details. Assertion failed: (ec == 0), function unlock, file /SourceCache/libcxx/libcxx-120/src/mutex.cpp, line 45. Abort trap: 6 ikir-server:bin ikirserver$ Any idea? I've dowloaded the DB as new but when i run the world server for the fist time i got this

After deleting all and redownloading everything i keep getting this error about word server Using configuration file /usr/local/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.2a 19 Mar 2015 (library: OpenSSL 1.0.2a 19 Mar 2015) Using Boost version: 1.58.0 Database Auth is empty, auto populating it... >> Applying '/Users/ikirserver/Applications/trinityserver/sql/base/auth_database.sql'... Warning: Using a password on the command line interface can be insecure. >> Done! Database Character is empty, auto populating it... >> Applying '/Users/ikirserver/Applications/trinityserver/sql/base/characters_database.sql'... Warning: Using a password on the command line interface can be insecure. >> Done! Database World is empty, auto populating it... >> Applying 'TDB_full_335.58_2015_03_21.sql'... Warning: Using a password on the command line interface can be insecure. >> Done! Updating Auth database... >> Auth database is up-to-date! Containing 11 new and 24 archived updates. Updating Character database... >> Applying update "2015_05_08_00_characters.sql" '0F14B78'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_05_22_00_characters.sql" '65B8215'... Warning: Using a password on the command line interface can be insecure. >> Applied 2 queries. Containing 3 new and 22 archived updates. Updating World database... DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/old/3.3.5a/world" isn't existing, skipped! >> Applying update "2015_03_21_00_world.sql" 'C53246C'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_21_01_world.sql" '0432783'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_21_02_world.sql" '6D86E0C'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_22_00_world.sql" 'D96C821'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_22_01_world.sql" '629EE57'... Warning: Using a password on the command line interface can be insecure. ERROR 1146 (42S02) at line 22: Table 'world.quest_template_addon' doesn't exist Applying of file '/Users/ikirserver/Applications/trinityserver/sql/updates/world/2015_03_22_01_world.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Could not update the World database, see log for details. Assertion failed: (ec == 0), function unlock, file /SourceCache/libcxx/libcxx-120/src/mutex.cpp, line 45. Abort trap: 6 ikir-server:bin ikirserver$ Started a new thread http://community.trinitycore.org/topic/11522-automatic-update-failing-with-a-new-world-db/

But it was working before. Anyway i've started all over but still i got this Using configuration file /usr/local/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.2a 19 Mar 2015 (library: OpenSSL 1.0.2a 19 Mar 2015) Using Boost version: 1.58.0 Updating Auth database... >> Auth database is up-to-date! Containing 11 new and 24 archived updates. Updating Character database... >> Character database is up-to-date! Containing 5 new and 22 archived updates. Updating World database... DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/old/3.3.5a/world" isn't existing, skipped! >> Applying update "2015_03_21_00_world.sql" 'C53246C'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_21_01_world.sql" '0432783'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_21_02_world.sql" '6D86E0C'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_22_00_world.sql" 'D96C821'... Warning: Using a password on the command line interface can be insecure. >> Applying update "2015_03_22_01_world.sql" '629EE57'... Warning: Using a password on the command line interface can be insecure. ERROR 1146 (42S02) at line 22: Table 'world.quest_template_addon' doesn't exist Applying of file '/Users/ikirserver/Applications/trinityserver/sql/updates/world/2015_03_22_01_world.sql' to database 'world' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query. Could not update the World database, see log for details.Already download again world DB, i will try again.

I got this after quitting and relaunching the server. I've tried to redownload all the world server but the problem seems the characters database. My uutomatic update is set to 7 Using configuration file /usr/local/etc/worldserver.conf. Using SSL version: OpenSSL 1.0.2a 19 Mar 2015 (library: OpenSSL 1.0.2a 19 Mar 2015) Using Boost version: 1.58.0 Updating Auth database... DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/updates/auth" isn't existing, skipped! >> Auth database is up-to-date! Containing 0 new and 7 archived updates. Updating Character database... DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/updates/characters" isn't existing, skipped! >> Character database is up-to-date! Containing 0 new and 3 archived updates. Updating World database... DBUpdater: Given update include directory "/Users/ikirserver/Applications/trinityserver/sql/updates/world" isn't existing, skipped! >> World database is up-to-date! Containing 0 new and 338 archived updates. In mysql_stmt_prepare() id: 32, sql: "SELECT guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, position_x, position_y, position_z, map, orientation, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, online, death_expire_time, taxi_path, instance_mode_mask, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, instance_id, talentGroupsCount, activeTalentGroup, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, grantableLevels FROM characters WHERE guid = ?" Unknown column 'talentGroupsCount' in 'field list' In mysql_stmt_prepare() id: 35, sql: "SELECT casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges FROM character_aura WHERE guid = ?" Unknown column 'casterGuid' in 'field list' In mysql_stmt_prepare() id: 56, sql: "SELECT a.button, a.action, a.type FROM character_action as a, characters as c WHERE a.guid = c.guid AND a.spec = c.activeTalentGroup AND a.guid = ? ORDER BY button" Unknown column 'c.activeTalentGroup' in 'where clause' In mysql_stmt_prepare() id: 72, sql: "SELECT talentGroup, glyph1, glyph2, glyph3, glyph4, glyph5, glyph6 FROM character_glyphs WHERE guid = ?" Unknown column 'talentGroup' in 'field list' In mysql_stmt_prepare() id: 73, sql: "SELECT spell, talentGroup FROM character_talent WHERE guid = ?" Unknown column 'talentGroup' in 'field list' In mysql_stmt_prepare() id: 171, sql: "INSERT INTO character_aura (guid, casterGuid, itemGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Unknown column 'casterGuid' in 'field list' In mysql_stmt_prepare() id: 233, sql: "REPLACE INTO gm_ticket (id, playerGuid, name, description, createTime, mapId, posX, posY, posZ, lastModifiedTime, closedBy, assignedTo, comment, response, completed, escalated, viewed, needMoreHelp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Table 'characters.gm_ticket' doesn't exist In mysql_stmt_prepare() id: 234, sql: "DELETE FROM gm_ticket WHERE id = ?" Table 'characters.gm_ticket' doesn't exist In mysql_stmt_prepare() id: 236, sql: "DELETE FROM gm_ticket WHERE playerGuid = ?" Table 'characters.gm_ticket' doesn't exist In mysql_stmt_prepare() id: 237, sql: "INSERT INTO gm_survey (guid, surveyId, mainSurvey, comment, createTime) VALUES (?, ?, ?, ?, UNIX_TIMESTAMP(NOW()))" Table 'characters.gm_survey' doesn't exist In mysql_stmt_prepare() id: 238, sql: "INSERT INTO gm_subsurvey (surveyId, questionId, answer, answerComment) VALUES (?, ?, ?, ?)" Table 'characters.gm_subsurvey' doesn't exist In mysql_stmt_prepare() id: 240, sql: "INSERT INTO characters (guid, account, name, race, class, gender, level, xp, money, playerBytes, playerBytes2, playerFlags, map, instance_id, instance_mode_mask, position_x, position_y, position_z, orientation, trans_x, trans_y, trans_z, trans_o, transguid, taximask, cinematic, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, knownCurrencies, watchedFaction, drunk, health, power1, power2, power3, power4, power5, power6, power7, latency, talentGroupsCount, activeTalentGroup, exploredZones, equipmentCache, ammoId, knownTitles, actionBars, grantableLevels) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" Unknown column 'talentGroupsCount' in 'field list' In mysql_stmt_prepare() id: 241, sql: "UPDATE characters SET name=?,race=?,class=?,gender=?,level=?,xp=?,money=?,playerBytes=?,playerBytes2=?,playerFlags=?,map=?,instance_id=?,instance_mode_mask=?,position_x=?,position_y=?,position_z=?,orientation=?,trans_x=?,trans_y=?,trans_z=?,trans_o=?,transguid=?,taximask=?,cinematic=?,totaltime=?,leveltime=?,rest_bonus=?,logout_time=?,is_logout_resting=?,resettalents_cost=?,resettalents_time=?,extra_flags=?,stable_slots=?,at_login=?,zone=?,death_expire_time=?,taxi_path=?,arenaPoints=?,totalHonorPoints=?,todayHonorPoints=?,yesterdayHonorPoints=?,totalKills=?,todayKills=?,yesterdayKills=?,chosenTitle=?,knownCurrencies=?,watchedFaction=?,drunk=?,health=?,power1=?,power2=?,power3=?,power4=?,power5=?,power6=?,power7=?,latency=?,talentGroupsCount=?,activeTalentGroup=?,exploredZones=?,equipmentCache=?,ammoId=?,knownTitles=?,actionBars=?,grantableLevels=?,online=? WHERE guid=?" Unknown column 'talentGroupsCount' in 'field list' In mysql_stmt_prepare() id: 413, sql: "DELETE FROM character_talent WHERE guid = ? AND spell = ? AND talentGroup = ?" Unknown column 'talentGroup' in 'where clause' In mysql_stmt_prepare() id: 414, sql: "INSERT INTO character_talent (guid, spell, talentGroup) VALUES (?, ?, ?)" Unknown column 'talentGroup' in 'field list' In mysql_stmt_prepare() id: 429, sql: "INSERT INTO pet_aura (guid, casterGuid, spell, effectMask, recalculateMask, stackCount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxDuration, remainTime, remainCharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Unknown column 'casterGuid' in 'field list' Could not prepare statements of the Character database, see log for details. Any hint? :-O I've copied the latest core and running on OS X 10.10.3

The server in my experience is very very stable (we are about 12-15 players only aniway), the problem to use it with friends are all quest and dungeon bugs.

Hi all! Is it possible to configure tokens using PvPToken.Enable to give the player 1 of each type of pvp token in game? Can i use multiple PvPToken.ItemID I would love my players to be able to buy PVP items with token even if players base is low, so with this thing they could ear more tokens.