This site works best with JavaScript enabled. Please enable JavaScript to get the best experience from this site.
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:latestBukkit: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.
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
@Edge209: Go
Also having the same problem using version OnTime V3.12.2. I want to use this in a multi server environment.
This issue has been addressed in OnTime v3.13.4
To post a comment, please login or register a new account.