Opened 6 years ago

Closed 6 years ago

#884 closed defect (fixed)

Pubstats Rank SQL Error

Reported by: 24 Owned by: 24
Priority: normal Milestone: milestone:
Component: Database Version: Current Website
Severity: major Keywords:
Cc:

Description

#1690 - BIGINT UNSIGNED value is out of range in '(pubstats.tblScore.fnWins - pubstats.tblScore.fnLosses)'

www.trenchwars.org/index.php?v=pubstats&x=prof&player=VisualSneeze

On right side under Rank, getting above error. Could be security threat as it gives away table schema.

-24

Change History (2)

comment:1 Changed 6 years ago by 24

  • Status changed from new to accepted

comment:2 Changed 6 years ago by 24

  • Resolution set to fixed
  • Status changed from accepted to closed

Fixed.

Resultion: Changed pubstats.tblScore fields fnWins, fnLosses, fnKillPoint, fnFlagPoints from attributes "unsigned" to signed.

-24

Note: See TracTickets for help on using tickets.