Uploaded image for project: 'Forms'
  1. Forms
  2. FORMS-242

Unable to delete entries

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.9.0, 2.0.0
    • None
    • None
    • None

      I create a form in a content with the default workflow.

      In my configuration, I choose a Derby database for storing form's workflow.

      I can not delete any entries

      Caused by: org.ametys.plugins.forms.FormsException: Error while getting workflow ids from the table Forms_form_04511898091233557
	at org.ametys.plugins.forms.table.FormTableManager.getWorkflowIds(FormTableManager.java:1304)
	at org.ametys.plugins.forms.table.FormTableManager.deleteEntry(FormTableManager.java:1404)
	... 102 more
Caused by: java.sql.SQLSyntaxErrorException: Column 'WORKFLOWID' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'WORKFLOWID' is not a column in the target table.

        1. capture-for-jira-screenshot-20160704-140600-989.png
          capture-for-jira-screenshot-20160704-140600-989.png
          154 kB
        2. FORMS_242.patch
          0.9 kB

          [FORMS-242] Unable to delete entries

          Laurence Aumeunier made changes -
          Status Original: Resolved [ 5 ] New: Closed [ 6 ]
          Laurence Aumeunier made changes -
          Resolution New: Fixed [ 1 ]
          Status Original: Patch available [ 10005 ] New: Resolved [ 5 ]
          Quentin Glinel-Mortreuil (Inactive) made changes -
          Status Original: Reopened [ 4 ] New: Patch available [ 10005 ]
          Quentin Glinel-Mortreuil (Inactive) made changes -
          Assignee Original: Quentin Glinel-Mortreuil [ quentin ] New: Laurence Aumeunier [ laurence ]
          Resolution Original: Fixed [ 1 ]
          Status Original: Resolved [ 5 ] New: Reopened [ 4 ]
          Quentin Glinel-Mortreuil (Inactive) made changes -
          Attachment New: FORMS_242.patch [ 17871 ]
          Quentin Glinel-Mortreuil (Inactive) made changes -
          Fix Version/s New: 1.9.0 [ 12914 ]
          Quentin Glinel-Mortreuil (Inactive) made changes -
          Resolution New: Fixed [ 1 ]
          Status Original: Open [ 1 ] New: Resolved [ 5 ]
          Laurence Aumeunier made changes -
          Attachment New: capture-for-jira-screenshot-20160704-140600-989.png [ 17866 ]
          Laurence Aumeunier created issue -

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

              Created:
              Updated:
              Resolved: