Resolution: No Longer Reproducible
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)
- Discovered while testing
LPS-45541 Wrong order on Available Translations for Dynamic Structures (DDM)
- is caused by
LPS-62717 Publishing a web content after deleting a repeatable-field value resets its content instead of removing it
- is fixed by
LPS-60301 In a multi-lingual Web content, localizable images are not saved in a translation