Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-70035

Creating a category on Shopping-portlet throws NumberFormatException

Details

    • Bug
    • Status: Verified
    • Resolution: Unresolved
    • 7.0.0 CE GA1, 7.0.X EE
    • None
    • Util, Util > Shopping
    • None
    • 1.25
    • 3

    Description

      Liferay 7. After creating a category, such errors begins
      DB: MariaDB 10.1.20. JDBC 1.5.5

      14:40:17,820 ERROR [http-nio-8080-exec-1][JDBCExceptionReporter:234] Out of range value for column 'modelItemId' : value  is not in Long range
      14:40:17,822 ERROR [http-nio-8080-exec-1][IncludeTag:128] Current URL /web/test generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.DataException: could not execute query
      java.sql.SQLException: Out of range value for column 'modelItemId' : value  is not in Long range
      	at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.parseLong(MariaSelectResultSet.java:3300)
      	at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getLong(MariaSelectResultSet.java:1064)
      	at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getLong(MariaSelectResultSet.java:1048)
      	at org.mariadb.jdbc.internal.queryresults.resultset.MariaSelectResultSet.getLong(MariaSelectResultSet.java:1041)
      	at org.hibernate.type.descriptor.sql.BigIntTypeDescriptor$2.doExtract(BigIntTypeDescriptor.java:61)
      	at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:64)
      	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:254)
      	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:250)
      	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:235)
      	at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:505)
      	at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:451)
      	at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:348)
      	at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:639)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:829)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
      	at org.hibernate.loader.Loader.doList(Loader.java:2542)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
      	at org.hibernate.loader.Loader.list(Loader.java:2271)
      	at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
      	at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
      

      Attachments

        Activity

          People

            support-lep@liferay.com SE Support
            ild ILDAR
            Kiyoshi Lee Kiyoshi Lee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              5 years, 18 weeks, 6 days ago

              Packages

                Version Package