[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: Text File FORM-10-error.log    
Issue Links:
Problem/Incident
Template:
Acceptance criteria:
Empty
Team: Services

 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.
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)



 Comments   
Comment by Raphael Falvo [ 23/May/23 ]

Will be released in 1.2.2

 

Generated at Mon Feb 12 01:57:59 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.