[Ascent] Guild Problems

[janvitos]

Hi.

I'm not sure if this is a comon bug or not but it's strange.
People create guilds, but as soon as they modify the rank of a player, server crashes.
If someone leaves the guild, server crashes too.
Also, guilds don't get saved in database so every time server crashes, guild disappears.

I don't think this happened before.
Anybody know what could be wrong ?

I'm using Ascent 2527 with NCDB 691.

This is the error i recieve in Ascent when someone tries to create a guild :

Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO guilds VALUES(1, "Horde Elites", 345, 0, 0, 0, 0, 0, '', '', 0)]
Sql query failed due to [Column count doesn't match value count at row 1], Query
: [INSERT INTO guild_data VALUES(1, 345, 0, '', '')]

Thanks.

[MentaL]

[blizzhackerd]

Your guilds table structure isn't complete. You need to make sure you have executed all of the SQL files included with your revision.

[janvitos]

I have but the guild system seems bugged.
I've done all SQL Updates.
I had to manually change the column name "leaderGuid" to "guildMaster".

But the guild system doesn't work properly at all.

I guess this is normal is newer Ascent revisions ?

[janvitos]

I also noticed that if the Guild is created with gm command .guild create, it buggs the guild.
The GM's character id will be listed as Guild Master but no record is added for him under guild_data
This causes server to crash if GM tries to leave the guild.

The server also crashes if someone is kicked from the guild.

I have updated Ascent to 2552 and NCDB to 698.

[shamus252]

need to modify your compile till a fix comes out and disable guild logging
Guild::Guild()
{
m_commandLogging=true;

change to
m_commandLogging=false;

also this

// re-enable command logging
m_commandLogging = true;
change to
m_commandLogging = false;

[janvitos]

need to modify your compile till a fix comes out and disable guild logging
Guild::Guild()
{
m_commandLogging=true;

change to
m_commandLogging=false;

also this

// re-enable command logging
m_commandLogging = true;
change to
m_commandLogging = false;

So this is a comon Ascent bug ?
Is there any Ascent rev. that doesn't have this bug ?


I checked my crashdumps folder, and my server has been crashing at least 8-10 times a day because of this.

[beileroord]

I had same error and after some searching i found some updates :

I made a quick dump of my Guild Table so u can compare, and try to find the updates i used in the mess here on my Hd i used

/*
MySQL Data Transfer
Source Host: localhost
Source Database: character
Target Host: localhost
Target Database: character
Date: 18-12-2007 14:10:33
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for guilds
-- ----------------------------
CREATE TABLE `guilds` (
  `guildId` int(10) unsigned NOT NULL auto_increment,
  `guildName` varchar(32) collate utf8_unicode_ci NOT NULL,
  `leaderGuid` int(10) unsigned NOT NULL default '0',
  `emblemStyle` int(10) unsigned NOT NULL default '0',
  `emblemColor` int(10) unsigned NOT NULL default '0',
  `borderStyle` int(10) unsigned NOT NULL default '0',
  `borderColor` int(10) unsigned NOT NULL default '0',
  `backgroundColor` int(10) unsigned NOT NULL default '0',
  `guildInfo` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `motd` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `createdate` int(30) NOT NULL default '0',
  `bankTabCount` int(30) NOT NULL default '0',
  `bankBalance` int(30) NOT NULL default '0',
  PRIMARY KEY  (`guildId`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Guilds';

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `guilds` VALUES ('1', 'GM Crew', '16', '0', '0', '0', '0', '0', 'Gm team\n\nNo disrepect u will get banned!', '', '0', '6', '705032704');

Guess u dont need the records to be inserted.

Hope It helps u out a bit....

Edit :

Maybe It helps U too when u do the 2533_guilds.sql, 2534_guilds.sql and the 2558_guilds.sql u can find them at : trunk\sql\character_updates in the SVN