Openemm 6.0.1: Error in MySQL-Statement?

Use this forum for questions regarding adoption and functionality of OpenEMM

Moderator: moderator

medical
Posts: 4
Joined: Fri Aug 24, 2007 10:16 am

Openemm 6.0.1: Error in MySQL-Statement?

Post by medical »

Hi,
I installed OpenEmm 6.0.1 like on openemm.org described under windows 2003.

Mails are generated but not processed and not send.
in var/log/core_stderr.log is found:
WARNING/emmtag/(1/6/14/32): Unknown column referenced for agnDB: ...
triggerMailing: java.lang.Exception: Error during main query or mail generation: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 'cust.mailtype,cust.email FROM customer_1_tbl cust, TMP_CRT_A_14_32_TBL bind WHER' at line 1
Is this a Bug or do I have to make some adjustments.
Thanks & Greetings
maschoff
Site Admin
Posts: 2628
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Post by maschoff »

From the error message it looks like you use an agn tag in your mail which references a custom database field which does not exist.
OpenEMM Maintainer
Post Reply