SOF bug

[trevius]

I am not sure why it works for Titanium and not other clients, but my best guess is that you still have some table issues. There are a lot of required SQL updates needed from the older revision you were probably running. You may have 1 or more fields set to incompatible default values that cause them to fail when loading or something like that. You might also need to make sure that when you compile, you are compiling all of the most recent files in the common/patches/ folder. If you are compiling older version of the patch files, who know what odd issues it would cause.

Since there are other crash issues related to the SoD client (and probably other new clients), I would think your problem is with the patch files you are compiling. It could probably also be an issue with your shared mem file compile, but I really have no clue how you have stuff setup.

There is also a chance you could be running into some 64bit issue, cause I don't know much about what to expect crash-wise from that. As far as I know, the source should work with 64 bit, but I haven't tested it myself to confirm.

And yeah, both of those crashes were me. One was when I first created the char using SoD and the other is when I died on the char after I deleted all items on him.

[KingMort]

Still have no clue what is causing this.. What more info do people need in order to fix this issue ?? More Core Drops ?? I can put the schema of my tables in here, though i have double checked they are the same as PEQ's rev 1752 exactly...

I need to get this fixed !

[KingMort]

After looking through all the SQL updates after trev said that might be whatsup I ran into some that were updating this table : "tblWorldServerRegistration"

Well, I don't have that table what is it.. Is it important , would it be causing this? (maybe not)

I couldn't find any of the updates really pertaining to the items or inventory table other than 1542_items_table_cleanup


Here is my Schema for Items and Inventory , maybe some one can see something I am not.

