Unable to execute command in phpMyAdmin application

Created:

2017-07-28 08:39:48 UTC

Modified:

2017-08-16 16:20:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to execute command in phpMyAdmin application

Applicable to:

  • Plesk for Linux

Symptoms

The execution of the command in phpMyAdmin terminates with the following error:

#1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'restodemo.be_modules.group_name' wich is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_b

Cause

Incompatibility of the ONLY_FULL_GROUP_BY mode with the executed command

Resolution

  1. Connect to the server using SSH .
  2. Remove ONLY_FULL_GROUP_BY from sql-mode option under [mysqld] section in the /etc/mysql/my.cnf file.
  3. Restart MySQL service:

    # service mysql restart

Have more questions? Submit a request
Please sign in to leave a comment.