EQEmulator Forums - 1119 groups?

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

- Development::Bug Reports (https://www.eqemulator.org/forums/forumdisplay.php?f=591)

- - 1119 groups? (https://www.eqemulator.org/forums/showthread.php?t=26113)

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.

no one else is having this problem?

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, & 1128) was to clean up situations like this, but I could be wrong.

ok im like way behind i thought i was running the most current version.

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

What SQL errors are you getting it's not saving them to the table.

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.

Quote:

Originally Posted by spider661 (Post 155482)

Did you check and make sure there were no other SQL updates since 1119 ?

all the ones above is all i saw so unless someone sees some thing i missed.. and please say thats all it is

did you set your MySql to use InnoDB feature also?

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).

only think im seeing in the world window when player zone is unable to get group id, char not found

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.

ok i deleted the info in the table and there still dropping

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.