EQEmulator Forums - Cannot group more than 2 characters

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

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - Cannot group more than 2 characters (https://www.eqemulator.org/forums/showthread.php?t=38942)

Cannot group more than 2 characters

25 Oct 2014 source. All sql patches applied...

I can group 2 characters, but when I try to invite a third, it says the group leader is not the leader... Tried it with different characters as leader.

I have a vague recollection that there are some issues with TinyBLOB's way back in my mind, not sure if it's relevant... I can turn on logging - which would I need to set in log.ini?

I updated shmax in the kernel, which hasn't helped. I enabled mysql logging and don't see anything *too* obvious.

In the text below, group_id of 4001 is a valid group, but the group_leaders table never has any rows in it. I can't see any DELETES on that table besides when the server first starts up.

Not sure why it does the first update before the insert, though.

Code:

                  147 Query        UPDATE group_leaders SET leadername = 'TestCharacter' WHERE gid = 4001

                  147 Query        INSERT INTO group_leaders(gid, leadername, marknpc, leadershipaa, maintank, assist, puller, mentoree, mentor_percent) VALUES(4001, 'TestCharacter', '', '', '', '', '', '', '0')

                  147 Query        UPDATE group_leaders SET leadershipaa = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0' WHERE gid = 4001 LIMIT 1

Try running those queries manually and see if you get any query bombs. It could be a schema issue.

You know how I keep telling people to source in the sql updates in the utils/sql/git/required? Maybe I should take my own advice!

I was missing 2014_10_18_group_mentor.sql

Spot on Akkadius, you da man.

All good, that's why we're going towards an automatic database upgrade solution because it doesn't matter how smart or how long you've been here - you can still get caught by stupid shit.