Uploaded image for project: 'eZ Platform Enterprise Edition'
  1. eZ Platform Enterprise Edition
  2. EZEE-3196

Dashboard with configured Workflow crashes on PostgreSQL

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 3.1.0-rc1, 3.0.6
    • 3.0.5
    • Workflow
    • None

    Description

      Steps to reproduce:

      1. Install clean eZ Platform Enterprise Edition using PostgreSQL database
      2. Configure Workflow like in the doc
      3. Go to Dashboard and observe the following or similar error
      An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT w.id, w.content_id, w.version_no, w.workflow_name, w.initial_owner_id, w.start_date FROM ezeditorialworkflow_workflows w WHERE (NOT (w.id IN (SELECT wf.id FROM ezeditorialworkflow_markings m LEFT JOIN ezeditorialworkflow_workflows wf ON m.workflow_id = wf.id WHERE (wf.id = 'custom_workflow') AND (m.name IN ('done'))))) AND (NOT (w.id IN (SELECT wf.id FROM ezeditorialworkflow_markings m LEFT JOIN ezeditorialworkflow_workflows wf ON m.workflow_id = wf.id WHERE ((wf.workflow_name = 'quick_review') AND (m.name IN ('draft'))) OR ((wf.workflow_name = 'custom_workflow') AND (m.name IN ('draft'))))))':
      
      SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "custom_workflow"
      LINE 1: ...kflows wf ON m.workflow_id = wf.id WHERE (wf.id = 'custom_wo...
      ^").
      

      Expected result
      Dashboard is shown

      Attachments

        Activity

          People

            Unassigned Unassigned
            andrew.longosz@ibexa.co Andrew Longosz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: