Problem with default sorting of extensions list

[Guite]

Q	A
Zikula Version	1.4.3-dev
PHP Version	7.0.4

Expected behavior

Viewing the extensions list works.

Actual behavior

The following error appears:

An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT DISTINCT id_0 FROM (SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.type AS type_2, m0_.displayname AS displayname_3, m0_.url AS url_4, m0_.description AS description_5, m0_.directory AS directory_6, m0_.version AS version_7, m0_.capabilities AS capabilities_8, m0_.state AS state_9, m0_.securityschema AS securityschema_10, m0_.core_min AS core_min_11, m0_.core_max AS core_max_12 FROM modules m0_) dctrn_result ORDER BY displayname_3 ASC LIMIT 40 OFFSET 0': SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dctrn_result.displayname_3' which is not in SELECT list; this is incompatible with DISTINCT") in "/.../src/system/ExtensionsModule/Resources/views/Module/viewModuleList.html.twig" at line 13.

Steps to reproduce

After a fresh installation call /extensions/module/list

[craigh]

Any way to test this with PHP < 7 ? I'm not sure php 7 can technically be supported by us yet.

[Guite]

If you are using PHP 5 and not experiencing this error, it happens in PHP 7 only.

[craigh]

I've not tested yet

[Guite]

This seems not related to PHP 7, but to MySQL 5.7

[Guite]

See doctrine/orm#4846

[craigh]

@Guite please confirm this is not a php 7 issue. If it is, please move to Core-2.0.0-beta milestone. If a MySQL issue, then please look at MySQL versions supported by Symfony 2.x. If problem exists with supported version, then we can look into this further. My guess is this should be moved...

[Guite]

The referenced Doctrine issue shows clearly that this is related to MySQL 5.7 and not to PHP 7.

[craigh]

Doctrine tends to be impossibly slow in releasing bug fixes.

[craigh]

I don't know how to solve this then.

[Guite]

Postpone to 1.4.4 is fine for me, since it is a vendor problem.

[Guite]

Same problem in ZAuth admin list page.

[Guite]

The problem is gone.

[gfr]

I have the same issue with following pages using the paginator:

• /extensions/module/list
• /adminpanel/categories
• /zauth/admin/list

Zikula 1.4.4 / Symfony 2.8.14 / PHP 5.6.27-1+deb.sury.org~xenial+1 / Apache 2.4.18 / MySQL 5.7.16

[gfr]

Related doctrine issue: doctrine/orm#4846

[craigh]

this is not a core problem but a MySQL 5.7 + Doctrine problem. we cannot fix it.

[Guite]

Probable fixes:
doctrine/orm#5622
doctrine/orm#5973

But still a vendor thing.

[craigh]

closing as NOT CORE