OpenEMM Technical Support Forum

I keep getting the above error on a brand new installation (everything else is working fine).

I looked in the catalina.out log file and this is the only error I could find:
PANIC : error configuring SimpleLog4JLogSystem : java.io.FileNotFoundException: /home/emm/var/log/velocity.log (No such file or directory)
log4j:WARN No appenders could be found for logger (org.apache.velocity.runtime.log.SimpleLog4JLogSystem).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.

I've installed OpenEMM before without any problems.

Can anyone help? I'm not a developer so please be specific. Thanks!

The previous error in the log file I posted has been corrected.

These are the fatal errors I'm getting:
2011-12-24 16:37:05,161: ERROR [http-8080-1] org.agnitas - doStartTag: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERVAL 1.0 HOURS), '%Y%m%d'), bind.user_status, count(bind.customer_id) from c' at line 1

2011-12-24 16:37:05,161: ERROR [http-8080-1] org.agnitas - Query: select date_format(date_add(bind.change_date INTERVAL 1.0 HOURS), '%Y%m%d'), bind.user_status, count(bind.customer_id) from customer_1_binding_tbl bind, customer_1_tbl cust WHERE bind.mediatype=0 AND date_format(date_add(bind.change_date INTERVAL 1.0 HOURS), '%Y%m')='201112' AND ((( lower(cust.title) = lower('DDS'))) AND cust.customer_id=bind.customer_id) GROUP BY date_format(date_add(bind.change_date INTERVAL 1.0 HOURS), '%Y%m%d'), bind.user_status

This error is even more bizarre as I have one very large list (100+/csv), and it works perfectly.

I am trying to use others that I export from Filemaker Pro as CSVs and they fail. The columns/fields are identical.

This has a totally stuck . . .