cant create guilds

[eqemuross]

I am having this same exact issue:

"We are unable to get guilds working properly. When I try to #guildcreate it does not put the character in the guild, but does create it. I have to actually go into the database to put the character into the guild, it does not work via commands.

Also when a person is in the guild, as the leader, when they try to invite someone else it gives them the error that the database may be inconsistent...

Does anyone know how to fix this problem? I have even updated to a newer database and I am still having this issue. We are currently using Rev946."

http://www.projecteq.net/phpBB2/view...431&highlight=

I've had it with 946 and 973. I have all the right tables in my database... the guild gets created in the 'guilds' table but it wont put the members in the guild under 'guild_members'.

Any help would greatly be appreciated!

-ross

[eqemuross]

The other person who has this issue (Grim from the Order of Sin server) also has a PvP server... could this be the problem? My server has PvP enabled as well.

[leslamarch]

This is just a wild guess and I have never played with a PVP server but add these tables to your DB if you dont have them...

DROP TABLE IF EXISTS `guild_alliances`;

CREATE TABLE `guild_alliances` (
  `id` int(11) NOT NULL auto_increment,
  `guildone` int(11) NOT NULL default '0',
  `guildtwo` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


DROP TABLE IF EXISTS `guild_controllers`;

CREATE TABLE `guild_controllers` (
  `id` int(11) NOT NULL auto_increment,
  `npc_id` int(11) NOT NULL default '0',
  `owned_guild_id` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `terrainarea` varchar(64) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `npc_id` (`npc_id`),
  UNIQUE KEY `zoneid` (`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

[trevius]

You can make guilds by doing the following command:

#guild create <leadername> <guildname>

Without the < and > of course and also no quotes needed or anything like that for guildnames.

[jimm0thy]

I get the same errors running a pve server.

[eqemuross]

Originally Posted by trevius

You can make guilds by doing the following command:

#guild create <leadername> <guildname>

Without the < and > of course and also no quotes needed or anything like that for guildnames.

Like I said, I've used all of these commands... the guild gets created in the database, but the leader/members don't get added. If I manually add a guild leader and he tries to invite someone, there is an error as well.

[eqemuross]

Originally Posted by leslamarch

This is just a wild guess and I have never played with a PVP server but add these tables to your DB if you dont have them...

DROP TABLE IF EXISTS `guild_alliances`;

CREATE TABLE `guild_alliances` (
  `id` int(11) NOT NULL auto_increment,
  `guildone` int(11) NOT NULL default '0',
  `guildtwo` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;


DROP TABLE IF EXISTS `guild_controllers`;

CREATE TABLE `guild_controllers` (
  `id` int(11) NOT NULL auto_increment,
  `npc_id` int(11) NOT NULL default '0',
  `owned_guild_id` int(11) NOT NULL default '0',
  `zoneid` int(11) NOT NULL default '0',
  `terrainarea` varchar(64) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `npc_id` (`npc_id`),
  UNIQUE KEY `zoneid` (`zoneid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

added this table.... same errors.

anyone have any ideas? looks like a few of us have these issues.. it's really hurting my server w/ out having guilds implemented :(

[trevius]

Originally Posted by eqemuross

We are unable to get guilds working properly. When I try to #guildcreate it does not put the character in the guild, but does create it.

Technically, you said that you tried using the #guildcreate command, which is not the same as using #guild with the "create" option like I showed above.

[eqemuross]

Originally Posted by trevius

Technically, you said that you tried using the #guildcreate command, which is not the same as using #guild with the "create" option like I showed above.

Unable to set the guild leader's guild in the database. Your going to have to run #guild set.


I run #guild set charname guildid and:

Error putting 'X' into guild 1

[Capheus]

I am running 946 also and having the exact same problems, This is not an operator #guild create error. What worked for me before (535 I think) doesn't work now.

[eqemuross]

Is everyone thats having this issue hosting their server on Windows 64bit? It's the only thing another person and I with this problem have in common.

[eqemuross]

Originally Posted by Capheus

I am running 946 also and having the exact same problems, This is not an operator #guild create error. What worked for me before (535 I think) doesn't work now.

I had the problem with 946 and 973... only two sources/dbs I've touched.

[Tharkun]

i had an issue with this using #guildcreate, i dont know if that command should no longer be used or what... but i ended up deleting that entry and using #guild create <leadername> <guildname>, and everything was fine after that.

[jimm0thy]

Originally Posted by eqemuross

Is everyone thats having this issue hosting their server on Windows 64bit? It's the only thing another person and I with this problem have in common.

I am, Vista 64bit

[eqemuross]

Originally Posted by jimm0thy

I am, Vista 64bit

this has to be the issue.... its the only thing 3 of us have had in common