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
          154 kB
          Laurence Aumeunier
        2. FORMS_242.patch
          0.9 kB
          Quentin Glinel-Mortreuil

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

              Created:
              Updated:
              Resolved: