[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


    It seems to be updating stats on the site okay, but on the console i keep getting this error:
    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


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


    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


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


    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


    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


    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



    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


    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


    @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


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


    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


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


    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:

    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


    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


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


    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.


    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


    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.

  24. Offline


    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


    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


    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....

  27. Offline


    @ChaseHQ Have you seen this error?

    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


    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


    Getting this error with CB#990

    Show Spoiler

            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


    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.......


Share This Page