OpenEMM Technical Support Forum

Posted: **Tue Oct 04, 2011 11:44 am**

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

Posted: **Wed Oct 05, 2011 1:49 pm**

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.

Posted: **Wed Oct 05, 2011 4:51 pm**

maschoff wrote: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

Posted: **Wed Oct 05, 2011 4:57 pm**

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

Posted: **Wed Oct 05, 2011 5:09 pm**

maschoff wrote: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?

Posted: **Wed Oct 05, 2011 5:16 pm**

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

Posted: **Sun Oct 30, 2011 8:44 pm**

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?

OpenEMM Technical Support Forum

"EMM Fehler" email error

"EMM Fehler" email error

Re: "EMM Fehler" email error

Re: "EMM Fehler" email error

Re: "EMM Fehler" email error

Re: "EMM Fehler" email error

Re: "EMM Fehler" email error

Re: "EMM Fehler" email error