Uploaded image for project: 'Newsletter'
  1. Newsletter
  2. NEWSLETTER-126

Error while importing subscribers with deletion of existing subscribers

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.4.0
    • 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.

        1. Capture.PNG
          15 kB
          Laurence Aumeunier

            Unassigned Unassigned
            laurence Laurence Aumeunier
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: