Error while accessing database

Author: draganr
Publication Date: 7/23/2018 15:26

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