[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


    Ok great, so all is working well ? :)
  2. Offline

    tha d0ctor

    all I did was update from 1.2 to 1.3 would this cause the issue? also what table should I be keeping an eye out for?
  3. Offline


    No the update doesnt effect the database except add 3 values. Look in the statistician database you made, are the tables all present and the statistician user has all rights to that database?
  4. Offline


    very much so, I love it, its perfect. Keep up the good work
  5. Offline


    Plug-in is being used well. However, the window showing the character skins that do not support Java 7 it?
  6. Offline


    Is this due to multiworlds? As soon as someone on another world logs in, this happens and a server reset is needed.

    2011-07-01 22:41:29 [SEVERE] Exception in thread "pool-2-thread-1"
    2011-07-01 22:41:29 [SEVERE] java.lang.NumberFormatException: null
    2011-07-01 22:41:29 [SEVERE] at java.lang.Long.parseLong(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at java.lang.Long.parseLong(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$1.run(EDHPlayer.java:41)
    2011-07-01 22:41:29 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    2011-07-01 22:41:29 [SEVERE] at java.lang.Thread.run(Unknown Source)
    Im using bukkit 9.35 still and permissions 2.72
  7. Offline


    Hey Chase,

    Slight feature request. Can you make it stop resetting server uptime when plugins are reloaded? It resets the whole stats page, I just reloaded with 54 people on now it shows 7 until people log out then back on. Is there a way to make it check the startup time against the shutdown time? If its less than say 2 minutes, ignore the shutdown and continue on like nothing has changed?

    Thanks and get a donation page up already, Im not going to mail a check, I cant remember how to write one.
  8. Offline


    Cheers for pointing me to this plugin, it's pretty awesome. Sadly I haven't got access to my phpmyadmin right now so it'll have to wait a couple days.

    A quick suggestion, would it be possible to suffix all the SQL tables with "stat-" or something, purely as they currently do nothing to distinguish themselves, not only that but it keeps them tidier and more obvious.
  9. Offline

    tha d0ctor

    this is the problem im having too, I want to remove it and try again with a clean install but I cant figure out which tables are which

    I'm having this problem in conjunction with my error


    also the user account linked with the database has full root access
  10. Offline


    Sorting for the detailed lists
  11. Offline


    I have a problem with this plugin; I uploaded the files for the web portal to my website, and changed the config settings, but when I try to access the stats, it gives me an error;
    Statistician Web Interface could not acquire connection to Database
    You can find the page at http://www.penguinz.heliohost.org/penguinzftw/statistician_web/
    I made sure that the database was set up correctly.

    tl;dr: Statistician does log all of the data into the database, but the web portal doesn't work.

    Can someone help me with this?
  12. Offline


    I recently downloaded and installed your plugin, i created the database and the user but upon running it i got this error
    18:18:27 [SEVERE] Error occurred while enabling Statistician v1.3 (Is it up to d
    ate?): java.lang.Integer cannot be cast to java.lang.String
    java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Stri
            at com.ChaseHQ.Statistician.Config.Config.<init>(Config.java:76)
            at com.ChaseHQ.Statistician.Config.Config.getConfig(Config.java:33)
            at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlug
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManage
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:151)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:136
            at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Is the plugin out of date ? im using the most recent bukkit version, or did i miss something completely? sorry for posting probably a pretty stupid question...
  13. Offline

    Geoff Winans

    This plugin seems to be incapable of spotting online users.

    Currently Online: 0

    Actual: 11.

    Just saw this:
    18:37:10 [INFO] [Statistician] CALL minecraft.logoutPlayer('7c34552a-19c1-4006-a129-fa7ad2f7cd20'); :: Stored Procedure Failed, Checking Connection
    18:37:10 [INFO] [Statistician] Connection has been lost with Database, Attempting Reconnect.
    18:37:10 [INFO] [Statistician] Connection to the database re-established, We lost some stats though :(
    This is not a problem with MySQL. Does this plugin use Persistent connections?

    Also, why would stats be lost? It'd make sense to store it in a buffer until it could successfully insert.
  14. Offline


    Hmmm, for me it works. perfect with #953
    But if you reload Plugins, the users have to reconnect
  15. Offline


    This was the feature request I asked for last night. Maybe a reload command would be helpful.
  16. Offline


    Getting the following over and over,

    2011-07-03 00:56:29 [INFO] [Statistician] Connection is still present... It may of been a malformed Query ?
    2011-07-03 00:56:29 [INFO] [Statistician] UPDATE players SET distance_traveled = distance_traveled + 36 WHERE uuid = '74fa7e0d-cde6-426c-8a1d-5110bc8eb28e' :: Update Failed, Checking Connection
  17. Offline


  18. Offline


    Yes all the connections are presistant, is this DB on a seperate box as the MC server, but still on the same Network? Are you using MySQL 5.0 >

    Kex3 had a similiar issue as you in the first page of this topic. He found in his mysql log that his stack was too low.
    Take a look at this
    May wanna look at your my.cnf
    That seems to be the problem your having
    That should fix it

    In next versionall will be prefixed

    Thx man , looks great

    The problem seems to be in your DBConfig.yml file, please post the contents

    The Tables Currently Being Used are - (Next version they will be prefixed)
    The Views are:
    The Function/Procdures are:

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

    tha d0ctor

    thanks man! I found the problem my players table did not exist!
  20. Offline


    No problem! All work well now?
  21. Offline

    Geoff Winans

    Hi, Chase.

    I use MySQL 5.5.13-20.4 (Percona Build) with the following configuration I custom built for the box (I'm a MySQL DBA by profession).

    Show Spoiler

    datadir         = /var/lib/mysql
    basedir         = /usr
    port            = 3306
    socket          = /var/lib/mysql/mysql.sock
    server-id = 10
    #max-relay-log-size      = 128M
    #max-binlog-size         = 128M
    #relay-log               = /var/lib/mysql/gominecraft-relay-bin
    binlog_format = MIXED
    log_bin = gominecraft-master
    log_bin_index = gominecraft-master.index
    innodb_file_per_table           = 1
    default-storage-engine          = InnoDB
    innodb_file_format              = barracuda
    innodb_buffer_pool_size          = 4G
    innodb_additional_mem_pool_size  = 10M
    innodb_log_buffer_size           = 8M
    innodb_flush_log_at_trx_commit   = 1
    innodb_lock_wait_timeout         = 50
    innodb_fast_shutdown             = 1
    innodb_flush_method              = O_DIRECT
    transaction_isolation            = READ-COMMITTED
    max_connections                 = 500
    connect_timeout                 = 300
    wait_timeout                    = 300
    interactive_timeout             = 300
    max_allowed_packet              = 64M
    open_files_limit                = 2048
    table_cache                     = 2048
    net_buffer_length               = 8K
    query_cache_type                = 1
    query_cache_size                = 16M
    thread_cache                    = 100
    tmp_table_size                  = 64M
    key_buffer_size = 64M
    sort_buffer_size = 512K
    net_buffer_length = 8K
    read_buffer_size = 256K
    read_rnd_buffer_size = 512K
    myisam_sort_buffer_size = 8M
    max_allowed_packet = 16M
    key_buffer_size = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M
  22. Offline

    tha d0ctor

    It worked perfectly until I did a reloadall of my server and now it is giving me problems with the players column again, saying it doesnt exist...
  23. Offline


    Currently there is a bug with using reloadall. It's fixed in the next version. Will be releasing it Tuesday after the holiday vacation here in the states.
  24. Offline


    If you add total play time for players and play time by days for player I will install and use this.
  25. Offline


    It is already there! Take a look at the portals, it's already implemented.
  26. Offline


  27. Offline


    In the original post, at the bottom. Those are all live portals.
  28. Offline


    What I don't see implemented is the feature to see login time by day, not the total.
    I am interested person X how many hours was playing today, yesterday, last week on monday.

    I am getting this error tring to run the php file:
    Deprecated: Assigning the return value of new by reference is deprecated in E:\xampp\php\PEAR\Config.php on line 80
    Deprecated: Assigning the return value of new by reference is deprecated in E:\xampp\php\PEAR\Config.php on line 166
    Deprecated: Assigning the return value of new by reference is deprecated in E:\xampp\php\PEAR\Config\Container.php on line 111
    Statistician Web Interface could not acquire connection to Database
    The plugin is working, filled up the databse.
    I edited the config file in the stats folder in the web folder.

    Any ideas?
  29. Offline


    The depreciation warnings is a problem with your PEAR installation. Google it.
  30. Offline


    My server is on my home PC - Windows.
    Could this be the problem?

    I am not verry familiar with Linux, but in the time I used some Ubuntu I got familiar with the commands and all these here seems to be Linux comands? - http://pear.php.net/package/PEAR/download/All

Share This Page