Bukkit

What steps will reproduce the problem?
1. /Open a ticket
2.Read the book and type a response
3. /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 list
2013-08-30 07:49:39 [INFO] HammerHedd issued server command: /ticket open 3
2013-08-30 07:50:28 [INFO] HammerHedd issued server command: /ticket reply
2013-08-30 07:50:28 [INFO] SQLException: Unknown column 'ticket_id' in 'field list'
2013-08-30 07:50:28 [INFO] SQLState: 42S22
2013-08-30 07:50:28 [INFO] VendorError: 1054
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)
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?