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

Cannot add new translation to web content with image over 1MB

    Details

    • Type: Regression Bug
    • Status: Closed
    • Resolution: No Longer Reproducible
    • Affects Version/s: 6.2.X EE
    • Fix Version/s: 6.2.X EE
    • Labels:
      None

      Description

      When editing published web content that includes a large image (when based on a web content structure/template with an image field), a new translation cannot be added. It seems like any image over 1 MB will cause this to occur (attaching an image that reproduced the issue during testing).

      This was fixed by LPS-62717, and fixed by LPS-60301.

      Steps to reproduce:
      1. Navigate to Web Content admin in the Control Panel
      2. Create a new Web Content structure with at least an Image field
      3. Create a new Web Content template based on the structure
      4. Create and publish a new Web Content article based on the structure, uploading an image over 1 MB for the Image field
      5. Edit the created article, and click to "Add Translation" (and choose any language not already added)
      6. Save the new translation

      Expected result: the new translation will be created and added to the article draft with no errors
      Actual result: "Web Content is temporarily unavailable" error message appears, along with a stack trace in the console.

      Stack trace is as follows:

      18:51:00,552 ERROR [http-bio-8080-exec-8][JDBCExceptionReporter:82] Packet for query is too large (3060719 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
      18:51:00,562 ERROR [http-bio-8080-exec-8][render_portlet_jsp:132] null
      com.mysql.jdbc.PacketTooBigException: Packet for query is too large (3060719 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
              at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3798)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2484)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
              at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
              at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:2465)
              at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
              at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
              at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
              at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
              at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
              at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
              at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
              at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
              at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:113)
              at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:104)

        Attachments

        1. fixed.png
          fixed.png
          144 kB
        2. liferay-logo-large.png
          liferay-logo-large.png
          1.46 MB

          Issue Links

            Activity

              People

              • Assignee:
                hong.zhao Hong Zhao
                Reporter:
                alec.shay Alec Shay
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 2 weeks, 6 days ago

                  Packages

                  Version Package
                  6.2.X EE