Burrfoot

Try to update your characters DB with provided sql update in [400] revision (sql/updates folder). This fix only takes care of the 'difficulty' default issue, but doesn't seem to address the issue with the UNIX_TIMESTAMP

I, too, keep getting the error in my console: 2010-09-28 19:28:43 SQL: REPLACE INTO character_feed_log (guid, type, data, date, counter) VALUES('67', '1', '696', UNIX_TIMESTAMP(NOW()), 1) Unforutnately, this seems to cause my server to crash.

Did you edit your .htaccess file?

trinity or mangos?

Ok. Please disregard everything that I've stated concerning the tables...I was confusing myself, however, the Statistics tab still doesn't display any information.

Thanks for the help, but if you read my comment completely, you'll see that the patch WAS applied to the characters database. This is the character database update that is provided in the tools directory: DROP TABLE IF EXISTS `armory_character_stats`; CREATE TABLE `armory_character_stats` ( `guid` int(11) NOT NULL, `data` longtext NOT NULL, PRIMARY KEY (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='World of Warcraft Armory table'; DROP TABLE IF EXISTS `character_feed_log`; CREATE TABLE `character_feed_log` ( `guid` int(11) NOT NULL, `type` smallint(1) NOT NULL, `data` int(11) NOT NULL, `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `counter` int(11) NOT NULL, PRIMARY KEY (`guid`,`type`,`data`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `armory_game_chart`; CREATE TABLE `armory_game_chart` ( `gameid` int(11) NOT NULL, `teamid` int(11) NOT NULL, `guid` int(11) NOT NULL, `changeType` int(11) NOT NULL, `ratingChange` int(11) NOT NULL, `teamRating` int(11) NOT NULL, `damageDone` int(11) NOT NULL, `deaths` int(11) NOT NULL, `healingDone` int(11) NOT NULL, `damageTaken` int(11) NOT NULL, `healingTaken` int(11) NOT NULL, `killingBlows` int(11) NOT NULL, `mapId` int(11) NOT NULL, `start` int(11) NOT NULL, `end` int(11) NOT NULL, PRIMARY KEY (`gameid`,`teamid`,`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='WoWArmory Game Chart'; Nowhere in there is a character_arena_stats table created.

It looks like most everything is working! Looks great, although I did find a few things: the Statistics tab on the character view screen doesn't contain any info, I get the XML parsing error, which tells me that there is no info to display. I get this error in debug log. Characters::BuildCharacter : player 1 (Burrfoot) does not have any data in `armory_character_stats` table (SQL update to characters DB not applied?) The thing is, the update WAS applied...when looking through the update provided in the Tools folder for trinity, I found no reference to the table mentioned in the error. Also, not all 3d models will display. I'm assuming it's because there are missing textures. Is there anyway to get my hands on updated textures? The calendar returns an error saying that not all data could be loaded, and to try again in a few minutes. I read through the debug log but didn't find anything in reference to the calendar issue. When I looked at my server console, I noticed that this error kept popping up: query ERROR: Table 'characters.character_arena_stats' doesn't exit SQL: SELECT personal_rating, matchmaker_rating FROM character_arena_stats WHERE guid='1' AND slot='2' Is it something I need to worry about? All in all, a VERY well done project! Thanks a lot!

Ok, thanks to everyone for their help with the debugging. I was able to successfully compile TC2 Rev 9709! About to test out the armory now.

Where are you guys finding these revisions, cuz the latest revision I've seen is 9036!

Did it actually compile for you roelv?

I just downloaded the 381 revision, tried to compile it, and unfortunately, like roelv, it fails due to some lines in the Battleground.cpp file. I am using the latest revision of TrinityCore2. Error C2440: 'delete' : cannot convert from 'QueryResult_AutoPtr' to 'void *' File: Battleground.cpp Line: 749 Column:1 Project: game Error C2065: 'winner_rating' : undeclared identifier File: Battleground.cpp Line: 765 Column: 1 Project: game Error C2065: 'loser_rating' : undeclared identifier File:Battleground.cpp Line: 772 Column: 1 Project: game

Ok...I've decided to start from scratch with everything to see what happens. I pulled the latest Rev from TrinityCore2, which is revision 9528. Then I got the latest revision of your armory and started the install. When I went to apply the patches to TC2, both patches failed. Here is a copy of the errors I received: applying wowarmory_arena_chart.patch patching file src/server/game/Battlegrounds/Battleground.cpp Hunk #1 FAILED at 737 Hunk #2 FAILED at 1343 2 out of 2 hunks FAILED -- saving rejects to file src/server/game/Battlegrounds/ Battleground.cpp.rej patching file src/server/game/Battlegrounds/Battleground.h Hunk #1 FAILED at 209 Hunk #2 FAILED at 301 2 out of 2 hunks FAILED -- saving rejects to file src/server/game/Battlegrounds/ Battleground.h.rej patching file src/server/game/Entities/Unit/Unit.cpp Hunk #1 FAILED at 692 Hunk #2 FAILED at 9960 2 out of 2 hunks FAILED -- saving rejects to file src/server/game/Entities/Unit/ Unit.cpp.rej patch failed, unable to continue (try -v) patch failed, rejects left in working dir errors during apply, please fix and refresh wowarmory_arena_chart.patch applying wowarmory_patch.patch patching file src/server/game/Achievements/AchievementMgr.cpp Hunk #1 FAILED at 1906 1 out of 1 hunks FAILED -- saving rejects to file src/server/game/Achievements/A chievementMgr.cpp.rej patching file src/server/game/Entities/Item/Item.cpp Hunk #1 succeeded at 1040 with fuzz 1 (offset 9 lines). patching file src/server/game/Entities/Player/Player.cpp Hunk #1 FAILED at 17615 1 out of 2 hunks FAILED -- saving rejects to file src/server/game/Entities/Playe r/Player.cpp.rej patching file src/server/game/Entities/Player/Player.h Hunk #1 succeeded at 2210 with fuzz 2 (offset -10 lines). patch failed, unable to continue (try -v) patch failed, rejects left in working dir errors during apply, please fix and refresh wowarmory_patch.patch If you want me to include a copy of each of the reject files, just let me know. I can't remember if this happened the first time I tried it with the older revision of TC2, but that may have been my issue all along.

This is what I get

I checked the table that you mentioned and there IS data in that field for the character. Any ideas?

The whole .save thing in game has nothing to do with our issue. We can actually find the character within the armory. The issue that we are having here is when we select the character to view the character sheet, the armory errors out with "file not found".