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

    • Type: Bug
    • Status: Verified
    • Resolution: Unresolved
    • Affects Version/s: 7.0.0 CE GA1, 7.0.X EE
    • Fix Version/s: None
    • Component/s: Util, Util > Shopping
    • Labels:
      None
    • Story Points:
      1.25
    • Fix Priority:
      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

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Days since last comment:
                3 years, 8 weeks, 5 days ago

                Packages

                Version Package