OpenEMM Technical Support Forum

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??