Ontime SQL Errors #497


  • Defect
  • Started
Open
Assigned to _ForgeUser8455416
  • jbhitman created this issue Aug 14, 2014

    NOTE: If you supply copies of your .yml or console log files, please use pastebin, dropbox, or other service and provide link,  instead of copy/paste of the file into this report. Thanks!

    What Version of OnTime and Bukkit are you using?
    OnTime:latest
    Bukkit:latest release

    What storage option are you using? (YML or MYSQL) ?
    MYSQL

    What permissions plugin are you using? (Groupmanager, PEX,bPermissions, etc.)
    PEX

    Please provide a link to a copy of your plugins/OnTime/config.yml: http://pastebin.com/pCtrFtuA

    What steps will reproduce the problem?
    1.Happens every 5 min.  I'm assuming its when the online player status is trying to update.
    Here is what i see in the OnTime_ERROR.txt

    [08/14/2014 20:27:44]  {updateAllOnlineReport} MYSQL Write Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ontime-online' at line 1
    [08/14/2014 20:32:48]  {updateAllOnlineReport} MYSQL Write Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ontime-online' at line 1
    [08/14/2014 20:37:52]  {updateAllOnlineReport} MYSQL Write Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ontime-online' at line 1
    [08/14/2014 20:42:58]  {updateAllOnlineReport} MYSQL Write Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ontime-online' at line 1
    [08/14/2014 20:48:02]  {updateAllOnlineReport} MYSQL Write Error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ontime-online' at line 1

    What is the expected output? What do you see instead?
    N/A

    Do you have an console log of what happened?
    Nothing abnormal in console.

    Are you having a "rewards" problem?  Please provide a link to a copy of your /plugins/OnTime/rewards.yml :
    N/A

    Did you turn on OnTime logging (/ontime logfile enable 1)?  If so, provide a link to that file too. http://pastebin.com/biXTMUp0

    Please provide any additional information below.

    I have OnSigns for a leader board and they seem to update very sporadically, with incorrect information.

  • jbhitman added the tags New Defect Aug 14, 2014
  • _ForgeUser8455416 posted a comment Aug 20, 2014

    I am 99% certain I have found the error that is causing the MYSQL faults.

    If you are NOT using the 'ontime online' report to support a web page, if you disable that function then the errors will cease without having to wait for my fix. (http://dev.bukkit.org/bukkit-plugins/ontime/pages/reports/#w-online-report)

    In your config.yml:

    # Enable if Online player status should be tracked in MYSQL Table
    onlineTrackingEnable: false
    

    Note: This issue is also reported in Ticket #486


    Edited Aug 26, 2014
  • _ForgeUser8455416 removed a tag New Aug 20, 2014
  • _ForgeUser8455416 added a tag Started Aug 20, 2014
  • _ForgeUser8977039 posted a comment Aug 26, 2014

    @Edge209: Go

    Also having the same problem using version OnTime V3.12.2. I want to use this in a multi server environment.

  • _ForgeUser8455416 posted a comment Aug 26, 2014

    This issue has been addressed in OnTime v3.13.4


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