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

indexcontent.php cronjob pgsql columns must appear in group by

    Details

      Description

      In indexcontent.php sql queries that use group by do not include all columns in select.

        Issue Links

          Activity

          Douglas Hammond created issue -
          Hide
          Yannick Roger (Inactive) added a comment - - edited
          Show
          Yannick Roger (Inactive) added a comment - - edited PR by wizhippo: https://github.com/ezsystems/ezpublish-legacy/pull/1130
          Yannick Roger (Inactive) made changes -
          Field Original Value New Value
          Remote Link This issue links to "PR (Web Link)" [ 14605 ]
          Show
          Yannick Roger (Inactive) added a comment - Fixed in master: https://github.com/ezsystems/ezpublish-legacy/commit/8d4e3438d0e70d159a939d1813244424dd206361
          Yannick Roger (Inactive) made changes -
          Status Open [ 1 ] Confirmed [ 10037 ]
          Yannick Roger (Inactive) made changes -
          Status Confirmed [ 10037 ] InputQ [ 10001 ]
          Yannick Roger (Inactive) made changes -
          Status InputQ [ 10001 ] Development [ 3 ]
          Assignee Yannick Roger [ yannick.roger@ez.no ]
          Hide
          Yannick Roger (Inactive) added a comment -

          Has been introduced by: EZP-23681

          Show
          Yannick Roger (Inactive) added a comment - Has been introduced by: EZP-23681
          Yannick Roger (Inactive) made changes -
          Link This issue relates to EZP-23681 [ EZP-23681 ]
          Yannick Roger (Inactive) made changes -
          Affects Version/s 5.4.1 [ 13886 ]
          Affects Version/s 5.3.4 [ 13879 ]
          Affects Version/s 5.2 [ 12582 ]
          Affects Version/s 5.1 [ 11280 ]
          Affects Version/s 5.0 [ 10300 ]
          Affects Version/s 4.7.0 [ 11010 ]
          Affects Version/s 4.6.0 [ 11005 ]
          Affects Version/s 4.5.0 [ 11000 ]
          Affects Version/s 2015.01 [ 13680 ]
          Yannick Roger (Inactive) made changes -
          Status Development [ 3 ] Documentation done [ 10011 ]
          Fix Version/s 2015.01 [ 13680 ]
          Fix Version/s 6.0.0 [ 13181 ]
          Pedro Resende (Inactive) made changes -
          Status Documentation done [ 10011 ] QA [ 10008 ]
          Assignee Yannick Roger [ yannick.roger@ez.no ] Pedro Resende [ pedro.resende@ez.no ]
          Pedro Resende (Inactive) made changes -
          Status QA [ 10008 ] InputQ [ 10001 ]
          Assignee Pedro Resende [ pedro.resende@ez.no ]
          Yannick Roger (Inactive) made changes -
          Status InputQ [ 10001 ] Development [ 3 ]
          Assignee Yannick Roger [ yannick.roger@ez.no ]
          Yannick Roger (Inactive) made changes -
          Status Development [ 3 ] Documentation done [ 10011 ]
          Fix Version/s 4.5 Maintenance [ 12585 ]
          Fix Version/s 4.6 Maintenance [ 12584 ]
          Fix Version/s 4.7 Maintenance [ 12583 ]
          Fix Version/s 5.0 Maintenance [ 11287 ]
          Fix Version/s 5.1 Maintenance [ 12301 ]
          Fix Version/s 5.2 Maintenance [ 12782 ]
          Fix Version/s 5.3.5 [ 13889 ]
          Fix Version/s 5.4.2 [ 13979 ]
          Paulo Nunes (Inactive) made changes -
          Status Documentation done [ 10011 ] QA [ 10008 ]
          Assignee Yannick Roger [ yannick.roger@ez.no ] Paulo Nunes [ paulo.nunes@ez.no ]
          Pedro Resende (Inactive) made changes -
          Rank Ranked higher
          André Rømcke made changes -
          Fix Version/s 6.0.0 [ 13181 ]
          Paulo Nunes (Inactive) made changes -
          Assignee Paulo Nunes [ paulo.nunes@ez.no ] Paulo Silva [ paulo.silva@ez.no ]
          Hide
          Paulo Silva (Inactive) added a comment -

          QA Approved
          Tested on 4.5, 4.6, 4.7, 5.0, 5.1, 5.2, 5.3, 5.4 and master

          Show
          Paulo Silva (Inactive) added a comment - QA Approved Tested on 4.5, 4.6, 4.7, 5.0, 5.1, 5.2, 5.3, 5.4 and master
          Paulo Silva (Inactive) made changes -
          Assignee Paulo Silva [ paulo.silva@ez.no ]
          Status QA [ 10008 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          André Rømcke made changes -
          Workflow eZ Engineering Scrumban Workflow [ 65583 ] EZ* Development Workflow [ 85623 ]
          Alex Schuster made changes -
          Workflow EZ* Development Workflow [ 85623 ] EZEE Development Workflow [ 124486 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Confirmed Confirmed
          12d 17h 5m 1 yannick.roger@ez.no 05/Jan/15 9:41 AM
          Confirmed Confirmed InputQ InputQ
          21s 1 yannick.roger@ez.no 05/Jan/15 9:41 AM
          QA QA InputQ InputQ
          1h 59m 1 pedro.resende@ez.no 05/Jan/15 11:53 AM
          InputQ InputQ Development Development
          34m 26s 2 yannick.roger@ez.no 05/Jan/15 12:28 PM
          Development Development Documentation Review done Documentation Review done
          12m 7s 2 yannick.roger@ez.no 05/Jan/15 12:28 PM
          Documentation Review done Documentation Review done QA QA
          3m 27s 2 Paulo Nunes 05/Jan/15 12:31 PM
          QA QA Closed Closed
          4d 5h 39m 1 paulo.silva@ez.no 09/Jan/15 6:10 PM

            People

            • Assignee:
              Unassigned
              Reporter:
              Douglas Hammond
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: