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

Unknown column 'sort_column_1_null' in 'order clause'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 5.3.7, 5.4.5
    • Fix Version/s: Customer request, 5.3.8, 5.4.6
    • Component/s: None
    • Labels:
      None

      Description

      I got this DBALException on a quiet harmless query. Tracking this down a bit, lead me to a bad implementation with a poorly implemented workaround.

      The issue is most probalby caused by a count query with 2 order statements, follwed by a select query (without count) and only 1 order statement.

      In short, the problem is, that the sortClauseConverter is singleton and not properly rested between different queries. In the SortClauseConverter class there is a hint, where the bug comes from and a workaround, reseting the converter, after calling applyOrderBy(). But in count this method is never called and the SortClauseConverter is never reseted.

      I suggest implementing a reset() method on the SortClauseConverter and call it from DoctrineDatabase before each Operation.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              kuborgh-hgiesenow Hannes Giesenow
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: