[FORM-10] Form chooser is throwing an error Created: 09/May/23 Updated: 23/May/23 Resolved: 23/May/23 |
|
| Status: | Closed |
| Project: | FORM |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.2.2 |
| Type: | Bug | Priority: | Neutral |
| Reporter: | Raphael Falvo | Assignee: | Raphael Falvo |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||
| Issue Links: |
|
||||
| Template: |
|
||||
| Acceptance criteria: |
Empty
|
||||
| Team: | |||||
| Description |
|
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.
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) |
| Comments |
| Comment by Raphael Falvo [ 23/May/23 ] |
|
Will be released in 1.2.2
|