[INACTIVE][INFO] Statistician V1.3 - Extremely Detailed Player/Server Stats Tracking [953]

Discussion in 'Inactive/Unsupported Plugins' started by ChaseHQ, Jun 23, 2011.

  1. Offline

    Mike120

    It seems to be updating stats on the site okay, but on the console i keep getting this error:
    Code:
    Statistician: UPDATE players SET num_secs_loggedon = num_secs_loggedon + 120 WHERE uuid = 'c65f8bdd-2309-4f7b-98bb-d33eaaf05611' :: Update Failed, Checking Connection
    Statistician: Connection has been lost with Database, Attempting Reconnect.
    Statistician: Connection to the database re-established, We lost some stats though :(
    Any idea why this is happening?

    There is also a similar error when anyone logs out. I'm still on 1.6.6 using whatever the latest bukkit build is for 1.6

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 17, 2016
  2. Offline

    ChaseHQ

    Yup update your Thread Stack to 512k in my.cnf (MySQL configuration) the error should go away.
     
  3. Offline

    Mike120

    Thanks for the quick reply. I've found the thread stack part in the system variables, but i can't actually change it. Do i need to run a query to change it... Sorry about this, I really hate MySQL and don't know a huge deal about it.

    I've just spoke with my hosting company, and I can't access the actual files for the database, so apparently i'm unable to edit the thread stack variable. Any workarounds?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 17, 2016
  4. Offline

    Exidous

    any support for other databases in the future? i really want to use this.
     
  5. Offline

    Bronski

    I'm also getting the stored proc error. I can double check my perms but this is almost sounding like something else if people using root are getting it(?) I'll post back after checking my perms.
     
  6. Offline

    Exidous

    FIXED IT!!!!!

    Give me a minute to write up the fix. its not hard. be patient

    If you having stored procedure problems in MySQL (Windows) use these steps to fix it.

    1. Shutdown your MC server
    2. Drop your statistician database
    3. Open command prompt with administrator privileges and navigate to your MySQL bin folder.
    4. Use this command: Mysql_upgrade.exe -u root -p
    5. Type in your root password and the tables will be upgraded. If it throws an error saying that its already been upgraded use the --force option after -p like this: Mysql-upgrade.exe -u root -p --force
    6. Create the database and make sure the configs are correct.
    7. Start mc server and let statistician create the new tables
    8. Test to make sure it works.

    This worked for me.

    now i need to figure out how to migrate MCSTATS statistics over to statistician....

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 17, 2016
  7. Offline

    Bronski

    Yeah I would like that. I'm struggling to figure out which tables this plugin uses among the ~70 in my MC database. Is there a handy list?
     
  8. Offline

    Crimsonfox

    ||
    V

    Re: the table name they were posted a few pages back, one moment.........found it:
     
    Bronski likes this.
  9. Offline

    Geoff Winans


    Fix: mysql_upgrade

    Run it.
     
  10. Offline

    Eternal Darknes

    Can you make a separate page that prints out all of a players block info in plain text separated by commas so that people without FTP/SQL access can more easily manipulate it. Said page would also be defined by username instead of user ID. I would definitely appreciate this.
     
  11. Offline

    Bronski

    Ok but are you saying it's just a version of mysql that is the minimum needed? What version would that be? I don't think my host is going to like me telling them "just run it!!" without some further info :/

    @Crimsonfox Thanks! I usually scroll back through many pages but I was having a lazy moment :D
     
  12. Offline

    Crimsonfox

    @Bronski No problem, I only knew because I brought the problem up as well. :p

    @ChaseHQ Any chance of getting a location field in the kill table?
     
  13. Offline

    Martin Holík

    Hi, I have a little problem with loading the site statistics. Loading is quite slow. The database NOTaccessinglocalhost but approaching it in the distance. Try HERE quiet. Ifanyone knows how to fix it, I'll be happy.
     
  14. Offline

    Geoff Winans

    The fact that your host is running MySQL 5.5 is very telling.

    The fact that they ran an update without running mysql_upgrade is also very telling.

    Find another host.

    If it still does not work after that, then they are intentionally stopping you from creating SProcs.
     
  15. Offline

    ChaseHQ

    Also added location killed in next DB update :) thought ahead of you on that one :)
     
  16. Offline

    AriesT

    Very good..
    What about support some plugins, like:
    iConomy, Jobs, Residence,.. or maybe something else.. ?

    May be add function of exception some player(s) from gather stats..

    And so on.. ;)
     
  17. Offline

    ChaseHQ

    Yep, all planned, i had talked about it in an earlier post. Also worldguard stats.
     
  18. Offline

    Schlumpf

    Hello,
    I also got a problem with mysql. I installed your Plugin, it looked very nice, good Job, but I have 1 problem:
    I start my Server and the Plugin creates all tables. But if I use the Command /reloadall from Essentials the table "players" is deleted. Then the Plugin always get this error and remove the "players" table:

    Code:
    2011-07-08 12:18:38 [INFO] [Statistician] Shutting down... 2011-07-08 12:18:38
    [INFO] [Statistician] UPDATE players SET num_secs_loggedon = num_secs_loggedon + 7 WHERE uuid = '2daeb180-6090-41c4-b914-feca9b108eab' :: Update Failed, Checking Connection 2011-07-08 12:18:38
    [INFO] [Statistician] Connection is still present... It may of been a malformed Query ? 2011-07-08 12:18:38
    [INFO] [Statistician] CALL Minecraft.pluginShutdown(); :: Stored Procedure Failed, Checking Connection 2011-07-08 12:18:38
    [INFO] [Statistician] CALL Minecraft.logoutPlayer('2daeb180-6090-41c4-b914-feca9b108eab'); :: Stored Procedure Failed, Checking Connection 2011-07-08 12:18:38
    [INFO] [Statistician] Connection is still present... It may of been a malformed Query ? 2011-07-08 12:18:38
    [INFO] [Statistician] Connection is still present... It may of been a malformed Query ? 2011-07-08 12:18:38
    [SEVERE] Exception in thread "pool-9-thread-4" 2011-07-08 12:18:38
    [SEVERE] java.lang.NullPointerException 2011-07-08 12:18:38
    [SEVERE] at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$2.run(EDHPlayer.java:74) 2011-07-08 12:18:38
    [SEVERE] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) 2011-07-08 12:18:38
    [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) 2011-07-08 12:18:38
    [SEVERE] at java.lang.Thread.run(Thread.java:636)
    Someone can fix this?
     
  19. Offline

    ChaseHQ

    It has already been fixed, just not released yet. If you want to build it off the github source it has the fix in there.
     
  20. Offline

    Schlumpf

    Hi,
    oh ok thanks. Sry that I didnt see it.
    When does the new release appear then? And which futures are included?
     
  21. Offline

    Bronski

    Wait, what? I never said what version my host was using. I don't even know. I'm just trying to figure out the minimum version so I can tell them.

    Sheesh.

    EDIT: And actually, the OP says:

     
  22. Offline

    Geoff Winans

    Statistician requires only MySQL 5.0+

    5.0 and 5.1 are pretty well vetted for production use. MySQL 5.5, while comfortably stable, isn't something I would consider production ready.

    That being said, @Bronski, sorry. I read someone elses post and transposed some information.
     
  23. Offline

    Bronski

    Ah ok, no problem :D

    It looks like my host is using "5.0.51a-community-log". I manually created a SP with Navicat so it seems my permissions are ok. I've removed the old Stat tables in case that was somehow part of the problem and I'll try a re-install to see if it passes the SP creation this time.

    Thanks.
     
  24. Offline

    Crimsonfox

    Haha, awesome, this plugin is also psychic and can guess what features you need before you do!

    Also my problem with sheep logging still persists, but that worry is pushed aside by the glee that location killed brings. :D
     
  25. Offline

    Yoshinat0r

    Does anybody know of a nice, straight-forward tutorial on how to set up a MySQL database? I have no idea how to do it, I have never ever had to do one, so I have no idea where to start... :oops:
     
  26. Offline

    Monstertke

    Hey Chase.

    I have 6000 players and over a year of playtime on my server since June 28th.

    Im loving that but its taking a loooooooong time to load, all the while my MySQL process is churning away at 300%+
    Im actually kind of scared to post for fear that 10 people will try to hit the page all at once....

    Is there any way you can optimize this? Cause if not its going to have to come down....

    Thanks
    MonsterTKE
     
  27. Offline

    Mhalkyer

    @ChaseHQ Have you seen this error?

    Code:
    12:00:01 [SEVERE] Exception in thread "pool-1-thread-54"
    12:00:01 [SEVERE] java.lang.NumberFormatException: null
    12:00:01 [SEVERE]       at java.lang.Long.parseLong(Long.java:401)
    12:00:01 [SEVERE]       at java.lang.Long.parseLong(Long.java:478)
    12:00:01 [SEVERE]       at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$1.run(EDHPlayer.java:41)
    12:00:01 [SEVERE]       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    12:00:01 [SEVERE]       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    12:00:01 [SEVERE]       at java.lang.Thread.run(Thread.java:636)
    
    This happened when a player called "CrazyElmoo123" logged in.
     
  28. Offline

    Crimsonfox

    Searching through, what I expect to be millions of rows, multiple times on a page, is always going to be slow. When it gets to this point you might want to consider setting up something that cuts out the searching of rows that will never change.

    For example, old rows in the kill table will never change, so setting up a system where you count everything up to say, today, save it separately and then only do searches on the table FROM that date and add it on to the figure you already have. It's possibly Chase could build that in as an option for large databases but I would almost say it's down to the user to manage their DB sizes but that could be debatable. :p
     
  29. Offline

    Mhalkyer

    Getting this error with CB#990

    Show Spoiler

    Code:
    java.lang.NullPointerException
            at com.ChaseHQ.Statistician.Listeners.StatisticianEntityListener.onEntityDeath(StatisticianEntityListener.java:27)
            at org.bukkit.plugin.java.JavaPluginLoader$57.execute(JavaPluginLoader.java:642)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
            at net.minecraft.server.EntityPlayer.die(EntityPlayer.java:141)
            at net.minecraft.server.EntityLiving.damageEntity(EntityLiving.java:391)
            at net.minecraft.server.EntityHuman.damageEntity(EntityHuman.java:436)
            at net.minecraft.server.EntityPlayer.damageEntity(EntityPlayer.java:179)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:728)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:677)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:670)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:85)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    


    I don't expect support, just giving you a heads up =)
     
  30. Offline

    Monstertke

    Minecraft- "For programmers, by programmers" ?

    I dont know how to do that shit.(Other than on a base level)

    Thats why I installed his plugin........
    And why I donate to plugin developers.

    I would think that ChaseHQ would want to made aware of this.
    I am one of the servers listed under the plugin topic, and by far
    the biggest one he has ready access to.(based on the others on the front page)

    If he wants to change it thats up to him.......

    Monstertke
     

Share This Page