when order by relation filed export error
Closed this issue · 1 comments
Environment
Sonata packages
$ composer show --latest 'sonata-project/*'
root@vagrant-ubuntu-trusty:~/www/lion/current# composer show --latest 'sonata-project/*'
Do not run Composer as root/super user! See https://getcomposer.org/root for details
sonata-project/admin-bundle 3.19.0 3.23.0 The missing Symfony Admin Generator
sonata-project/block-bundle 3.3.2 3.3.2 Symfony SonataBlockBundle
sonata-project/cache 1.0.7 1.0.7 Cache library
sonata-project/core-bundle 3.4.0 3.4.0 Symfony SonataCoreBundle
sonata-project/datagrid-bundle 2.2.1 2.2.1 Symfony SonataDatagridBundle
sonata-project/doctrine-orm-admin-bundle 3.1.5 3.1.6 Symfony Sonata / Integrate Doctrine ORM into the SonataAdminBundle
sonata-project/exporter 1.7.1 1.7.1 Lightweight Exporter library
Symfony packages
$ composer show --latest 'symfony/*'
root@vagrant-ubuntu-trusty:~/www/lion/current# composer show --latest 'symfony/'
Do not run Composer as root/super user! See https://getcomposer.org/root for details
symfony/monolog-bundle v2.12.1 v3.1.0 Symfony MonologBundle
symfony/phpunit-bridge v3.3.2 v3.3.8 Symfony PHPUnit Bridge
symfony/polyfill-apcu v1.3.0 v1.5.0 Symfony polyfill backporting apcu_ functions to lower PHP versions
symfony/polyfill-intl-icu v1.3.0 v1.5.0 Symfony polyfill for intl's ICU-related data and classes
symfony/polyfill-mbstring v1.3.0 v1.5.0 Symfony polyfill for the Mbstring extension
symfony/polyfill-php56 v1.3.0 v1.5.0 Symfony polyfill backporting some PHP 5.6+ features to lower PHP versions
symfony/polyfill-php70 v1.3.0 v1.5.0 Symfony polyfill backporting some PHP 7.0+ features to lower PHP versions
symfony/polyfill-util v1.3.0 v1.5.0 Symfony utilities for portability of PHP codes
symfony/security-acl v3.0.0 v3.0.0 Symfony Security Component - ACL (Access Control List)
symfony/swiftmailer-bundle v2.6.2 v3.0.3 Symfony SwiftmailerBundle
symfony/symfony v3.3.2 v3.3.8 The Symfony PHP framework
PHP version
$ php -v
# Put the result here.
root@vagrant-ubuntu-trusty:/www/lion/current# php -vtrusty+2 (cli) (built: May 22 2017 13:29:59) ( NTS )
PHP 7.0.19-1+deb.sury.org
Copyright (c) 1997-2017 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2017 Zend Technologies
Subject
Steps to reproduce
Expected results
Actual results
the sql error
[2017-09-04 10:01:28] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'SELECT DISTINCT t0_.id AS id_0, t0_.month_date AS month_date
1, t0.income AS income_2, t0_.from_normal AS from_normal_3, t0_.from_system AS from_system_4, t0_.from_protected_user AS from_protected_user_5, t0_.master_id AS master_id_6 FROM t_protected_user_master_
report t0_ LEFT JOIN t_master t1_ ON t0_.master_id = t1_.acc_id LEFT JOIN t_user t2_ ON t1_.acc_id = t2_.acc_id LEFT JOIN t_room t3_ ON t1_.room_id = t3_.room_id WHERE t0_.month_date LIKE '2017-08%' ORDER
BY t2_.acc_id ASC': SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'lion.t2_.acc_id' which is not in SELECT list; this is incompatible wit
h DISTINCT" at /data/www/lion/releases/20170828083035Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {"exception":"[object] (Doctrine\DBAL\Exception\DriverException(cod
e: 0): An exception occurred while executing 'SELECT DISTINCT t0_.id AS id_0, t0_.month_date AS month_date_1, t0_.income AS income_2, t0_.from_normal AS from_normal_3, t0_.from_system AS from_system_4, t0
.from_protected_user AS from_protected_user_5, t0.master_id AS master_id_6 FROM t_protected_user_master_report t0_ LEFT JOIN t_master t1_ ON t0_.master_id = t1_.acc_id LEFT JOIN t_user t2_ ON t1_.acc_id
= t2_.acc_id LEFT JOIN t_room t3_ ON t1_.room_id = t3_.room_id WHERE t0_.month_date LIKE '2017-08%' ORDER BY t2_.acc_id ASC':\n\nSQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is n
ot in SELECT list, references column 'lion.t2_.acc_id' which is not in SELECT list; this is incompatible with DISTINCT at /data/www/lion/releases/20170828083035Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Dri
ver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'lion.t2_
.acc_id' which is not in SELECT list; this is incompatible with DISTINCT at /data/www/lion/releases/20170828083035Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107, PDOException(code:
HY000): SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'lion.t2_.acc_id' which is not in SELECT list; this is incompatible with DISTINCT at
/data/www/lion/releases/20170828083035Z/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:105)"} []
Is this still relevant? If so, what is blocking it? Is there anything you can do to help move it forward?
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.