thankyou
Donate to the B3 fund!

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

Full documentation and information about XLRstats version 2 can be found at this subsection of our site.

Our upcoming XLRstats version 3 (League Edition) is currently being developed. You can have a glimpse on our main XLRstats website: www.xlrstats.com


Author Topic: Xlrstats failing to write all stats  (Read 3014 times)

Offline micycle

  • Newbie
  • *
  • Posts: 3
Xlrstats failing to write all stats
« on: January 13, 2014, 08:01:09 PM »
Despite '<set name="minlevel">0</set>', Xlrstats isn't writing the entirety of client kills to the SQL databases [xlr_mapstats].

I'm getting these errors (which may evidence the problem) in the b3.log:

http://pastebin.com/RpQ69faK


...oh, and this problem has only started recently.

Offline Courgette

  • Senior Dev.
  • Hero Member
  • *
  • Posts: 4883
    • Github repository
Re: Xlrstats failing to write all stats
« Reply #1 on: January 13, 2014, 08:03:34 PM »
could you restart B3, wait for it to start up and then post here your b3.log file please ?

Offline micycle

  • Newbie
  • *
  • Posts: 3
Re: Xlrstats failing to write all stats
« Reply #2 on: January 13, 2014, 08:06:21 PM »
I've restarting it many times and the problem still persists. Here's the full log:

http://pastebin.com/Dai76bzU

Offline MordyT

  • Support Hero
  • Hero Member
  • *
  • Posts: 3644
  • Over $300 Donated to B3!
    • MordyT
Re: Xlrstats failing to write all stats
« Reply #3 on: January 13, 2014, 10:10:16 PM »
A shot in the dark here, but I would try these 2 things to gather more info: (I personally suspect a database issue).

1. Run a repair on the SQl database (maybe also run optimize?) Test and see if issue remains.
2. Copy the database, then import as a second database. Drop and re-create the xlrstats tables in the second database. Test and see if issue remains.

ofc, you will need to be slightly comfortable with sql / phpmyadmin to do this, not saying you have to, but this is what I would do in this case.

If you don't feel comfortable, don't worry about it.
Help will be given to those with a b3.log

If drop off the map it is due to RL becoming busy :)

System: Python 2.7.3 - Deb 7 - B3 Source Code - 128MB RAM box (rented at $5 a year) - remote MySQL - Remote Web Services

Offline micycle

  • Newbie
  • *
  • Posts: 3
Re: Xlrstats failing to write all stats
« Reply #4 on: January 13, 2014, 10:37:42 PM »
Repairing the 'xlr_playerbody' table fixed the issue - thankyou. ;D

Offline MordyT

  • Support Hero
  • Hero Member
  • *
  • Posts: 3644
  • Over $300 Donated to B3!
    • MordyT
Re: Xlrstats failing to write all stats
« Reply #5 on: January 14, 2014, 04:01:12 PM »
Repairing the 'xlr_playerbody' table fixed the issue - thankyou. ;D
No problem.
Like a said -  a shot in the dark, but I have seen this error (similar to it) back when I ran a hosting business and that is how I fixed it (I think).
Glad to know it worked for you.
Help will be given to those with a b3.log

If drop off the map it is due to RL becoming busy :)

System: Python 2.7.3 - Deb 7 - B3 Source Code - 128MB RAM box (rented at $5 a year) - remote MySQL - Remote Web Services

 


Rate this page +1 at Google Search