Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #16  
Old 09-15-2009, 07:59 PM
Capheus
Hill Giant
 
Join Date: Apr 2008
Location: Milwaukee
Posts: 141
Default

I am using Vista 32bit with EMU946 and PEQ946
Reply With Quote
  #17  
Old 09-15-2009, 08:31 PM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

Quote:
Originally Posted by Capheus View Post
I am using Vista 32bit with EMU946 and PEQ946
weird... i wonder what is causing this :(
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
  #18  
Old 09-15-2009, 09:43 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Quote:
Originally Posted by Tharkun View Post
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?
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #19  
Old 09-15-2009, 10:13 PM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

Quote:
Originally Posted by trevius View Post
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.
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
  #20  
Old 09-16-2009, 02:45 AM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote
  #21  
Old 09-16-2009, 03:11 AM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

Quote:
Originally Posted by trevius View Post
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
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
  #22  
Old 09-16-2009, 05:11 PM
Capheus
Hill Giant
 
Join Date: Apr 2008
Location: Milwaukee
Posts: 141
Default

Ya thats the same thing I am getting here too.
Reply With Quote
  #23  
Old 09-16-2009, 07:24 PM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

Quote:
Originally Posted by Capheus View Post
Ya thats the same thing I am getting here too.
this is frustrating
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
  #24  
Old 09-16-2009, 10:21 PM
Wesell
Sarnak
 
Join Date: Mar 2009
Location: none
Posts: 30
Default

Could one of you post the log entries that are generated when you try to set a character's guild?
Reply With Quote
  #25  
Old 09-17-2009, 01:47 PM
nightsta69
Hill Giant
 
Join Date: May 2005
Posts: 134
Default

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.
Reply With Quote
  #26  
Old 09-17-2009, 02:14 PM
nightsta69
Hill Giant
 
Join Date: May 2005
Posts: 134
Default

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.
Reply With Quote
  #27  
Old 09-17-2009, 03:44 PM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

1101 BLOB/TEXT column 'public_note' can't have a default value is what I get when I run that query
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
  #28  
Old 09-17-2009, 04:06 PM
nightsta69
Hill Giant
 
Join Date: May 2005
Posts: 134
Default

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
Reply With Quote
  #29  
Old 09-17-2009, 04:15 PM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

thank you.

i imported it... going to test it out
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
  #30  
Old 09-17-2009, 04:17 PM
eqemuross
Hill Giant
 
Join Date: Sep 2008
Location: South Florida
Posts: 100
Default

same error. where can i find the log?
__________________
Qeynos vs. Freeport PvP
Developer/GM
vilesyntax.com
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 08:54 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3