Field 'min_security_troops' maximum size can be reached

[kirirur]

The mathematic formula used to calculate the minimum security troops needed by each colonized planet, can overflow the maximum size (signed int) of min_security_troops field in planets table when the player has more then 142 planets (typically Settlers NPG can easily reach and go beyond that value).

With mySQL version 5.1 the problem was never signaled, the issue appear with mySQL version 5.5 and above, where query execution rises a warning (investigation shall be performed to check if this interrupts the whole query and the following rows affected by it or not).

Solutions can be several:

• limit Settlers NPC to 140 planets or lower
• remove Settlers planets from min security troops check
• change the formula (if possible) with an asymptotic one
• other...

[kirirur]

There are also similar problems, regarding Settlers NPC planets, with job Update planets.