MySQL related: Not inserting to database #27


  • New
  • Defect
Open
Assigned to _ForgeUser7585445
  • _ForgeUser8474398 created this issue Jun 1, 2012

    What steps will reproduce the problem?
    1. Install plugin
    2. configure to MySQL
    3. write a little PHP script to draw from it.

    What is the expected output? What do you see instead?
    Expected: %player has been banned
    for %reason.

    Got:
    14:26:32 [INFO] [EasyBan] Data truncation: Incorrect datetime value: '1970-01-01 01:01:40' for column 'until' at row 2
    14:26:32 [INFO] test has been banned
    14:26:32 [INFO] Reason: this_reason
    14:26:32 [INFO] [EasyBan] test has been banned by Console
    14:26:59 [SEVERE] java.lang.NullPointerException
    14:26:59 [SEVERE]     at uk.org.whoami.easyban.tasks.UnbanTask.run(UnbanTask.java:37)
    14:26:59 [SEVERE]     at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    14:26:59 [SEVERE]     at java.lang.Thread.run(Thread.java:679)

    What version of the product are you using?
    3.0.2

    Do you have an error log of what happened?
    14:26:32 [INFO] [EasyBan] Data truncation: Incorrect datetime value: '1970-01-01 01:01:40' for column 'until' at row 2
    14:26:32 [INFO] test has been banned
    14:26:32 [INFO] Reason: this_reason
    14:26:32 [INFO] [EasyBan] test has been banned by Console
    14:26:59 [SEVERE] java.lang.NullPointerException
    14:26:59 [SEVERE]     at uk.org.whoami.easyban.tasks.UnbanTask.run(UnbanTask.java:37)
    14:26:59 [SEVERE]     at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    14:26:59 [SEVERE]     at java.lang.Thread.run(Thread.java:679)

    Please provide any additional information below.

    The SQL server is in a remote location, +1 hours, (UK - NL).
    Server does NOT complain about not being able to keep up.
    PHP script markup is OK
    SQL workbench picks up nothing also.

    Server OS:
    Linux Mint Debian Desktop
    6GB DDR3 RAM
    2.9GHz CPU
    30MBit WAN
    60GB SSD
    OpenJDK 6 JRE (also tried with Java Sun)

    MySQL server:
    2.66GHz Xeon
    Latest MySQL binaries
    512MB RAM
    PHP5

    MySQL configuration server sided allows any remote host to connect providing a password, database structure is set just fine.

  • _ForgeUser8474398 added the tags New Defect Jun 1, 2012
  • _ForgeUser8474398 added an attachment Screenshot-Terminal-2.png Jun 1, 2012

    Screenshot-Terminal-2.png

  • Forge_User_62037315 posted a comment Jun 2, 2013

    I get the same "[EasyBan] Data truncation: Incorrect datetime value: '1970-01-01 00:01:40' for column 'until' at row 2". Creates a row for the player in the 'player' table, but does not record the ban in the 'player_ban' table.

    I see none of the other errors, however.


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