We're updating the issue view to help you get more done. 

Fix exception when storing big workgroup forms

Description

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'propValue' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
at sun.reflect.GeneratedMethodAccessor44.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
at $java.sql.PreparedStatement$$EnhancerByProxool$$331bec1c.executeUpdate(<generated>)
at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.insertProperty(JiveLiveProperties.java:118)
at com.jivesoftware.xmpp.workgroup.spi.JiveLiveProperties.setProperty(JiveLiveProperties.java:60)
at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveDataForm(FormManager.java:170)
at com.jivesoftware.openfire.fastpath.dataforms.FormManager.saveWorkgroupForm(FormManager.java:83)
at org.jivesoftware.openfire.plugin.enterprise.fastpath.forms.workgroup_002ddataform_jsp._jspService(workgroup_002ddataform_jsp.java:131)

Environment

MySQL only

Acceptance Test - Entry

1. Log into the admin console
2. Create a From UI with 10 fields and many options
3. Save the form and check that it was stored properly in the DB and no exception was printed to the log files

Assignee

Gaston Dombiak

Reporter

Gaston Dombiak

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure