-
Bug
-
Resolution: Fixed
-
Major
-
None
-
None
Caused by: org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException: Unable to empty the subscribers table. at org.ametys.plugins.newsletter.daos.SubscribersDAO.empty(SubscribersDAO.java:177) at org.ametys.plugins.newsletter.subscribe.ImportSubscribersAction.act(ImportSubscribersAction.java:102) at org.apache.cocoon.components.treeprocessor.sitemap.ActTypeNode.invoke(ActTypeNode.java:125) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:47) at org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:108) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:69) at org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:143) at org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:69) at org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:93) at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:235) at org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:177) at org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:254) at org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(MountNode.java:118) ... 46 more Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in org/ametys/plugins/newsletter/daos/subscribers.xml. --- The error occurred while executing update. --- Check the DELETE FROM Newsletter_Subscribers WHERE Category = ? AND Site_Name = ?; . --- Check the SQL Statement (preparation failed). --- Cause: java.sql.SQLSyntaxErrorException: Syntax error: Encountered ";" at line 1, column 85. at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.update(SqlMapExecutorDelegate.java:505) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.delete(SqlMapExecutorDelegate.java:528) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.delete(SqlMapSessionImpl.java:98) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.delete(SqlMapClientImpl.java:75) at org.ametys.plugins.newsletter.daos.SubscribersDAO.empty(SubscribersDAO.java:173) ... 58 more Caused by: java.sql.SQLSyntaxErrorException: Syntax error: Encountered ";" at line 1, column 85. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
And message for user is empty.