Unable to run insert stmt on object

Question

Unable to run insert stmt on object

Llamatic opened this issue 9 years ago · 5 comments

Llamatic commented 9 years ago

24.12 02:34:21 [Server] WARN at me.confuser.banmanager.internal.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22)
24.12 02:34:21 [Server] WARN java.sql.SQLException: Unable to run insert stmt on object me.confuser.banmanager.data.PlayerBanRecord@31e1979b: INSERT INTO op_bm_player_ban_records (player_id ,reason ,expired ,actor_id ,pastActor_id ,pastCreated ,created ,createdReason ) VALUES (?,?,?,?,?,?,?,?)

I have updated the plugin to the latest version and I still get this error. I've also generated the table from new so its empty. I'm using 1.7.10 - 1.8 spigot using offline mode.

confuser · Answer 1 · 2015-12-24T09:50:26.000Z

Can you post the full stacktrace please

confuser · Answer 2 · 2015-12-24T20:18:55.000Z

24.12 10:43:00 [Server] WARN Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'pastActor_id' cannot be null

Have you made any changes to your database manually?

Llamatic · Answer 3 · 2015-12-24T15:46:21.000Z

2 different errors http://pastebin.com/cSVrP9J2

Llamatic · Answer 4 · 2015-12-25T19:52:21.000Z

op_bm_player_ban_records was the table it was having problems with so I cleared all the data inside it. Apart from that I haven't touched it.

Llamatic · Answer 5 · 2015-12-29T22:36:02.000Z

I have changed the database tables in the config and its working fine now. Sometime must of gone bad down the line lol.

Share to