Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers

Support::Linux Servers Support forum for Linux EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2014, 06:14 AM
vsab's Avatar
vsab
Discordant
 
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
Default 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?
Reply With Quote
  #2  
Old 10-27-2014, 08:02 PM
vsab's Avatar
vsab
Discordant
 
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
Default

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
Reply With Quote
  #3  
Old 10-27-2014, 08:12 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Try running those queries manually and see if you get any query bombs. It could be a schema issue.
Reply With Quote
  #4  
Old 10-28-2014, 07:08 AM
vsab's Avatar
vsab
Discordant
 
Join Date: Apr 2014
Location: United Kingdom
Posts: 276
Default

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.
Reply With Quote
  #5  
Old 10-28-2014, 01:03 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:30 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3