ucs.exe issues

[galanodel]

Originally Posted by Scorpious2k

At a glance, these all look like database problems. From the top down: account table, mail, and spells. Like I said, just at a glance...

Which DB did you install, what is the date on the source, and which patches have you run?

I pulled the latest revision from git (On August 26th) and the patches I sourced into the database are in Source\utils\sql\git\required , from 2014_07_10_npc_spells.sql forward, as that's what I was reading in the thread I linked before.

When I get home I'll go ahead and backup/drop my database and attempt to build an "older" revision.

Though I do agree that since you guys are using git now, you should have a stable branch and a devel branch. This way you can merge bugfixes into the stable branch from bugfix branches until you're ready to roll development to a new stable version and merge it from there.

I've some experience with git and the branching system. Just have to make sure you upstream your bugfixes to both devel and stable

Edit/Sidenote: I'm not too familiar with windows stack traces or debug output. I'm curious where you gathered the information showing that it was the database tables causing these issues. I'm more than happy to learn and more than willing to help with diagnosing these issues. I have a basic knowedge and grasp of programming and debugging concepts and if I recall correctly, I've read through some of the EQEmu code before (a very, very long time ago) and it didn't seem too overly complicated from other stuff I've seen.

[vsab]

Scan the log for .cpp files belonging to the source. Anything with "MySql" or "Database" in it is the clue.

[08.27. - 12:16:09] c:\eq\source\common\mysql_request_row.cpp (68): MySQLRequestRow::operator[] 
[08.27. - 12:16:09] c:\eq\source\common\database.cpp (166): Database::CheckLogin

[08.27. - 11:23:07] c:\eq\source\common\mysql_request_result.h (43): MySQLRequestResult::ErrorMessage 
[08.27. - 11:23:07] c:\eq\source\ucs\database.cpp (528): Database::ExpireMail 
[08.27. - 11:23:07] c:\eq\source\ucs\ucs.cpp (126): main

[08.27. - 11:22:40] c:\eq\source\common\shareddb.cpp (1760): SharedDatabase::LoadSpells 
[08.27. - 11:22:40] c:\eq\source\shared_memory\spells.cpp (41): LoadSpells 
[08.27. - 11:22:40] c:\eq\source\shared_memory\main.cpp (154): main

PS totally agree regarding branches but I'm a newbie so not gonna rock any boats.

[KLS]

OP we should have these crashes fixed with my last push tonight.

Though do note the crash in shared_memory is because of missing fields in your spell table and has nothing to do with recent db work. I changed it so instead of crashing it will output an error message and just not attempt to load.



Also a note: guys Support threads are for *support* if you don't like how I do releases that's fine but please discuss it in Development not Support.