During search I get Data truncation exception. I tried increasing the width of the session_id column in the jforum_search_results to 200. But it continues to give the same error even though the session id
string was 78 chars. Any ideas ???
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long fo
r column 'session_id' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1067)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at net.jforum.dao.generic.GenericSearchDAO.selectTopicData(GenericSearch
DAO.java:235)
at net.jforum.dao.generic.GenericSearchDAO.topicsByKeyword(GenericSearch
DAO.java:225)
at net.jforum.dao.generic.GenericSearchDAO.search(GenericSearchDAO.java:
82)
at net.jforum.view.forum.SearchAction.search(SearchAction.java:187)
[originally posted on jforum.net by ppk]