Details

      Description

      1. Navigate to Site Admin > Content > Shopping

      Expected result: Shopping admin page loads

      Actual result: Page is blank

      Exception is thrown:

      18:46:09,084 ERROR [http-bio-8080-exec-22][IncludeTag:128] Current URL /group/guest/~/control_panel/manage?p_p_id=197_WAR_shoppingweb&p_p_lifecycle=0&p_p_state=maximized generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      org.hsqldb.HsqlException: incompatible data types in combination
      	at org.hsqldb.error.Error.error(Error.java:136)
      	at org.hsqldb.error.Error.error(Error.java:106)
      	at org.hsqldb.types.CharacterType.getAggregateType(CharacterType.java:289)
      	at org.hsqldb.types.Type.getAggregateType(Type.java:1129)
      	at org.hsqldb.QuerySpecification.resolveTypesPartOne(QuerySpecification.java:357)
      	at org.hsqldb.QueryExpression.resolveTypesPartOne(QueryExpression.java:434)
      	at org.hsqldb.QueryExpression.resolve(QueryExpression.java:217)
      	at org.hsqldb.ParserDQL.compileCursorSpecification(ParserDQL.java:6261)
      	at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:147)
      	at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:64)
      	at org.hsqldb.Session.compileStatement(Session.java:933)
      	at org.hsqldb.StatementManager.compile(StatementManager.java:375)
      	at org.hsqldb.Session.execute(Session.java:1037)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(JDBCPreparedStatement.java:3885)
      	at org.hsqldb.jdbc.JDBCConnection.prepareStatement(JDBCConnection.java:641)
      	at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:310)
      	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
      	at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
      	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
      	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
      
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jason.pince Jason Pince
                Reporter:
                michael.bradford Michael Bradford (Inactive)
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  4 years, 33 weeks, 4 days ago

                  Packages

                  Version Package