GroupID error and client crashing while zoning

[mollymillions]

Some issues with the latest source from CVS (0.5.3-DR2):

I was getting a lot of client crashes/hanging while zoning and could not use the #zone command without crashing/hanging the client. Zone.exe gives the following error:

[Error] Zone not found in database zone_id=0, moveing char to arena character:Mage

**edit** This is not a bug but was a configuration issue.


This isnt related to the other issue but GetGroupID and SetGroupID are referencing a groupid filed in the character_ table that does not exists in the release db schema. Zone.exe gives:

Unable to get group id: #1054: Unknown column 'groupid' in 'field list'

[Valdain]

As far as the first error, I haven't had it yet.

For the second error, it is telling you that your database is missing a column in the character_ table. The groupid column is for allowing the player to be in a group. The database schema that comes with DR2 is missing that field. You just need to 'ALTER' the table to add it as an 'int'. If you don't know how to alter a table, go to www.mysql.com and search their documentation for the ALTER TABLE command.

Hope that helps,
-Valdain

[_OZZY_]

mollymillions,

Have you been able to fix the zone_id=0 issue yet? I am having exactly the same problem.

[Shawn319]

ALTER TABLE `character_` ADD `groupid` INT(10) UNSIGNED DEFAULT "0" NOT NULL;

[_OZZY_]

Thanks Shawn319. Will this fix the zone_id=0 crash, too? That's the issue I'm having the most problems with.

[mollymillions]

It was an issue with zone connections. I reset all the IP's in bootfivezones.bat back to 127.0.0.1. I am using minilogin.

[_OZZY_]

I'm using MiniLogin also. I'll certainly try changing it back to 127. I'm using 192's. Thanks for the reply :D