[Opensourcecrm-keyfactoruse] keyfactor and mysql
Brought to you by:
gak2,
opensourcecrm
|
From: Nouguier <ol...@ak...> - 2000-07-06 16:24:55
|
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.
|