|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Development::Bug Reports Post detailed bug reports and what you would like to see next in the emu here. |
|
|
|
09-07-2008, 07:36 PM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
1119 groups?
im getting a problem with groups disbanding all together when a player zones it took me awhile to see the problem.. om my gm i grouped up.. zoned out and was still in group but then when i zoned back in my group was gone. it cleared on both chars #refreshgroup did nothing
i put these dbs in
Code:
Required SQL:
CREATE TABLE `blocked_spells` (
`id` int(11) NOT NULL auto_increment,
`spellid` mediumint(8) unsigned NOT NULL default '0',
`type` tinyint(4) NOT NULL default '0',
`zoneid` int(4) NOT NULL default '0',
`x` float NOT NULL default '0',
`y` float NOT NULL default '0',
`z` float NOT NULL default '0',
`x_diff` float NOT NULL default '0',
`y_diff` float NOT NULL default '0',
`z_diff` float NOT NULL default '0',
`message` varchar(255) NOT NULL default 'You cannot cast that spell here',
`description` varchar(255) default NULL,
PRIMARY KEY (`id`)
)
CREATE TABLE `group_id` (
`groupid` int(4) NOT NULL,
`charid` int(4) NOT NULL,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`groupid`, `charid`)
)
ENGINE = InnoDB;
UPDATE npc_spells_entries SET type='512' WHERE spellid='48';
UPDATE npc_spells_entries SET type='512' WHERE spellid='49';
UPDATE npc_spells_entries SET type='512' WHERE spellid='1526';
UPDATE npc_spells_entries SET type='512' WHERE spellid='1697';
CREATE TABLE `group_leaders` (
`gid` int(4) NOT NULL,
`leadername` varchar(64) NOT NULL,
PRIMARY KEY (`gid`)
)
ENGINE = InnoDB;
patch_6.2.conf and patch_Titanium.conf files have changed be sure to update them.
|
|
|
|
09-08-2008, 02:49 AM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
no one else is having this problem?
|
09-08-2008, 02:58 AM
|
Developer
|
|
Join Date: Mar 2007
Location: Ohio
Posts: 648
|
|
I'm still running 1119 on A Work in Progress, but I haven't tested it myself.
If I remember correctly, I think that was why KLS fixed the group code (in 1125, 1127, & 112 was to clean up situations like this, but I could be wrong.
|
09-08-2008, 04:26 AM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
ok im like way behind i thought i was running the most current version.
|
09-08-2008, 04:28 AM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
OMG im sorry im running 1129 lol not 1119 that was my old version.. ok anyone having the problems with 1129?
can someone change the topic to read 1129 please please
|
09-08-2008, 02:47 PM
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
What SQL errors are you getting it's not saving them to the table.
|
09-08-2008, 03:55 PM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
im not seeing any errors.. my zone screens show no info output onthem.. i have not seen anything on my world server and i have not noticed anything in the logs.. i see the tables filling.. with group info when i go check the tables.
|
09-08-2008, 04:20 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
Quote:
Originally Posted by spider661
im not seeing any errors.. my zone screens show no info output onthem.. i have not seen anything on my world server and i have not noticed anything in the logs.. i see the tables filling.. with group info when i go check the tables.
|
Did you check and make sure there were no other SQL updates since 1119 ?
|
09-08-2008, 04:30 PM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
all the ones above is all i saw so unless someone sees some thing i missed.. and please say thats all it is
|
09-08-2008, 04:46 PM
|
AX Classic Developer
|
|
Join Date: May 2006
Location: filler
Posts: 2,049
|
|
did you set your MySql to use InnoDB feature also?
|
09-08-2008, 05:53 PM
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
It should be throwing an error; it might be in printf so you'd have to not use launcher (I know I know but I just copied much of the group code that was already there).
|
09-09-2008, 08:08 AM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
only think im seeing in the world window when player zone is unable to get group id, char not found
|
09-09-2008, 09:06 AM
|
Dragon
|
|
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
|
|
I've had that when there's been a crash and some old groups are stuck in the table. Open both your group_id and group_leaders table and clear out whatever's inside. See if that helps.
|
09-10-2008, 08:15 AM
|
Discordant
|
|
Join Date: Oct 2005
Location: michigain
Posts: 260
|
|
ok i deleted the info in the table and there still dropping
|
09-11-2008, 01:33 AM
|
Administrator
|
|
Join Date: Sep 2006
Posts: 1,348
|
|
It's clearly having a problem selecting from the table, I'll add some better logging to it next time I patch so you can see what error it's actually throwing.
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 06:21 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|