"EMM Fehler" email error

[CPWork]

Hi, I'm just about to start sending my first mailing! and I start recieving automated emails from openemm software (nice feature btw).

Can anyone enlighten me a to what the error is saying and what i need to do to fix?

From: info@agnitas.de
Date: 4 October 2011 11:20:14
To: openemm.mail.error@mydomain.com
Subject: EMM Fehler
sql: 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')='201110' AND bind.mailinglist_id=3 AND ((( lower(cust.language) = lower('FR'))) 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
Exception: 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 ' at line 1
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571)
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1464)
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
org.agnitas.taglib.ShowSubscriberStat.doStartTag(ShowSubscriberStat.java:161)
org.apache.jsp.stats.recipient.stats_002drecipient_002ddisplay_jsp._jspService(stats_002drecipient_002ddisplay_jsp.java:908)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

I'm using the 2011 VMX created by openemm team, no software component has been updated or changed by me (tomcat, java etc.)

Any ideas?
CPW

[maschoff]

When you "compress" the stacktrace it basically says

check the syntax to use near 'INTERVAL -1.0 HOURS), '%Y%m%d')'

Maybe you should have a look at the interval expression you used and check if it works with MySQL.

[CPWork]

When you "compress" the stacktrace it basically says

check the syntax to use near 'INTERVAL -1.0 HOURS), '%Y%m%d')'

Maybe you should have a look at the interval expression you used and check if it works with MySQL.

Hi, thanks for the response, but when you say <I> used... I can't write SQL in openemm, can I? I don't use mysql at the command line, i only use the web front end.

within the web interface how do I influence the interval -1 sql sytnax?

CPW

[maschoff]

I thought that you created a target group using this expression. You did not? Which version of MySQL do you use?

[CPWork]

I thought that you created a target group using this expression. You did not? Which version of MySQL do you use?

I wasn't aware that you could do this!

no, I'm simply using the web interface and using all the standard features.

I'm using the v2011 VMX that you/the OpenEMM team created. sorry, I don't know which MySql version is on it, but it's the one you guys put on it. If it help I can see if I can find that out. Can you give me the linux command to do that?

[maschoff]

If you use the VMX version I know your MySQL version. We will try to find the source of this stacktrace.

[maschoff]

Ok, some more questions to track down the source of this error message:

1. Is the mailing generating this error message a normal mailing or an action based mailing? If so, how is the action based mailing triggered?
2. What did you do exactly which triggered sending of these emails?