Magento 2.3.1 customer grid sorting issue

Question

I am using magento 2.3.1.

I am having this strange issue only in admin>customer grid

No matter which column I choose to sort the results are always the same.

It happens only in this grid.

What I tried:

1. reindex all indexers, several times
2. checked Redis conf, removed, reinstalled again
3. Checked Opcache settings, disabled and enabled back
4. Used nginx standalone, used Nginx as proxy pass with Apache
5. Reboot server several time
6. Magento caches are disabled, recleared several times, recopliled and redeploy
7. Cleared ui_bookmark table

Nothing from these helped. The only thing I noticed is that on local server with apache only it works with no problem.

Also when this started, when I tried to install a new module, although module was istalled fine, upgraded and compiled when I went to admin I couldn't find it anywhere.

Again in local wasn't this problem. I think that these two are related.

UPDATE

After making some operations to server and needed to restart all services like Nginx, php-fpm, Redis, varnish, elastic magento customer grid started to work fine again.

But after working in admin about 2 days again the customer grid isn't sorting.

I am sure that is definitely some cache problem....Something is caching this particular grid....I am using Redis 5. Maybe I switch to 4?

Any help or ideas will be appreciated!

Answer 1

Faced the same problem in Magento 2.2.8.

The problem is that the controller returns the same results, sorted by ID (or not, not sure).

After digging into this I found out that a problem in this file:

vendor/magento/module-customer/Model/GroupManagement.php

Inside getLoggedInGroups method:

$groupNameSortOrder = $this->sortOrderBuilder
            ->setField('customer_group_code')
            ->setAscendingDirection()
            ->create();

Here, the sort is always set to AscendingDirection (setAscendingDirection) and after setting this sorting to search criteria ->addSortOrder($ groupNameSortOrder)

I fixed this temporarily by simply overriding this file and deleting the line with ->addSortOrder($ groupNameSortOrder)

Small guide:

1. Create new module.

2. File: app/code/VENDOR/MODULE/etc/adminhtml/di.xml

    <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
        <!-- Customer Admin Grid Sorting fix -->
        <preference for="Magento\Customer\Model\GroupManagement"
                    type="VENDOR\MODULE\Model\Customer\GroupManagement" />
    </config>
   

3. File: app/code/VENDOR/MODULE/Model/Customer/GroupManagement.php

   filterBuilder ->setField(GroupInterface::ID) ->setConditionType('neq') ->setValue(self::NOT_LOGGED_IN_ID) ->create(); $groupAll[] = $this->filterBuilder ->setField(GroupInterface::ID) ->setConditionType('neq') ->setValue(self::CUST_GROUP_ALL) ->create(); $searchCriteria = $this->searchCriteriaBuilder ->addFilters($notLoggedInFilter) ->addFilters($groupAll) ->create(); return $this->groupRepository->getList($searchCriteria)->getItems(); } }