Open rate over time not working.

christoph66 · Post by **christoph66** » Mon Jul 19, 2010 9:49 am

Hello to everybody,

if have a new installation of OpenEMM 6.1 on Suse. Everything is working fine, except that in the statistics section the "Open rate over time" does not display anything.

I checked the underlying mysql table "onepixel_log_tbl". It gets filled with accurate data from recipients opening their emails but somehow the backend has troubles to receive the data from the database.

The log file entry in openemm.log when requesting the "Open rate over time" page looks as follows:

2010-07-19 10:44:00,077: INFO [resin-tcp-connection-*:8080-29] org.agnitas - Action: 18
2010-07-19 10:44:00,083: ERROR [resin-tcp-connection-*:8080-29] org.agnitas - getOpenTimeStatFromDB ( ): java.lang.ClassCastException: [B cannot be cast to java.lang.String
2010-07-19 10:44:00,083: ERROR [resin-tcp-connection-*:8080-29] org.agnitas - SQL: select date_format(change_date, '%Y%m%d') as time, count(customer_id) as total from onepixel_log_tbl where mailing_id = ? and (change_date >= ? and change_date <= ?) group by time

I looked all over but did not find a solution. Checking logfiles and databses did not help either.

If anybody could give me a hint or a solution I would be very thankfull.

Regards from Zell am See.

Christoph

Post by **maschoff** » Mon Jul 19, 2010 3:36 pm

Which Java and MySQL version do you use? I just checked OpenEMM 6.1 at www.openemm.org (Java 6, MySQL 5.0) and the statistics worked just fine.

christoph66 · Post by **christoph66** » Mon Jul 19, 2010 3:43 pm

MySql 5.0.26, Java 6; Link statistic is working - that's the strange thing!

Post by **maschoff** » Mon Jul 19, 2010 4:03 pm

Really strange, and no hint in our log. The code is in class MailingStatImpl at line 1318, but on our machines (RedHat) it works just fine ...

christoph66 · Post by **christoph66** » Mon Jul 19, 2010 4:07 pm

I only found the ones mentioned in my first post from openemm.log. Which other log files could be of interest? Is there a possibility to turn openemm in verbose or debug mode?