Uploaded image for project: 'Support Team Tools'
  1. Support Team Tools
  2. STT-314

Mixing of GROUP columns in restore_deleted_users.php

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Component/s: Support Toolkit
    • Labels:
      None

      Description

      I have move yesterday the restore users function to my ACP and have there an sql error:
      Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause [1140] - - SQL - - SELECT MAX(post_id) AS post_id, post_username

      file: restore_deleted_users.php
      line: 46-48

      "GROUP BY post_username" fix the problem.

        Attachments

          Activity

            People

            • Assignee:
              Noxwizard Patrick Webster
              Reporter:
              Kostenloses-Forum Kostenloses-Forum [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: