cant create guilds

**trevius** · #1 09-16-2009, 02:45 AM

Probably the combination of you using "#guildcreate" instead of "#guild create" along with you manually changing stuff in your tables is what is causing your problems. You should try changing it back and removing all guilds in the table and then do "#guild create yourname Test" and see what happens.

eqemuross · #2 09-16-2009, 03:11 AM

Quote:

Originally Posted by trevius

Probably the combination of you using "#guildcreate" instead of "#guild create" along with you manually changing stuff in your tables is what is causing your problems. You should try changing it back and removing all guilds in the table and then do "#guild create yourname Test" and see what happens.

Erased all data in guild tables...

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

I run #guild set...

Error putting 'charactername' into guild 1

Capheus · #3 09-16-2009, 05:11 PM

Ya thats the same thing I am getting here too.

eqemuross · #4 09-16-2009, 07:24 PM

Quote:

Originally Posted by Capheus

Ya thats the same thing I am getting here too.

this is frustrating

Wesell · #5 09-16-2009, 10:21 PM

Could one of you post the log entries that are generated when you try to set a character's guild?

nightsta69 · #6 09-17-2009, 01:47 PM

Code:

[09.17. - 12:39:18] [GUILDS__ERROR] Error Changing char 1 to guild 1 'REPLACE INTO guild_members (char_id,guild_id,rank) VALUES(1,1,0)': #1364: Field 'public_note' doesn't have a default value

I believe this is the problem. manually setting a character into the guild, with a value in public_note sets that character into the guild.

nightsta69 · #7 09-17-2009, 02:14 PM

Code:

DROP TABLE IF EXISTS `guild_members`;
CREATE TABLE `guild_members` (
  `char_id` int(11) NOT NULL default '0',
  `guild_id` mediumint(8) unsigned NOT NULL default '0',
  `rank` tinyint(3) unsigned NOT NULL default '0',
  `tribute_enable` tinyint(3) unsigned NOT NULL default '0',
  `total_tribute` int(10) unsigned NOT NULL default '0',
  `last_tribute` int(10) unsigned NOT NULL default '0',
  `banker` tinyint(3) unsigned NOT NULL default '0',
  `public_note` text NOT NULL default '',
  PRIMARY KEY  (`char_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

that fixes the guild creation problem. I just did it this way, cause my mysql isn't the best. i'm sure one of the other folks will just show you how to update the table that is currently there. hope that helps.