thankyou
Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!

Author Topic: error loading xlrstats plugin  (Read 1067 times)

Offline obteo

  • Sr. Member
  • ****
  • Posts: 152
    • B2KilL Clan
error loading xlrstats plugin
« on: September 10, 2016, 07:18:26 PM »
Hi guys,

do you know why i have this error please?


Code: [Select]
160910 19:16:38 ERROR    'Query failed [SELECT MAX(xlr_playerstats.skill) AS max_skill, MIN(xlr_playerstats.skill) AS min_skill, SUM(xlr_playerstats.skill) AS sum_skill,\n               AVG(xlr_playerstats.skill) AS avg_skill , COUNT(xlr_playerstats.id) AS cnt\n               FROM xlr_playerstats, clients\n               WHERE clients.id = xlr_playerstats.client_id\n               AND xlr_playerstats.client_id <> 1\n               AND (xlr_playerstats.kills + xlr_playerstats.deaths) > 50\n               AND 1473527798 - clients.time_edit <= 5184000] None: (1690, u"BIGINT UNSIGNED value is out of range in \'(1473527798 - `admin_b3`.`clients`.`time_edit`)\'")'
160910 19:16:38 ERROR    'Could not start plugin xlrstats'
Traceback (most recent call last):
  File "/home/b2k/cod4/bot/b3/parser.py", line 1105, in startPlugins
    start_plugin(self, plugin_name)
  File "/home/b2k/cod4/bot/b3/parser.py", line 1096, in start_plugin
    p.onStartup()
  File "/home/b2k/cod4/bot/b3/plugins/xlrstats/__init__.py", line 252, in onStartup
    self.correctStats()
  File "/home/b2k/cod4/bot/b3/plugins/xlrstats/__init__.py", line 1553, in correctStats
    cursor = self.query(q)
  File "/home/b2k/cod4/bot/b3/storage/common.py", line 633, in query
    raise e
InternalError: (1690, u"BIGINT UNSIGNED value is out of range in '(1473527798 - `admin_b3`.`clients`.`time_edit`)'")
thank you.

Offline 82ndAB.Bravo17

  • Dev. Team
  • Hero Member
  • *
  • Posts: 2605
Re: error loading xlrstats plugin
« Reply #1 on: September 10, 2016, 11:56:59 PM »
Check the values of the time_edit entries in your clients table, one or more of them may be corrupted.

They should all look similar to
Code: [Select]
1473527798
[/pre]
or be zero

Offline obteo

  • Sr. Member
  • ****
  • Posts: 152
    • B2KilL Clan
Re: error loading xlrstats plugin
« Reply #2 on: September 11, 2016, 12:36:43 PM »
Hi thank you, how to fix it with a repair in phpmyadmin?

Offline 82ndAB.Bravo17

  • Dev. Team
  • Hero Member
  • *
  • Posts: 2605
Re: error loading xlrstats plugin
« Reply #3 on: September 11, 2016, 05:53:07 PM »
I would try just setting it to zero, or you could use the timestamp that was in the original error.
Code: [Select]
1473527798
[/pre]

 


Rate this page +1 at Google Search