Page 1 of 1

Openemm 6.0.1: Error in MySQL-Statement?

Posted: Sat Mar 27, 2010 8:09 am
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

Posted: Wed Mar 31, 2010 11:28 am
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.