This site works best with JavaScript enabled. Please enable JavaScript to get the best experience from this site.
What steps will reproduce the problem?1. /Open a ticket2.Read the book and type a response3. /Ticket Reply
What is the expected output? What do you see instead?From the client side, it is working, as the failover procedure saves to a flatfile. However, the MySQL portion throws errors. Looking at the error and the database, I suspect that the problem is that the database field is called "book_id" and the plugin is looking for "ticket_id"
What version of the product are you using?1.2
Do you have an error log of what happened?2013-08-30 07:49:29 [INFO] HammerHedd issued server command: /ticket list2013-08-30 07:49:39 [INFO] HammerHedd issued server command: /ticket open 32013-08-30 07:50:28 [INFO] HammerHedd issued server command: /ticket reply2013-08-30 07:50:28 [INFO] SQLException: Unknown column 'ticket_id' in 'field list'2013-08-30 07:50:28 [INFO] SQLState: 42S222013-08-30 07:50:28 [INFO] VendorError: 10542013-08-30 07:50:28 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ticket_id' in 'where clause'2013-08-30 07:50:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)2013-08-30 07:50:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)2013-08-30 07:50:28 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)2013-08-30 07:50:28 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)2013-08-30 07:50:28 [SEVERE] at me.staartvin.bookticket.mysql.MySQLHandler$2.run(MySQLHandler.java:121)2013-08-30 07:50:28 [SEVERE] at org.bukkit.craftbukkit.v1_6_R2.scheduler.CraftTask.run(CraftTask.java:53)2013-08-30 07:50:28 [SEVERE] at org.bukkit.craftbukkit.v1_6_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)2013-08-30 07:50:28 [SEVERE] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)2013-08-30 07:50:28 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)2013-08-30 07:50:28 [SEVERE] at java.lang.Thread.run(Unknown Source)2013-08-30 07:50:28 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ticket_id' in 'where clause'2013-08-30 07:50:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)2013-08-30 07:50:28 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)2013-08-30 07:50:28 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)2013-08-30 07:50:28 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.Util.getInstance(Util.java:382)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)2013-08-30 07:50:28 [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)2013-08-30 07:50:28 [SEVERE] at me.staartvin.bookticket.mysql.MySQLHandler$2.run(MySQLHandler.java:121)2013-08-30 07:50:28 [SEVERE] at org.bukkit.craftbukkit.v1_6_R2.scheduler.CraftTask.run(CraftTask.java:53)2013-08-30 07:50:28 [SEVERE] at org.bukkit.craftbukkit.v1_6_R2.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)2013-08-30 07:50:28 [SEVERE] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)2013-08-30 07:50:28 [SEVERE] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)2013-08-30 07:50:28 [SEVERE] at java.lang.Thread.run(Unknown Source)
Please provide any additional information below.
Just wanted to bump this and mention again that I'm happy to help with the SQL if you would like help.
I do love this plugin, BTW.
It might be that you have an old version of the database. I added the column in a later version. If you created the database with the old version, it would not have included the new column. Could you reset your database and let it create a new one?
To post a comment, please login or register a new account.