Bug #1456

cant use more than 127 servers ever

Added by Peterson 8 months ago. Updated 4 days ago.

Status:Resolved Start date:10/03/2011
Priority:Normal Due date:
Assignee:Packhead % Done:

0%
Category:General
Target version:1.6.16
Affected Version: Blocking Target Version:No

Description

need to change the structure of SQL for hlstats_server_load Field: server_id Type: tinyint(4) to something like int(6) so we can have more than 127 servers in stats. also, you might need to increase some other types just to make sure everything is ok.

Associated revisions

Revision 780:9fd074ae8716
Added by Packhead 5 days ago

General: Modified install.sql hlstats_server_load.server_id column to type INT (#1456)

Revision 783:9aa15c84b62f
Added by Packhead 4 days ago

General: Updated line endings on 67.php and 68.php to Unix style.
General: Alter the column type for hlstats_server_load to support more server IDs (#1456)

Revision 784:b08234790499
Added by Packhead 4 days ago

#1456 - Updating livestats table to also use int(10) for server_id.

History

#1 Updated by Packhead 3 months ago

  • Category set to General
  • Status changed from New to Assigned
  • Assignee set to Packhead
  • Target version set to 1.6.16

#2 Updated by BoNzO 24 days ago

If it's signed tinyint the value is 127, if it's unsigned the max value is 255.

#3 Updated by Peterson 24 days ago

still though, shouldnt be that limited. or if you could recycle server IDs, it would be fine. ish..

#4 Updated by Packhead 4 days ago

  • Status changed from Assigned to Resolved

The hlstats_server_load table needs to have the server_id column type changed to INT to match hlstats_Servers.

Fixed install.sql hlx-16 9fd074ae8716
Updates in hlx-16 0119d9e6bb47

#5 Updated by Packhead 4 days ago

Found a few more columns that didn't have the same int(10) typing for server_id, so I've changed them as well.

hlx-16: b08234790499

Also available in: Atom PDF