-=ITEMS=-

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL default '0',
  `minstatus` smallint(5) NOT NULL default '0',
  `Name` varchar(64) NOT NULL default '',
  `aagi` int(11) NOT NULL default '0',
  `ac` int(11) NOT NULL default '0',
  `accuracy` int(11) NOT NULL default '0',
  `acha` int(11) NOT NULL default '0',
  `adex` int(11) NOT NULL default '0',
  `aint` int(11) NOT NULL default '0',
  `artifactflag` tinyint(3) unsigned NOT NULL default '0',
  `asta` int(11) NOT NULL default '0',
  `astr` int(11) NOT NULL default '0',
  `attack` int(11) NOT NULL default '0',
  `augrestrict` int(11) NOT NULL default '0',
  `augslot1type` tinyint(3) NOT NULL default '0',
  `augslot1visible` tinyint(3) default NULL,
  `augslot2type` tinyint(3) NOT NULL default '0',
  `augslot2visible` tinyint(3) default NULL,
  `augslot3type` tinyint(3) NOT NULL default '0',
  `augslot3visible` tinyint(3) default NULL,
  `augslot4type` tinyint(3) NOT NULL default '0',
  `augslot4visible` tinyint(3) default NULL,
  `augslot5type` tinyint(3) NOT NULL default '0',
  `augslot5visible` tinyint(3) default NULL,
  `augtype` int(11) NOT NULL default '0',
  `avoidance` int(11) NOT NULL default '0',
  `awis` int(11) NOT NULL default '0',
  `bagsize` int(11) NOT NULL default '0',
  `bagslots` int(11) NOT NULL default '0',
  `bagtype` int(11) NOT NULL default '0',
  `bagwr` int(11) NOT NULL default '0',
  `banedmgamt` int(11) NOT NULL default '0',
  `banedmgraceamt` int(11) NOT NULL default '0',
  `banedmgbody` int(11) NOT NULL default '0',
  `banedmgrace` int(11) NOT NULL default '0',
  `bardtype` int(11) NOT NULL default '0',
  `bardvalue` int(11) NOT NULL default '0',
  `book` int(11) NOT NULL default '0',
  `casttime` int(11) NOT NULL default '0',
  `casttime_` int(11) NOT NULL default '0',
  `charmfile` varchar(32) NOT NULL default '',
  `charmfileid` varchar(32) NOT NULL default '',
  `classes` int(11) NOT NULL default '0',
  `color` int(10) unsigned NOT NULL default '0',
  `combateffects` varchar(10) NOT NULL default '',
  `extradmgskill` int(11) NOT NULL default '0',
  `extradmgamt` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `cr` int(11) NOT NULL default '0',
  `damage` int(11) NOT NULL default '0',
  `damageshield` int(11) NOT NULL default '0',
  `deity` int(11) NOT NULL default '0',
  `delay` int(11) NOT NULL default '0',
  `augdistiller` int(11) NOT NULL default '0',
  `dotshielding` int(11) NOT NULL default '0',
  `dr` int(11) NOT NULL default '0',
  `clicktype` int(11) NOT NULL default '0',
  `clicklevel2` int(11) NOT NULL default '0',
  `elemdmgtype` int(11) NOT NULL default '0',
  `elemdmgamt` int(11) NOT NULL default '0',
  `endur` int(11) NOT NULL default '0',
  `factionamt1` int(11) NOT NULL default '0',
  `factionamt2` int(11) NOT NULL default '0',
  `factionamt3` int(11) NOT NULL default '0',
  `factionamt4` int(11) NOT NULL default '0',
  `factionmod1` int(11) NOT NULL default '0',
  `factionmod2` int(11) NOT NULL default '0',
  `factionmod3` int(11) NOT NULL default '0',
  `factionmod4` int(11) NOT NULL default '0',
  `filename` varchar(32) NOT NULL default '',
  `focuseffect` int(11) NOT NULL default '0',
  `fr` int(11) NOT NULL default '0',
  `fvnodrop` int(11) NOT NULL default '0',
  `haste` int(11) NOT NULL default '0',
  `clicklevel` int(11) NOT NULL default '0',
  `hp` int(11) NOT NULL default '0',
  `regen` int(11) NOT NULL default '0',
  `icon` int(11) NOT NULL default '0',
  `idfile` varchar(30) NOT NULL default '',
  `itemclass` int(11) NOT NULL default '0',
  `itemtype` int(11) NOT NULL default '0',
  `ldonprice` int(11) NOT NULL default '0',
  `ldontheme` int(11) NOT NULL default '0',
  `ldonsold` int(11) NOT NULL default '0',
  `light` int(11) NOT NULL default '0',
  `lore` varchar(80) NOT NULL default '',
  `loregroup` int(11) NOT NULL default '0',
  `magic` int(11) NOT NULL default '0',
  `mana` int(11) NOT NULL default '0',
  `manaregen` int(11) NOT NULL default '0',
  `enduranceregen` int(11) NOT NULL default '0',
  `material` int(11) NOT NULL default '0',
  `maxcharges` int(11) NOT NULL default '0',
  `mr` int(11) NOT NULL default '0',
  `nodrop` int(11) NOT NULL default '0',
  `norent` int(11) NOT NULL default '0',
  `pendingloreflag` tinyint(3) unsigned NOT NULL default '0',
  `pr` int(11) NOT NULL default '0',
  `procrate` int(11) NOT NULL default '0',
  `races` int(11) NOT NULL default '0',
  `range` int(11) NOT NULL default '0',
  `reclevel` int(11) NOT NULL default '0',
  `recskill` int(11) NOT NULL default '0',
  `reqlevel` int(11) NOT NULL default '0',
  `sellrate` float NOT NULL default '0',
  `shielding` int(11) NOT NULL default '0',
  `size` int(11) NOT NULL default '0',
  `skillmodtype` int(11) NOT NULL default '0',
  `skillmodvalue` int(11) NOT NULL default '0',
  `slots` int(11) NOT NULL default '0',
  `clickeffect` int(11) NOT NULL default '0',
  `spellshield` int(11) NOT NULL default '0',
  `strikethrough` int(11) NOT NULL default '0',
  `stunresist` int(11) NOT NULL default '0',
  `summonedflag` tinyint(3) unsigned NOT NULL default '0',
  `tradeskills` int(11) NOT NULL default '0',
  `favor` int(11) NOT NULL default '0',
  `weight` int(11) NOT NULL default '0',
  `UNK012` int(11) NOT NULL default '0',
  `UNK013` int(11) NOT NULL default '0',
  `benefitflag` int(11) NOT NULL default '0',
  `UNK054` int(11) NOT NULL default '0',
  `UNK059` int(11) NOT NULL default '0',
  `booktype` int(11) NOT NULL default '0',
  `recastdelay` int(11) NOT NULL default '0',
  `recasttype` int(11) NOT NULL default '0',
  `guildfavor` int(11) NOT NULL default '0',
  `UNK123` int(11) NOT NULL default '0',
  `UNK124` int(11) NOT NULL default '0',
  `attuneable` int(11) NOT NULL default '0',
  `nopet` int(11) NOT NULL default '0',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `comment` varchar(255) NOT NULL default '',
  `UNK127` int(11) NOT NULL default '0',
  `pointtype` int(11) NOT NULL default '0',
  `potionbelt` int(11) NOT NULL default '0',
  `potionbeltslots` int(11) NOT NULL default '0',
  `stacksize` int(11) NOT NULL default '0',
  `notransfer` int(11) NOT NULL default '0',
  `stackable` int(11) NOT NULL default '0',
  `UNK134` varchar(255) NOT NULL default '',
  `UNK137` int(11) NOT NULL default '0',
  `proceffect` int(11) NOT NULL default '0',
  `proctype` int(11) NOT NULL default '0',
  `proclevel2` int(11) NOT NULL default '0',
  `proclevel` int(11) NOT NULL default '0',
  `UNK142` int(11) NOT NULL default '0',
  `worneffect` int(11) NOT NULL default '0',
  `worntype` int(11) NOT NULL default '0',
  `wornlevel2` int(11) NOT NULL default '0',
  `wornlevel` int(11) NOT NULL default '0',
  `UNK147` int(11) NOT NULL default '0',
  `focustype` int(11) NOT NULL default '0',
  `focuslevel2` int(11) NOT NULL default '0',
  `focuslevel` int(11) NOT NULL default '0',
  `UNK152` int(11) NOT NULL default '0',
  `scrolleffect` int(11) NOT NULL default '0',
  `scrolltype` int(11) NOT NULL default '0',
  `scrolllevel2` int(11) NOT NULL default '0',
  `scrolllevel` int(11) NOT NULL default '0',
  `UNK157` int(11) NOT NULL default '0',
  `serialized` datetime default NULL,
  `verified` datetime default NULL,
  `serialization` text,
  `source` varchar(20) NOT NULL default '',
  `UNK033` int(11) NOT NULL default '0',
  `lorefile` varchar(32) NOT NULL default '',
  `UNK014` int(11) NOT NULL default '0',
  `svcorruption` int(11) NOT NULL default '0',
  `UNK038` int(11) NOT NULL default '0',
  `UNK060` int(11) NOT NULL default '0',
  `augslot1unk2` int(11) NOT NULL default '0',
  `augslot2unk2` int(11) NOT NULL default '0',
  `augslot3unk2` int(11) NOT NULL default '0',
  `augslot4unk2` int(11) NOT NULL default '0',
  `augslot5unk2` int(11) NOT NULL default '0',
  `UNK120` int(11) NOT NULL default '0',
  `UNK121` int(11) NOT NULL default '0',
  `questitemflag` int(11) NOT NULL default '0',
  `UNK132` text NOT NULL,
  `clickunk5` int(11) NOT NULL default '0',
  `clickunk6` varchar(32) NOT NULL default '',
  `clickunk7` int(11) NOT NULL default '0',
  `procunk1` int(11) NOT NULL default '0',
  `procunk2` int(11) NOT NULL default '0',
  `procunk3` int(11) NOT NULL default '0',
  `procunk4` int(11) NOT NULL default '0',
  `procunk6` varchar(32) NOT NULL default '',
  `procunk7` int(11) NOT NULL default '0',
  `wornunk1` int(11) NOT NULL default '0',
  `wornunk2` int(11) NOT NULL default '0',
  `wornunk3` int(11) NOT NULL default '0',
  `wornunk4` int(11) NOT NULL default '0',
  `wornunk5` int(11) NOT NULL default '0',
  `wornunk6` varchar(32) NOT NULL default '',
  `wornunk7` int(11) NOT NULL default '0',
  `focusunk1` int(11) NOT NULL default '0',
  `focusunk2` int(11) NOT NULL default '0',
  `focusunk3` int(11) NOT NULL default '0',
  `focusunk4` int(11) NOT NULL default '0',
  `focusunk5` int(11) NOT NULL default '0',
  `focusunk6` varchar(32) NOT NULL default '',
  `focusunk7` int(11) NOT NULL default '0',
  `scrollunk1` int(11) NOT NULL default '0',
  `scrollunk2` int(11) NOT NULL default '0',
  `scrollunk3` int(11) NOT NULL default '0',
  `scrollunk4` int(11) NOT NULL default '0',
  `scrollunk5` int(11) NOT NULL default '0',
  `scrollunk6` varchar(32) NOT NULL default '',
  `scrollunk7` int(11) NOT NULL default '0',
  `UNK193` int(11) NOT NULL default '0',
  `purity` int(11) NOT NULL default '0',
  `evolvinglevel` int(11) NOT NULL default '0',
  `clickname` varchar(64) NOT NULL default '',
  `procname` varchar(64) NOT NULL default '',
  `wornname` varchar(64) NOT NULL default '',
  `focusname` varchar(64) NOT NULL default '',
  `scrollname` varchar(64) NOT NULL default '',
  `dsmitigation` smallint(6) NOT NULL default '0',
  `heroic_str` smallint(6) NOT NULL default '0',
  `heroic_int` smallint(6) NOT NULL default '0',
  `heroic_wis` smallint(6) NOT NULL default '0',
  `heroic_agi` smallint(6) NOT NULL default '0',
  `heroic_dex` smallint(6) NOT NULL default '0',
  `heroic_sta` smallint(6) NOT NULL default '0',
  `heroic_cha` smallint(6) NOT NULL default '0',
  `heroic_pr` smallint(6) NOT NULL default '0',
  `heroic_dr` smallint(6) NOT NULL default '0',
  `heroic_fr` smallint(6) NOT NULL default '0',
  `heroic_cr` smallint(6) NOT NULL default '0',
  `heroic_mr` smallint(6) NOT NULL default '0',
  `heroic_svcorrup` smallint(6) NOT NULL default '0',
  `healamt` smallint(6) NOT NULL default '0',
  `spelldmg` smallint(6) NOT NULL default '0',
  `clairvoyance` smallint(6) NOT NULL default '0',
  `backstabdmg` smallint(6) NOT NULL default '0',
  `created` varchar(64) NOT NULL default '',
  `elitematerial` smallint(6) NOT NULL default '0',
  `ldonsellbackrate` smallint(6) NOT NULL default '0',
  `scriptfileid` smallint(6) NOT NULL default '0',
  `expendablearrow` smallint(6) NOT NULL default '0',
  `powersourcecapacity` smallint(6) NOT NULL default '0',
  `bardeffect` smallint(6) NOT NULL default '0',
  `bardeffecttype` smallint(6) NOT NULL default '0',
  `bardlevel2` smallint(6) NOT NULL default '0',
  `bardlevel` smallint(6) NOT NULL default '0',
  `bardunk1` smallint(6) NOT NULL default '0',
  `bardunk2` smallint(6) NOT NULL default '0',
  `bardunk3` smallint(6) NOT NULL default '0',
  `bardunk4` smallint(6) NOT NULL default '0',
  `bardunk5` smallint(6) NOT NULL default '0',
  `bardname` varchar(64) NOT NULL default '',
  `bardunk7` smallint(6) NOT NULL default '0',
  `UNK214` smallint(6) NOT NULL default '0',
  UNIQUE KEY `ID` (`id`),
  KEY `name_idx` (`Name`),
  KEY `lore_idx` (`lore`),
  KEY `minstatus` (`minstatus`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-=INVENTORY=-

CREATE TABLE IF NOT EXISTS `inventory` (
  `charid` int(11) unsigned NOT NULL default '0',
  `slotid` mediumint(7) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned default '0',
  `charges` tinyint(3) unsigned default '0',
  `color` int(11) unsigned NOT NULL default '0',
  `augslot1` mediumint(7) unsigned NOT NULL default '0',
  `augslot2` mediumint(7) unsigned NOT NULL default '0',
  `augslot3` mediumint(7) unsigned NOT NULL default '0',
  `augslot4` mediumint(7) unsigned NOT NULL default '0',
  `augslot5` mediumint(7) unsigned default '0',
  `instnodrop` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`charid`,`slotid`),
  KEY `ix_inventory_itemid` (`itemid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Any help would be greatly appreciated

[KingMort]

Oh also :

5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch 6.2
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch Titanium
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch SoF
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch SoD
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch Underfoot
5697 [05.07. - 10:52:00] [NET__IDENTIFY] Registered patch HoT

So the patch files are loading for sure.. I just have to figure out the exact cause of whats doing this in order to fix it.

The one thing I do see from most of these depending on what client they use of course is lines similar to this listed under frames 3 and 4..

#3  0x0000000000743047 in Underfoot::SerializeItem (inst=0x7f9474171b90,
    slot_id_in=22, length=0x7fffffffa984, depth=0 '\0')
    at /usr/include/c++/4.3/istream:587
587           { this->init(0); }


(gdb) frame 4
#4  0x0000000000744b21 in Underfoot::Strategy::Encode_OP_CharInventory (
    p=<value optimized out>, dest=0x17b2480, ack_req=true)
    at ../common/patches/Underfoot.cpp:1278
1278                    char* Serialized = SerializeItem((const ItemInst*)eq->inst, eq->slot_id, &Length, 0);
(gdb) list
1273
1274            for(int r = 0; r < ItemCount; r++, eq++) {
1275
1276                    uint32 Length = 0;
1277
1278                    char* Serialized = SerializeItem((const ItemInst*)eq->inst, eq->slot_id, &Length, 0);
1279
1280                    if(Serialized) {
1281
1282                            uchar *OldBuffer = in->pBuffer;
(gdb)

I see no sign of SerializedItem anywhere in Inventory or Items, i do find a "serialized" in items but those are all set to either NULL or "0000-00-00 00:00:00" also i see "serialization" but those are all set to NULL as they should be.

Mort

[trevius]

Looks like your crashing issue is due to you running 64bit and also the combination of libs you are running. You had this exact same issue in 2009:

http://www.eqemulator.net/forums/arc...p/t-28455.html

[KingMort]

Nice.. I do remember that, yes ok so should I be removing the -O on all the makefiles or just World.. Or should I just use the makefiles Gaeorn had put in there in it's entirety .. They don't exactly look the same.. Guess I can try just taking off the -O for now and see how it goes.

[KingMort]

Well, I started this thread, and Now , I hereby CLOSE this thread.

Thank you Trevius , i don't know how you managed to remember that and everything.. (Gaeorn actually told me this like a dozen times, sorry Gaeorn)

It did work , I took the -O , off world and zone makefiles, and now SOD / SOF people can connect like they did normally before...

My Question to the community I guess at this time is why would that one little -O make that much difference?? It's true my Linux build is 64 bit but still makes me wonder why that little letter would cause all that trouble.. What is Optimization and what does it do for the binary's , will I be missing out on any performance from this or ?

Morty