EQEmulator Forums - Character Corpses - No items after upgrade

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Character Corpses - No items after upgrade (https://www.eqemulator.org/forums/showthread.php?t=39292)

Character Corpses - No items after upgrade

I just did my update today, I noticed world flashes "converting characters corpses". When my first player summoned his corpse he said it appeared as a human model with no items. I checked the player corpse item table, where the conversion should be dumping data and that table is empty. I have a backup of the database from right before the upgrade. Is there a manual way I can retrieve all this data?

My binaries were from around October and my current binaries are from source around a week ago when we started testing.

This is basically what happens....truncated to make it readable.

Code:

[33m[World Server] Starting HTTP world service...[0m

[33m[World Server] Checking Database Conversions..[0m

Converting Corpse: [OK] [SOF]: ID: 6

Converting Corpse: [OK] [SOF]: ID: 7

Converting Corpse: [OK] [SOF]: ID: 8

Converting Corpse: [OK] [SOF]: ID: 90

Converting Corpse: [OK] [SOF]: ID: 99

Converting Corpse: [OK] [SOF]: ID: 100

Converting Corpse: [OK] [SOF]: ID: 116

Converting Corpse: [OK] [SOF]: ID: 122

Converting Corpse: [OK] [SOF]: ID: 123

Converting Corpse: [OK] [SOF]: ID: 124

Converting Corpse: [OK] [SOF]: ID: 129

Converting Corpse: [OK] [SOF]: ID: 130

Converting Corpse: [OK] [SOF]: ID: 167

Converting Corpse: [OK] [SOF]: ID: 142

Converting Corpse: [OK] [SOF]: ID: 143

Converting Corpse: [OK] [SOF]: ID: 148

Converting Corpse: [OK] [SOF]: ID: 153

Converting Corpse: [OK] [SOF]: ID: 149



Bunch more in here....



Converting Corpse: [OK] [SOF]: ID: 3554

Converting Corpse: [OK] [SOF]: ID: 3558

Converting Corpse: [OK] [SOF]: ID: 3560

Converting Corpse: [OK] [SOF]: ID: 3561

[Upgrade Script] No script update necessary 

Perl Version is 5.14.2

Table 'db_version' does not exists.... Creating...



============================================================

           EQEmu: Automatic Upgrade Check         

============================================================

        (Linux) MySQL is in system path 

        Path = /usr/bin/mysql

============================================================

        Binary Database Version: (9069)

        Local Database Version: (1000)

Code:

SELECT * FROM character_corpse_items;

rows returned 0

Revert for now. PM me your corpse table (blob) and I'll let you know when it's safe to try again.

Still looking into it, but from what I am seeing dbpc->itemcount is returning zero items, so that part is never running in the loop.

Quote:

Originally Posted by Akkadius (Post 237320)

Revert for now. PM me your corpse table (blob) and I'll let you know when it's safe to try again.

I sent you a PM, or I think it said visitor message.

On a side note, I think it will only be a few people. I could use my old binaries and old source to rez those people and copy their player data over...I think.

Yeah, not quite a PM. Send me a dump of your corpse table before conversion. I'll take a look at it when I have time.