User list not displayed

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version 13.0.2:
Operating system and version Centos 7:
Apache or nginx version httpd-2.4.6-80:
PHP version PHP 7.1.17:

The issue you are facing:

Is this the first time you’ve seen this error? Y:

Steps to replicate it:

  1. Select Users
    When “Users” is select a database query is performed:
 SELECT `m`.`user_id`, `f`.`size` FROM `oc_mounts` `m` INNER JOIN `oc_filecache` `f` ON (`m`.`storage_id` = `f`.`storage`) AND (`f`.`path` = 'files') WHERE (`m`.`mount_point` = CONCAT(CONCAT('/', `user_id`), '/')) AND (`m`.`user_id` IN ('list', 'off', 'all', 'the', 'users', 'in', 'Nextcloud', ...    )); 

below is the result of the query running manually in the local mysql client.

+---------------------+-------------+
| user_id             | size        |
+---------------------+-------------+
| admin               |     7044589 |
| user1               |     7053028 |
| user2               | 70131749189 |
| user3               |     7044592 |
| user4               |     7044592 |
| user5               |     7044592 |
| user6               |     7044592 |
| user7               |    65564433 |
| user8               |     7044592 |
| user9               |     7044592 |
| user10              |   240889717 |
| user11              |     7053620 |
| user12              |  9950882864 |
| user13              | 41055616673 |
| user14              |     7044459 |
| user15              |     7044459 |
| user16              |     7044459 |
| user17              |   116313621 |
| user18              |     7044459 |
+---------------------+-------------+
19 rows in set (1 min 37.98 sec)

As you can see I have one very large users and couple others pretty large.

The browser page hangs forever without showing the result after the query is finished.

Is it possible that query takes to long and php has closed the session, if so how do I either shorten the query time or make php wait for the results?

The output of your Nextcloud log in Admin > Logging:

Nothing

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'xxxxxxxxxxx',
  'passwordsalt' => 'blubleblu',
  'secret' => 'fatChange',
  'trusted_proxies' =>
  array (
    0 => '10.10.10.11',
  ),
  'forwarded_for_headers' =>
  array (
    0 => 'HTTP_X_FORWARDED_FOR',
    1 => 'HTTP_FORWARDED_FOR',
  ),
  'trusted_domains' =>
  array (
    0 => 'xxxx.yyyy.zzz',
  ),
  'datadirectory' => '/opt/nextcloud/',
  'overwrite.cli.url' => 'http://fxxxx.yyyy.zzz',
  'dbtype' => 'mysql',
  'version' => '13.0.2.1',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'xxxxxxXX',
  'installed' => true,
  'htaccess.RewriteBase' => '/',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => 'localhost',
    'port' => 6379,
  ),
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'overwritehost' => 'xxxxx.yyyy.zzz',
  'overwriteprotocol' => 'https',
  'mail_domain' => 'xxxxx.com',
  'mail_from_address' => 'xxxx',
  'mail_smtpdebug' => false,
  'mail_smtpmode' => 'smtp',
  'mail_smtphost' => 'smtprelay.xxxx.xx',
  'mail_smtpport' => '25',
  'mail_smtptimeout' => 10,
  'mail_smtpauthtype' => 'PLAIN',
  'maintenance' => false,
  'theme' => '',
  'loglevel' => 2,
);

The output of your Apache/nginx/system log in /var/log/____:

N/A

Thanks