plugin dont save data and write this

Create issue
Issue #87 resolved
ma11221 created an issue

plugin dont save data and write this

12:06:30 [SEVERE] null java.sql.SQLException: Cannot execute statement: impossible to write to binary l og since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja va:2111) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2407) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2325) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :2310) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Del egatingPreparedStatement.java:102) at nl.lolmewn.stats.Main.executeNewQueue(Main.java:538) at nl.lolmewn.stats.Main.runTableUpdates(Main.java:508) at nl.lolmewn.stats.Main.access$200(Main.java:41) at nl.lolmewn.stats.Main$6.run(Main.java:744) at org.bukkit.craftbukkit.v1_5_R3.scheduler.CraftTask.run(CraftTask.java :53) at org.bukkit.craftbukkit.v1_5_R3.scheduler.CraftAsyncTask.run(CraftAsyn cTask.java:53) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor. java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor .java:603) at java.lang.Thread.run(Thread.java:722)

and I need to have online mod true?

Comments (11)

  1. Kirijio

    Hi,

    I have the same bug but I don't understand you're going for modify this file ...

    src/main/java/nl/lolmewn/stats/mysql/MySQLLib.java But, where ? In the .jar ? In the .jar, I have : Stats.jar\nl\lolmewn\stats\mysql\MySQLLib.class (If it's that, how modify .class ?)

    Thank you in advance for your help :)

  2. Kirijio

    if the update is not for now, would it be possible to have a temporary solution before the next version (your plugin looks to me really well, it would bother me to find another ...)

  3. Sybren Gjaltema repo owner

    Probably when I get back from vacation (somewhere around next month). Currently far far away so can't really do anything from here ;)

  4. Kirijio

    Could you tell me where the file give you more top "ma11221" I test handling. ? (in the jar.?) sorry to bother you doing during your vacation :) Big thank you in advance!

  5. Log in to comment