-
Bug
-
Resolution: Fixed
-
Neutral
-
None
-
None
-
-
Empty show more show less
Choosing a form using a form chooser from a dialog doesn't work. The chooser opens but remains blank, and the following logs appear at server side:
2023-05-09 14:45:29,699 ERROR nfo.magnolia.admincentral.AdmincentralErrorHandler: Admincentral has encountered an unhandled exception. javax.persistence.PersistenceException: Query threw SQLException:ERROR: column "details" does not exist Position: 74 Bind values:[%,%,%,%,%] Query was:select count(*) from forms t0 where t0.created_by like ? escape'|' and details like ? escape'|' and t0.modified_by like ? escape'|' and t0.title like ? escape'|' and empty like ? escape'|' at io.ebean.config.dbplatform.SqlCodeTranslator.translate(SqlCodeTranslator.java:55) ~[ebean-api-12.8.3.jar:?] at io.ebean.config.dbplatform.DatabasePlatform.translate(DatabasePlatform.java:231) ~[ebean-api-12.8.3.jar:?] at io.ebeaninternal.server.query.CQueryEngine.translate(CQueryEngine.java:145) ~[ebean-core-12.8.3.jar:?] at io.ebeaninternal.server.query.CQueryEngine.findCount(CQueryEngine.java:191) ~[ebean-core-12.8.3.jar:?] at io.ebeaninternal.server.query.DefaultOrmQueryEngine.findCount(DefaultOrmQueryEngine.java:89) ~[ebean-core-12.8.3.jar:?] at io.ebeaninternal.server.core.OrmQueryRequest.findCount(OrmQueryRequest.java:416) ~[ebean-core-12.8.3.jar:?] at io.ebeaninternal.server.core.DefaultServer.findCountWithCopy(DefaultServer.java:1273) ~[ebean-core-12.8.3.jar:?] at io.ebeaninternal.server.core.DefaultServer.findCount(DefaultServer.java:1261) ~[ebean-core-12.8.3.jar:?] at io.ebeaninternal.server.query.LimitOffsetPagedList.getTotalCount(LimitOffsetPagedList.java:108) ~[ebean-core-12.8.3.jar:?] at info.magnolia.form.service.impl.AbstractBaseServiceImpl.count(AbstractBaseServiceImpl.java:120) ~[magnolia-form-core-1.2.2-SNAPSHOT.jar:?] at info.magnolia.ui.jdbc.data.JdbcDataProvider.sizeInBackEnd(JdbcDataProvider.java:77) ~[magnolia-ui-framework-jdbc-1.1.jar:?] at com.vaadin.data.provider.AbstractBackEndDataProvider.size(AbstractBackEndDataProvider.java:66) ~[vaadin-server-8.15.2.jar:8.15.2] at com.vaadin.data.provider.DataProviderWrapper.size(DataProviderWrapper.java:85) ~[vaadin-server-8.15.2.jar:8.15.2]
Full stack trace attached.
It seems that the system is trying to count the number of forms in the system, executing a query and trying to filter on any single field defined in the form chooser definition.
As details column doesnt exist in form table, the JDBC query fails.
Full stack trace of the error is attached to the ticket.
NOTE : issue occurs only on recent version of Magnolia (was still working on Magnolia 6.2.25)
Acceptance criteria