View Full Version : Character Corpses - No items after upgrade
provocating
01-31-2015, 12:03 PM
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.
provocating
01-31-2015, 12:34 PM
This is basically what happens....truncated to make it readable.
[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)
SELECT * FROM character_corpse_items;
rows returned 0
Akkadius
01-31-2015, 01:28 PM
Revert for now. PM me your corpse table (blob) and I'll let you know when it's safe to try again.
provocating
01-31-2015, 01:29 PM
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.
provocating
01-31-2015, 01:45 PM
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.
Akkadius
01-31-2015, 01:48 PM
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.
provocating
01-31-2015, 02:18 PM
Sent you a pm.
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.