- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error while accessing database
Hello,
i'm experiencing the following problem.
Table:
Table template:
Detailed error message:
Error while accessing database:
Error code: 1364, state: HY000
FSVersion=5.2.2011.77135#5868;JDK=1.8.0_171 64bit Oracle Corporation;OS=Windows 10 10.0 amd64;Date=23.07.2018 16:15:10
de.espirit.or.ORException: Error code: 1364, state: HY000
at de.espirit.or.impl.TemporalCommandHandler.update(TemporalCommandHandler.java:614)
at de.espirit.or.impl.TemporalCommandHandler.handle(TemporalCommandHandler.java:259)
at de.espirit.or.impl.UpdateCommand.accept(UpdateCommand.java:54)
at de.espirit.or.impl.AbstractSessionHandler.commit(AbstractSessionHandler.java:787)
at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.commit(ContentManagerImpl.java:1446)
at de.espirit.firstspirit.content.ContentManagerImpl.commit(ContentManagerImpl.java:763)
at sun.reflect.GeneratedMethodAccessor3402.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:67)
at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:139)
at de.espirit.firstspirit.server.io.handler.ManagerCall.handle(ManagerCall.java:85)
at de.espirit.firstspirit.server.io.MessageWorker.run(MessageWorker.java:49)
at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:625)
at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:590)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:436)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at de.espirit.common.util.SuspendableThread.run(SuspendableThread.java:56)
Caused by: java.sql.SQLException: Field 'info' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
at com.mysql.jdbc.UpdatableResultSet.insertRow(UpdatableResultSet.java:844)
at de.espirit.or.impl.TemporalCommandHandler.insertRow(TemporalCommandHandler.java:741)
at de.espirit.or.impl.TemporalCommandHandler.insertUpdatedEntry(TemporalCommandHandler.java:566)
at de.espirit.or.impl.TemporalCommandHandler.update(TemporalCommandHandler.java:611)
at de.espirit.or.impl.TemporalCommandHandler.handle(TemporalCommandHandler.java:259)
at de.espirit.or.impl.UpdateCommand.accept(UpdateCommand.java:54)
at de.espirit.or.impl.AbstractSessionHandler.commit(AbstractSessionHandler.java:787)
at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.commit(ContentManagerImpl.java:1446)
at de.espirit.firstspirit.content.ContentManagerImpl.commit(ContentManagerImpl.java:763)
at sun.reflect.GeneratedMethodAccessor3402.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:67)
at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:139)
at de.espirit.firstspirit.server.io.handler.ManagerCall.handle(ManagerCall.java:85)
at de.espirit.firstspirit.server.io.MessageWorker.run(MessageWorker.java:49)
at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:625)
at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:590)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:436)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at de.espirit.firstspirit.client.io.ServerCaller.callManager(ServerCaller.java:502)
at de.espirit.firstspirit.io.DefaultClientHandler.callManager(DefaultClientHandler.java:58)
at de.espirit.firstspirit.client.io.RemoteManagerCaller.invoke(RemoteManagerCaller.java:53)
at com.sun.proxy.$Proxy55.commit(Unknown Source)
at de.espirit.firstspirit.store.access.templatestore.SessionHandlerImpl.commit(SessionHandlerImpl.java:122)
at de.espirit.or.impl.SessionImpl.doCommit(SessionImpl.java:248)
at de.espirit.or.impl.AbstractSession.commit(AbstractSession.java:608)
at de.espirit.or.impl.AbstractSession.commit(AbstractSession.java:597)
at de.espirit.firstspirit.access.store.contentstore.gom.list.ContentDataFactory$ContentDataConfiguration.commitContentChanges(ContentDataFactory.java:1392)
at de.espirit.firstspirit.client.access.editor.FsListEditorValueImpl.onSave(FsListEditorValueImpl.java:213)
at de.espirit.firstspirit.store.access.contentstore.DatasetImpl.callSaveHook(DatasetImpl.java:1303)
at de.espirit.firstspirit.store.access.contentstore.DatasetImpl.save(DatasetImpl.java:1257)
at de.espirit.firstspirit.store.access.contentstore.DatasetImpl.save(DatasetImpl.java:1227)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.writeToServer(AbstractGuiStoreElement.java:700)
at de.espirit.firstspirit.client.gui.tree.store.contentstore.GuiDataset.writeToServer(GuiDataset.java:303)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.store(AbstractGuiStoreElement.java:1381)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.storeAndNotify(AbstractGuiStoreElement.java:622)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.save(AbstractGuiStoreElement.java:609)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.save(AbstractGuiStoreElement.java:589)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.save(AbstractGuiStoreElement.java:580)
at de.espirit.firstspirit.ui.views.controls.IDProviderModifiable.store(IDProviderModifiable.java:180)
at de.espirit.firstspirit.ui.actions.views.SaveActionFactory$SaveAction.perform(SaveActionFactory.java:69)
at de.espirit.firstspirit.ui.actions.SynchronizedAction.perform(SynchronizedAction.java:48)
at de.espirit.firstspirit.ui.actions.swing.SwingAction.actionPerformed(SwingAction.java:150)
at de.espirit.firstspirit.client.keymap.KeyEventDispatcher.processAction(KeyEventDispatcher.java:293)
at de.espirit.firstspirit.client.keymap.KeyEventDispatcher.inInitState(KeyEventDispatcher.java:234)
at de.espirit.firstspirit.client.keymap.KeyEventDispatcher.dispatchKeyEvent(KeyEventDispatcher.java:184)
at de.espirit.firstspirit.client.AWTDispatchingEventQueue._dispatchEvent(AWTDispatchingEventQueue.java:141)
at de.espirit.firstspirit.client.AWTDispatchingEventQueue.dispatchEvent(AWTDispatchingEventQueue.java:131)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
Any ideas?
Regards,
Dragan
- Labels:
-
Developers
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
the problem is:
Caused by: java.sql.SQLException: Field 'info' doesn't have a default value
The table has an info column which can not be null.
If the column is not used anymore, it must be deleted from the table manually with an ALTER TABLE sql statement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
the problem is:
Caused by: java.sql.SQLException: Field 'info' doesn't have a default value
The table has an info column which can not be null.
If the column is not used anymore, it must be deleted from the table manually with an ALTER TABLE sql statement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello Alexander, Thank you very much. It solved my problem. Many regards, Dragan

