Zone.exe crashing when I enter the world

**GeorgeS** · #1 05-31-2009, 01:37 PM

Fix your table with
*edit* I chaged the sql a bit from before

Code:

UPDATE loottable SET  maxcash=mincash+1  WHERE  mincash>maxcash ;

GeorgeS

Shendare · #2 05-31-2009, 01:43 PM

Quote:

Originally Posted by GeorgeS

Fix your table with

Code:

UPDATE loottable SET  mincash=maxcash+1  WHERE  mincash>maxcash ;

GeorgeS

Unfortunately, this will not fix the problem, since mincash will still be greater than maxcash.

It would have to be more along the lines of:

Code:

UPDATE loottable SET  maxcash=mincash  WHERE  mincash>maxcash

- Shendare

**GeorgeS** · #3 05-31-2009, 01:49 PM

Thanks - I just updated the sql, but abit differently

GeorgeS

steve · #4 05-31-2009, 05:16 PM

Thanks. I haven't had a chance to try it yet. This was from using the PEQ installer and the update packs with no mods.

Code:

mysql> UPDATE loottable SET  maxcash=mincash+1  WHERE  mincash>maxcash ;
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2  Changed: 2  Warnings: 0

Will post back if it fixed it or not sometime today.

steve · #5 05-31-2009, 05:41 PM

Still crashing...

Could this possibly be it?

Code:

Unable to get group id, char not found!
Unable to get raid id, char not found!

covou · #6 06-01-2009, 08:07 AM

I had a similar issue to this, and it was due to items being removed from the items table, that still existed in places like the starting items, lootdrops and tributes.

steve · #7 06-01-2009, 03:09 PM

How did you correct it?