Database Malformed #372


  • New
  • Defect
Open
  • eodcrafter created this issue Jul 13, 2015

    What steps will reproduce the problem?
    1. Any
    2.
    3.

    What is the expected output? What do you see instead?
    normal Stats

    What version of the product are you using?
    Latest Stable

    Do you have an error log of what happened? (Portal: check cache/error.txt)
    17:35:09 WARN]: Exception in thread "Craft Scheduler Thread - 2156"
    [17:35:09 WARN]: org.apache.commons.lang.UnhandledException: Plugin Statistics v1.2.4 generated an exception while executing task 207258
            at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:56)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
            at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.NullPointerException
            at com.wolvencraft.yasp.session.OnlineSession.pushData(OnlineSession.java:195)
            at com.wolvencraft.yasp.util.tasks.DatabaseTask.commit(DatabaseTask.java:97)
            at com.wolvencraft.yasp.cmd.DatabaseCommands$1.run(DatabaseCommands.java:60)
            at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
            at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
            ... 3 more

    Please provide any additional information below. (Plugin/Portal Version, Server Version, PHP Version. MySQL Version)

    Nice Plugin..Please fix!

  • eodcrafter added the tags Defect New Jul 13, 2015
  • rautamiekka posted a comment Jul 13, 2015

    Extremely useful bug report, with extreme amount of sarcasm.

  • eodcrafter posted a comment Jul 13, 2015

    Here's what the webPage says...

    Sorry. An unexpected error occurred.
    
    MySQL error (Table 'stats.stats_entities' doesn't exist) in SELECT SUM(pve.player_killed) AS total, e.entity_id FROM "stats_total_pve_kills" pve, "stats_entities" e WHERE pve.entity_id = e.entity_id GROUP BY pve.entity_id ORDER BY SUM(pve.player_killed) DESC LIMIT 0,1
    
    Type: fSQLException
    File: /var/www/html/include/vendor/flourish/flourish/fDatabase.php:456
    
    {doc_root}/index.php(29): Design->display('overview.php')
    {doc_root}/include/classes/Design.php(257): Design->loadModule('overview.php')
    {doc_root}/include/classes/Design.php(144): Module->__construct('overview.php', Array, Object(Design))
    {doc_root}/include/classes/Module.php(41): include('{doc_root}/c...')
    {doc_root}/contents/default/overview.php(81): Entity::getMostDangerous()
    {doc_root}/include/classes/orm/Entity.php(66): fDatabase->translatedQuery('?              ...')
    {doc_root}/include/vendor/flourish/flourish/fDatabase.php(3326): fDatabase->run('SELECT SUM(pve....', 'fResult')
    {doc_root}/include/vendor/flourish/flourish/fDatabase.php(3028): fDatabase->performQuery('SELECT SUM(pve....', Object(fResult), Array)
    {doc_root}/include/vendor/flourish/flourish/fDatabase.php(2565): fDatabase->checkForError(Object(fResult), NULL)
    {doc_root}/include/vendor/flourish/flourish/fDatabase.php(456)
    
  • eodcrafter posted a comment Jul 13, 2015

    I really don't want to bore you with useless information.

  • eodcrafter posted a comment Jul 13, 2015

    I run all the latest PHP and MYSQL Unbuntu 14.04, Java 8.What else you need?

  • rautamiekka posted a comment Jul 13, 2015

    There's no such version number as latest version. Too many ppl don't know that.

  • rautamiekka posted a comment Jul 13, 2015

    1) Take backup of the data
    2) Run §/stats repatch§ to force re-running the patches. There should still be faults in the SQL files, so it should fail and you need to fix the files yourself.

  • eodcrafter posted a comment Jul 13, 2015

    Yea sry , the latest stable release you have on the page....I'll try that but i'm running 1.8.7 server and I guess something has changed since 1.8.1.

  • eodcrafter posted a comment Jul 13, 2015
    [18:19:05 INFO]: [Stats] Attempting to patch the database...
    [18:19:05 INFO]: [Statistics] +-------] Database Patcher [-------+
    [18:19:05 INFO]: [Statistics] |       Applying patch 2 / 14       |
    [18:19:05 INFO]: [Stats] Patch failed!
    [18:19:05 INFO]: [Stats] Patching finished.
    [18:19:05 INFO]: [Statistics] Connection is still present. Malformed query detected.
    [18:19:05 INFO]: [Statistics] Connection is still present. Malformed query detected.
    [18:19:05 INFO]: [Statistics] Connection is still present. Malformed query detected.
    [18:19:05 WARN]: Exception in thread "Craft Scheduler Thread - 2178"
    [18:19:05 WARN]: org.apache.commons.lang.UnhandledException: Plugin Statistics v1.2.4 generated an exception while executing task 258775
            at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:56)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
            at java.lang.Thread.run(Thread.java:745)
    Caused by: java.lang.NullPointerException
            at com.wolvencraft.yasp.db.totals.PlayerTotals.fetchData(PlayerTotals.java:79)
            at com.wolvencraft.yasp.db.totals.PlayerTotals.<init>(PlayerTotals.java:64)
            at com.wolvencraft.yasp.session.OnlineSession$1.run(OnlineSession.java:113)
            at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftTask.run(CraftTask.java:71)
            at org.bukkit.craftbukkit.v1_8_R3.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
            ... 3 more
    
  • rautamiekka posted a comment Jul 13, 2015

    Just as I expected, the patch #2 is faulty. It's been that way regardless of new updates to Statistics.

  • eodcrafter posted a comment Jul 13, 2015

    Yea, not gonna fix anything till this is compatible with all the latest php, mysql, and spigot...just a waste of time cause it will happen again with whatever is triggering the fault.

  • eodcrafter posted a comment Jul 13, 2015

    I gave the Dev Plenty of info to fix it if they want. Otherwise I will replace the page with something else.

  • eodcrafter posted a comment Jul 15, 2015

    I suppose because of my incompetence at the ticket reporting system this problem goes ignored? Well, I am sorry but I follow the instructions and it doesn't work. Don't blame the user Please.


    Edited Jul 15, 2015
  • rautamiekka posted a comment Jul 15, 2015

    <<reply 2608877>>

    Nah, knowing the devs it's gonna take long to get a reply, if any reply. Add whatever comes to your mind, when you get any; it's always the better the more you tell.

  • eodcrafter posted a comment Jul 16, 2015

    From my experience with coding it seems this would lead you to the cause....

    Caused by: java.lang.NullPointerException
            at com.wolvencraft.yasp.db.totals.PlayerTotals.fetchData(PlayerTotals.java:79)
            at com.wolvencraft.yasp.db.totals.PlayerTotals.<init>(PlayerTotals.java:64)
    
  • eodcrafter posted a comment Jul 24, 2015

    Okay, I have removed the Mcmmo Hook and the Wallet Hook and it has seemed to quell the Malformed database error.


To post a comment, please login or register a new account.