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
1 Solution
Accepted Solutions
