Error when karma voting

[Migrated From Jforum.net]

Erm, I just tried to give a karma vote to Rafael in the server root/context discussion (don't be afraid, it was a 5 ;)), and this is what I saw:

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

Data truncation: Data truncated for column 'user_karma' at row 1

[originally posted on jforum.net by anoko]

[Migrated From Jforum.net]

rafeel .. i have the same problem... i am not able to give karma more than twice to a single person on different posts
[originally posted on jforum.net by incricket]

[Migrated From Jforum.net]

idem

Here is the trace :

01:24:15,250 ERROR [ExceptionWriter ] java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at net.jforum.Command.process(Command.java:116)
at net.jforum.JForum.service(JForum.java:182)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'user_karma' at row 1
at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)
at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3410)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1804)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java: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 net.jforum.dao.generic.GenericKarmaDAO.updateUserKarma(GenericKarmaDAO.java:140)
at net.jforum.dao.generic.GenericKarmaDAO.addKarma(GenericKarmaDAO.java:82)
at net.jforum.view.forum.KarmaAction.insert(KarmaAction.java:116)
... 24 more

[originally posted on jforum.net by snaps-herve]

[Migrated From Jforum.net]

On MySQL, when you change column type from DECIMAL(10,2) to DOUBLE it works.

I have not tested with other database.

The problem is when you have more than 2 digits at the end of the rate score. It is better to define a double colonn as DOUBLE.
[originally posted on jforum.net by snaps-herve]

[Migrated From Jforum.net]

OK, I'll change the column spec.

Rafael
[originally posted on jforum.net by Rafael Steil]