Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-19491

incorrect status parameter for collaboration fetch functions can trigger fatal error.

    Details

    • Type: Improvement Improvement
    • Status: Confirmed
    • Priority: Medium Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Customer request
    • Component/s: Misc
    • Labels:
      None
    • Environment:

      eZ Publish 4.6

      Description

      Using an incorrect 'status' parameter for certain collaboration fetch functions will cause a fatal error.

      The expected status is parameter is an array() of possible values, but using true() will generate an sql query containing the following:

        WHERE ezcollab_item.status IN ( ) AND
      

      As this query is not valid, a fatal error will occur.

      Steps to reproduce:

      Create and use a fetch function like the following:

        fetch("collaboration","item_count", hash("status", true()) )
      

        Activity

        João Inácio created issue -
        Joao Inacio (Inactive) made changes -
        Field Original Value New Value
        Description Using an incorrect 'status' parameter for certain collaboration fetch functions will cause a fatal error.

        The expected status is parameter is an array() of possible values, but using true() will generate an sql query containing the following:
          "WHERE ezcollab_item.status IN ( ) AND"

        As this query is not valid, a fatal error will occur.
        h5. Steps to reproduce
        Create and use a fetch function like the following:
          fetch("collaboration","item_count", hash("status", true()) )



        Using an incorrect 'status' parameter for certain collaboration fetch functions will cause a fatal error.

        The expected status is parameter is an array() of possible values, but using true() will generate an sql query containing the following:
        {code}
          WHERE ezcollab_item.status IN ( ) AND
        {code}

        As this query is not valid, a fatal error will occur.

        h5.Steps to reproduce:
        Create and use a fetch function like the following:
        {code}
          fetch("collaboration","item_count", hash("status", true()) )
        {code}
        Joao Inacio (Inactive) made changes -
        Fix Version/s Customer request [ 11018 ]
        Joao Inacio (Inactive) made changes -
        Link This issue is duplicated by EZPNEXT-681 [ EZPNEXT-681 ]
        Joao Inacio (Inactive) made changes -
        Status Open [ 1 ] Backlog [ 10000 ]
        André Rømcke made changes -
        Workflow eZ Community Workflow [ 21465 ] eZ Engineering Scrumban Workflow [ 35750 ]
        André Rømcke made changes -
        Status Backlog [ 10000 ] Confirmed [ 10037 ]
        André Rømcke made changes -
        Workflow eZ Engineering Scrumban Workflow [ 35750 ] EZ* Development Workflow [ 69845 ]
        Alex Schuster made changes -
        Workflow EZ* Development Workflow [ 69845 ] EZEE Development Workflow [ 108248 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Backlog Backlog
        126d 22h 41m 1 joao.inacio@ez.no 26/Oct/12 6:28 PM
        Backlog Backlog Confirmed Confirmed
        278d 3h 29m 1 André Rømcke 31/Jul/13 9:57 PM

          People

          • Assignee:
            unknown
            Reporter:
            João Inácio
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: