EQEmulator Forums - cant create guilds

Page 2 of 3

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - cant create guilds (https://www.eqemulator.org/forums/showthread.php?t=29535)

Capheus

09-15-2009 07:59 PM

I am using Vista 32bit with EMU946 and PEQ946

eqemuross

09-15-2009 08:31 PM

Quote:

Originally Posted by Capheus (Post 178589)

I am using Vista 32bit with EMU946 and PEQ946

weird... i wonder what is causing this :(

trevius

09-15-2009 09:43 PM

Quote:

Originally Posted by Tharkun (Post 178538)

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.

Did any of you guys try this?

eqemuross

09-15-2009 10:13 PM

Quote:

Originally Posted by trevius (Post 178596)

Did any of you guys try this?

yeah.. here is what happens though:

it creates the guild, but does not put the leader in the guild. i had to manually put the char in the guild through the database and then i couldn't invite anyone new.

trevius

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

09-16-2009 03:11 AM

Quote:

Originally Posted by trevius (Post 178604)

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

09-16-2009 05:11 PM

Ya thats the same thing I am getting here too.

eqemuross

09-16-2009 07:24 PM

Quote:

Originally Posted by Capheus (Post 178640)

Ya thats the same thing I am getting here too.

this is frustrating

Wesell

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

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

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.

eqemuross

09-17-2009 03:44 PM

1101 BLOB/TEXT column 'public_note' can't have a default value is what I get when I run that query

nightsta69

09-17-2009 04:06 PM

hmm, thats weird. again my mysql isn't all that great. here is my guild_members.sql that i used to make it work. maybe there is somethin extra in it that made it work.

guild_members.rar

eqemuross

09-17-2009 04:15 PM

thank you.

i imported it... going to test it out

eqemuross

09-17-2009 04:17 PM

same error. where can i find the log?

All times are GMT -4. The time now is 09:38 AM.

Page 2 of 3

Show 40 post(s) from this thread on one page