Single char on account crashes

[GurkhaPanzers]

I am trying to resolve an issue where a character can not log in and I am open to ideas.

I have tried "Go Home feature"
Moving char to another account
Switching client versions
Moving char (in HeidiSQL) to another zone and trying to log in

Issue occurred when char was gating out of an instance.

Any Ideas would be welcomed.

[NatedogEZ]

Maybe you have the broken merc bug? There is a fix somewhere on the forums for that one.

[GurkhaPanzers]

Server doesn't have mercenaries active. Could the bug still be possible?

[Uleat]

There's also a slight chance they may have an unsupported item on them...

Does this server have a custom database?


Try this link too: http://www.eqemulator.org/forums/showthread.php?t=36014&highlight=client+login+item

[GurkhaPanzers]

How would an unsupported item work? The char did just enter new content and loot some new items. It is possible one or more has an issue.

[GurkhaPanzers]

Went into the database, deleted all new items out of his inventory. It didn't work.

[GurkhaPanzers]

In case I forget to mention it, thanks all for the helpful ideas even if they don't work. I appreciate your attempt.

[GurkhaPanzers]

I think it may be the mercenary error. I see this is the log file.

"OP_MERCENARY_TIMER"

[NatedogEZ]

The merc error is "Merc fails to spawn" when someone logged off with a merc and you upgrade to the new source. But you said you don't have them on so that is probably not your issue.

The merc error would crash whatever zone that player tried to log into as well and it would generate a crash log.

So guessing its something else :\

[GurkhaPanzers]

How does one restore a character from the nightly backups.

[Kingly_Krab]

If you have nightly backups you have their character information, their buffs, inventory, and bank information. So you could wipe their slate clean and pull in a back up, only for them, you'd have to pick their information out of the query you have though.

[GurkhaPanzers]

Found problem. Char had guildremoved himself and joined new guild. Issue was database dropped him from current guild so he could add new guild but didn't delete the old guild line in database so he was in 2 guilds hence crash

[Kingly_Krab]

That seems like a horrible way to cause yourself to crash.

[GurkhaPanzers]

Does anyone know of a quest command to drop a char from a guild. Seems like being able to add without force removing is a very bad idea.

[Kingly_Krab]

You can do this, tested and made sure it worked before posting.:
quest::setguild(0, 0);
Information on quest::setguild.
quest::setguild(guild_id, rank) - Add player to "guild_id" with a "rank".
How I removed the guild.
if($text=~/Leave Guild/i)
{
quest::setguild(0, 0);
}

[GurkhaPanzers]

Thanks. I didn't realize setting guild to 0 would delete the line thanks.

[Kingly_Krab]

Yeah, Guild ID 0 is guild-less.