Forums Forums Community Discussion Fresh Install -> User Management SQL error

Viewing 1 reply thread
  • Author
    Posts
    • #3105
      Kenny Peng
      Inactive

      Fresh install. Tried on:
      Ubuntu 16.04 / Apache2 / PHP5.6
      … same … / PHP7.2
      Ubuntu 18.04 / … same …

      Upon initial log-in -> Settings -> Administration / User Management, receive the following PHP/SQL error:

      PDOException Object ( [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘opencats.user.access_level’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [string:Exception:private] => [code:protected] => 42000 [file:protected] => /var/www/html/candidats/lib/ClsNaanalPDO.php [line:protected] => 125 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/html/candidats/lib/ClsNaanalPDO.php [line] => 125 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( ) ) [1] => Array ( [file] => /var/www/html/candidats/lib/ClsNaanalPDO.php [line] => 557 [function] => query [class] => ClsNaanalPDO [type] => -> [args] => Array ( [0] => SELECT COUNT(user.site_id) AS totalUsers, user.access_level, site.user_licenses AS userLicenses FROM user LEFT JOIN site ON user.site_id = site.site_id WHERE user.site_id = 1 AND user.access_level > 100 GROUP BY user.site_id ) ) [2] => Array ( [file] => /var/www/html/candidats/lib/DatabaseConnectionPDO.php [line] => 154 [function] => setQuery [class] => ClsNaanalPDO [type] => -> [args] => Array ( [0] => SELECT COUNT(user.site_id) AS totalUsers, user.access_level, site.user_licenses AS userLicenses FROM user LEFT JOIN site ON user.site_id = site.site_id WHERE user.site_id = 1 AND user.access_level > 100 GROUP BY user.site_id ) ) [3] => Array ( [file] => /var/www/html/candidats/lib/DatabaseConnectionPDO.php [line] => 290 [function] => query [class] => DatabaseConnection [type] => -> [args] => Array ( [0] => SELECT COUNT(user.site_id) AS totalUsers, user.access_level, site.user_licenses AS userLicenses FROM user LEFT JOIN site ON user.site_id = site.site_id WHERE user.site_id = 1 AND user.access_level > 100 GROUP BY user.site_id ) ) [4] => Array ( [file] => /var/www/html/candidats/lib/Users.php [line] => 1025 [function] => getAssoc [class] => DatabaseConnection [type] => -> [args] => Array ( [0] => SELECT COUNT(user.site_id) AS totalUsers, user.access_level, site.user_licenses AS userLicenses FROM user LEFT JOIN site ON user.site_id = site.site_id WHERE user.site_id = 1 AND user.access_level > 100 GROUP BY user.site_id ) ) [5] => Array ( [file] => /var/www/html/candidats/modules/settings/SettingsUI.php [line] => 3618 [function] => getLicenseData [class] => Users [type] => -> [args] => Array ( ) ) [6] => Array ( [file] => /var/www/html/candidats/lib/ModuleUtility.php [line] => 189 [function] => manageUsers [class] => SettingsUI [type] => -> [args] => Array ( ) ) [7] => Array ( [file] => /var/www/html/candidats/index.php [line] => 326 [function] => loadModule [class] => ModuleUtility [type] => :: [args] => Array ( [0] => settings ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42000 [1] => 1055 [2] => Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘opencats.user.access_level’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ) ) ;

      1) file:/var/www/html/lib/ClsNaanalPDO.php function:trace Container Function:query line:129
      Array
      (
      [0] => PDO Query execution failed prematurely. Error: 1
      )

      2) file:/var/www/html/lib/ClsNaanalPDO.php class:ClsNaanalPDO type:-> function:query Container Function:setQuery line:557
      Array
      (
      [0] => SELECT
      COUNT(user.site_id) AS totalUsers,
      user.access_level,
      site.user_licenses AS userLicenses
      FROM
      user
      LEFT JOIN site
      ON user.site_id = site.site_id
      WHERE
      user.site_id = 1
      AND
      user.access_level > 100
      GROUP BY
      user.site_id
      )

      3) file:/var/www/html/lib/DatabaseConnectionPDO.php class:ClsNaanalPDO type:-> function:setQuery Container Function:query line:154
      Array
      (
      [0] => SELECT
      COUNT(user.site_id) AS totalUsers,
      user.access_level,
      site.user_licenses AS userLicenses
      FROM
      user
      LEFT JOIN site
      ON user.site_id = site.site_id
      WHERE
      user.site_id = 1
      AND
      user.access_level > 100
      GROUP BY
      user.site_id
      )

      4) file:/var/www/html/lib/DatabaseConnectionPDO.php class:DatabaseConnection type:-> function:query Container Function:getAssoc line:290
      Array
      (
      [0] => SELECT
      COUNT(user.site_id) AS totalUsers,
      user.access_level,
      site.user_licenses AS userLicenses
      FROM
      user
      LEFT JOIN site
      ON user.site_id = site.site_id
      WHERE
      user.site_id = 1
      AND
      user.access_level > 100
      GROUP BY
      user.site_id
      )

      5) file:/var/www/html/lib/Users.php class:DatabaseConnection type:-> function:getAssoc Container Function:getLicenseData line:1025
      Array
      (
      [0] => SELECT
      COUNT(user.site_id) AS totalUsers,
      user.access_level,
      site.user_licenses AS userLicenses
      FROM
      user
      LEFT JOIN site
      ON user.site_id = site.site_id
      WHERE
      user.site_id = 1
      AND
      user.access_level > 100
      GROUP BY
      user.site_id
      )

      6) file:/var/www/html/modules/settings/SettingsUI.php class:Users type:-> function:getLicenseData Container Function:manageUsers line:3618
      Array
      (
      )

      7) file:/var/www/html/lib/ModuleUtility.php class:SettingsUI type:-> function:manageUsers Container Function:loadModule line:189
      Array
      (
      )

      8) file:/var/www/html/index.php class:ModuleUtility type::: function:loadModule Container Function: line:326
      Array
      (
      [0] => settings
      )

    • #3106
      shobana
      Participant

      Hi,

      Please check this link: https://auieo.com/candidats/forums/topic/how-to-solve-this-kind-of-error
      If you still face the error please contact support@auieo.com

      with regards,
      Shobana
      Auieo Software Pvt Ltd.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.