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


    • Regression Bug


      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)


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

        Issue Links



              hong.zhao Hong Zhao (Inactive)
              alec.shay Alec Shay
              Marta Elicegui Marta Elicegui
              0 Vote for this issue
              1 Start watching this issue


                6 years, 31 weeks, 5 days ago


                  Version Package
                  6.2.X EE