Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-1326

Ensure non-empty WHERE clause in all SQLs used in Temp Handler

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.3.0-B1
    • Component/s: Database
    • Labels:
      None
    • Change Log Group:
      Fixed
    • Change Log Message:
      Attempt to edit a category resulted in an SQL error.
    • Story Points:
      1
    • Sprint:
      In-Portal's 2nd Sprint
    • Copy Issue Key:
    • Patch Instructions:

      Patches must be submitted through Phabricator.

      Description

      TempHandler always applies constrain WHERE clause without looking if there is at least WHERE clause to attach condition to.

      Need to fix 2 database queries, that don't have WHERE clause yet and are causing SQL error.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Alex
                Reviewer:
                Dmitry Andrejev [Intechnic]
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: