[Opensourcecrm-keyfactoruse] keyfactor and mysql

[Nouguier <ol...@ak...>]

Hi,
We try to yse keyfactor with MySQL database server. When a poor spammed
boy click over the clickthru we obtain an Exception:
        java.lang.NumberFormatException in KFRedir.log,
It occurs when  CMSTrackerServlet is calling getRedirectURL().

When executing the query:
        SELECT URL, EXPIRES, STOPDATE FROM clickthru WHERE ID = 1014.

In mysql:cms, the STOPDATE field of the table clickthru is a "date" and
in the servlet the call:
    Timestamp stopDate = rs.getTimestamp(3); // LINE 528 of
CMSTrackerServlet.java
throws the java.lang.NumberFormatException.

    Altering the STOPDATE from "date" to sql type "datetime" make
clickthru to work fine.

Did I miss something in the install/configation or is it a bug.

Bye.