Openfire Enterprise

Fix exception when storing big workgroup forms

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 3.4.4, 3.4.5
  • Fix Version/s: 3.5.0
  • Component/s: Fastpath
  • Labels:
    None
  • Environment:

    MySQL only

  • Acceptance Test - Add?:
    Yes
  • Acceptance Test - Entry:
    Hide

    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

    Show
    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

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)

Activity

There are no comments yet on this issue.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: