OpenEMM Support

[nelson]

I get this "A general error occurred. Please check your input." in CM templates: New CM template - on the "Assign to mailing" tab. You cannot see any of the mailings to assign the template to (they do exist!)

stdout.log shows a nullpointer & sql errors:

You can see the SQL is malformed.. I am running the latest version..

2010-03-12 16:02:02,229: ERROR [resin-tcp-connection-*:8080-25] org.agnitas - Error while save text versionorg.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT mailing_id FROM cm_mailing_bind_tbl INNER JOIN cm_content_module_tbl module ON (module.id = content_module_id) WHERE mailing_id IN ) AND company_id=1]; nested exception is 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 ') AND company_id=1' at line 1
org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
org.apache.axis.message.SOAPFaultBuilder.endElement(SOAPFaultBuilder.java:129)
org.apache.axis.encoding.DeserializationContext.endElement(DeserializationContext.java:1087)
com.caucho.xml.XmlParser.popNode(XmlParser.java:969)
com.caucho.xml.XmlParser.closeTag(XmlParser.java:856)
com.caucho.xml.XmlParser.parseNode(XmlParser.java:360)
com.caucho.xml.XmlParser.parseInt(XmlParser.java:242)
com.caucho.xml.AbstractParser.parse(AbstractParser.java:633)
javax.xml.parsers.SAXParser.parse(SAXParser.java:395)
org.apache.axis.encoding.DeserializationContext.parse(DeserializationContext.java:227)
org.apache.axis.SOAPPart.getAsSOAPEnvelope(SOAPPart.java:696)
org.apache.axis.Message.getSOAPEnvelope(Message.java:435)
org.apache.axis.handlers.soap.MustUnderstandChecker.invoke(MustUnderstandChecker.java:62)
org.apache.axis.client.AxisClient.invoke(AxisClient.java:206)
org.apache.axis.client.Call.invokeEngine(Call.java:2784)
org.apache.axis.client.Call.invoke(Call.java:2767)
org.apache.axis.client.Call.invoke(Call.java:2443)
org.apache.axis.client.Call.invoke(Call.java:2366)
org.apache.axis.client.Call.invoke(Call.java:1812)
org.agnitas.cms.webservices.generated.RemoteCMTemplateManagerSoapBindingStub.getMailingWithCmsContent(RemoteCMTemplateManagerSoapBindingStub.java:1029)

2010-03-12 16:02:02,229: ERROR [resin-tcp-connection-*:8080-25] org.agnitas - getMailingsList: java.lang.NullPointerException
org.agnitas.cms.dao.impl.CmsMailingDaoImpl.getMailingsWithNoClassicTemplate(CmsMailingDaoImpl.java:94)
org.agnitas.cms.web.CMTemplateAction.getMailingsList(CMTemplateAction.java:513)
org.agnitas.cms.web.CMTemplateAction.execute(CMTemplateAction.java:229)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:5
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:115)
javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)

Can someone help please..

Thanks

Barry