Re: [Ascent] Guild Problems
Your guilds table structure isn't complete. You need to make sure you have executed all of the SQL files included with your revision.
Re: [Ascent] Guild Problems
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 ?
Re: [Ascent] Guild Problems
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.
Re: [Ascent] Guild Problems
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;
Re: [Ascent] Guild Problems
Quote:
Originally Posted by
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;
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.
Re: [Ascent] Guild Problems
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
Code:
/*
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