Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2015, 12:03 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default 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.
Reply With Quote
  #2  
Old 01-31-2015, 12:34 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

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
Reply With Quote
  #3  
Old 01-31-2015, 01:28 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Revert for now. PM me your corpse table (blob) and I'll let you know when it's safe to try again.
Reply With Quote
  #4  
Old 01-31-2015, 01:29 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

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.
Reply With Quote
  #5  
Old 01-31-2015, 01:45 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Quote:
Originally Posted by Akkadius View Post
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.
Reply With Quote
  #6  
Old 01-31-2015, 01:48 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

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.
Reply With Quote
  #7  
Old 01-31-2015, 02:18 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Sent you a pm.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:39 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3