When I import recipients with a .csv i get an mysql-syntax-error. In the .csv there are singlequotes (') in the names of the recipients. It seems, that these quotes are causing the problem.
The strange thing is, that on the official demo-account of openemm, the import works...
The database was adopted from an older version of openemm
Here my Specs:
Openemm-Version is 6.0.1
Bugfixes 1-4 applied
The Test-CSV:
http://www.file-upload.net/download-241 ... t.csv.html
Output of openemm.log:
Code: Select all
2010-04-07 14:51:29,407: INFO [resin-tcp-connection-*:8080-11] org.agnitas - NewImportWizard action: 3
2010-04-07 14:51:29,407: INFO [resin-tcp-connection-*:8080-11] org.agnitas - NewImportWizard action: 3
2010-04-07 14:51:29,415: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,418: WARN [resin-tcp-connection-*:8080-11] org.apache.commons.validator.ValidatorResources - Overriding default FormSet definition.
2010-04-07 14:51:29,418: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,422: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,425: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,429: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,454: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,454: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,455: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,455: INFO [resin-tcp-connection-*:8080-11] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:29,523: ERROR [resin-tcp-connection-*:8080-11] org.agnitas - execute: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [UPDATE customer_1_tbl SET mailtype=1, firstname='Gudrun', lastname='Rossi Dall'O', email='gudrun.rossi@hispeed.ch' WHERE email='gudrun.rossi@hispeed.ch']; nested exception is java.sql.BatchUpdateException: 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 'O', email='gudrun.rossi@hispeed.ch' WHERE email='gudrun.rossi@hispeed.ch'' at line 1
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:294)
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:451)
org.agnitas.dao.impl.ImportRecipientsDaoImpl.updateExistRecipients(ImportRecipientsDaoImpl.java:789)
org.agnitas.service.impl.NewImportWizardServiceImpl.doValidate(NewImportWizardServiceImpl.java:296)
org.agnitas.service.impl.NewImportWizardServiceImpl.doParse(NewImportWizardServiceImpl.java:190)
org.agnitas.web.NewImportWizardAction.execute(NewImportWizardAction.java:174)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
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.doPost(ActionServlet.java:462)
javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
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)
2010-04-07 14:51:29,523: ERROR [resin-tcp-connection-*:8080-11] org.agnitas - execute: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [UPDATE customer_1_tbl SET mailtype=1, firstname='Gudrun', lastname='Rossi Dall'O', email='gudrun.rossi@hispeed.ch' WHERE email='gudrun.rossi@hispeed.ch']; nested exception is java.sql.BatchUpdateException: 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 'O', email='gudrun.rossi@hispeed.ch' WHERE email='gudrun.rossi@hispeed.ch'' at line 1
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:294)
org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:451)
org.agnitas.dao.impl.ImportRecipientsDaoImpl.updateExistRecipients(ImportRecipientsDaoImpl.java:789)
org.agnitas.service.impl.NewImportWizardServiceImpl.doValidate(NewImportWizardServiceImpl.java:296)
org.agnitas.service.impl.NewImportWizardServiceImpl.doParse(NewImportWizardServiceImpl.java:190)
org.agnitas.web.NewImportWizardAction.execute(NewImportWizardAction.java:174)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
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.doPost(ActionServlet.java:462)
javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
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)
2010-04-07 14:51:55,995: INFO [resin-tcp-connection-*:8080-3] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:51:55,997: INFO [resin-tcp-connection-*:8080-3] org.agnitas - Onepixel: cust: 12153 mi: 137 ci: 1
2010-04-07 14:51:55,997: INFO [resin-tcp-connection-*:8080-3] org.agnitas - Onepixel: cust: 12153 mi: 137 ci: 1
2010-04-07 14:51:56,073: INFO [resin-tcp-connection-*:8080-15] org.agnitas - Onepixel: cust: 12153 mi: 137 ci: 1
2010-04-07 14:51:56,073: INFO [resin-tcp-connection-*:8080-15] org.agnitas - Onepixel: cust: 12153 mi: 137 ci: 1
2010-04-07 14:53:43,906: INFO [resin-tcp-connection-*:8080-13] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:53:43,907: INFO [resin-tcp-connection-*:8080-13] org.agnitas - Onepixel: cust: 12133 mi: 137 ci: 1
2010-04-07 14:53:43,907: INFO [resin-tcp-connection-*:8080-13] org.agnitas - Onepixel: cust: 12133 mi: 137 ci: 1
2010-04-07 14:56:49,703: INFO [resin-tcp-connection-*:8080-21] org.agnitas - Onepixel: cust: 13334 mi: 137 ci: 1
2010-04-07 14:56:49,703: INFO [resin-tcp-connection-*:8080-21] org.agnitas - Onepixel: cust: 13334 mi: 137 ci: 1
2010-04-07 14:57:24,256: INFO [resin-tcp-connection-*:8080-17] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-04-07 14:57:24,258: INFO [resin-tcp-connection-*:8080-17] org.agnitas - Onepixel: cust: 12407 mi: 137 ci: 1
2010-04-07 14:57:24,258: INFO [resin-tcp-connection-*:8080-17] org.agnitas - Onepixel: cust: 12407 mi: 137 ci: 1