Error Reported / bounces not working

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

tpalmieri
Posts: 11
Joined: Tue Dec 13, 2011 1:16 pm

Error Reported / bounces not working

Post by tpalmieri »

I'm doing a mailing now which appears to be sending fine, although I'm getting zero bounces (and my list isn't that good!).

This is the error OpenEMM is emailing me (the mailing keeps progressing as I get the error emails):
sql: select date_format(date_add(bind.change_date INTERVAL -5.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 -5.0 HOURS), '%Y%m')='201201' AND ((( lower(cust.state) = lower('PA') AND lower(cust.zip) NOT LIKE lower('19%'))) AND cust.customer_id=bind.customer_id) GROUP BY date_format(date_add(bind.change_date INTERVAL -5.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 -5.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 bolded the section that seems relevant, but that's as far as my understanding goes.

Can anyone help??