Cannot group more than 2 characters

[vsab]

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?

[vsab]

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.


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

[Akkadius]

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

[vsab]

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.

[Akkadius]

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.