Support intro
Sorry to hear you’re facing problems
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
Nextcloud version (eg, 12.0.2): 18.0.1
Operating system and version (eg, Ubuntu 17.04): LMDE 3 Cindy
Apache or nginx version (eg, Apache 2.4.25): 2.4.25
PHP version (eg, 7.1): 7.2.28
The issue you are facing: While adding external drives I am unable to select users or groups. The box says Loading Failed.
Is this the first time you’ve seen this error? (Y/N): Yes
Steps to replicate it:
- Try selecting Users or Groups to access external drives
The output of your Nextcloud log in Admin > Logging:
[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT `uid`, `displayname` FROM `oc_users` `u` LEFT JOIN `oc_preferences` `p` ON (`userid` = `uid`) AND (`appid` = 'settings') AND (`configkey` = 'email') WHERE (`uid` COLLATE utf8mb4_general_ci LIKE ?) OR (`displayname` COLLATE utf8mb4_general_ci LIKE ?) OR (`configvalue` COLLATE utf8mb4_general_ci LIKE ?) ORDER BY `uid_lower` ASC LIMIT 30' with params ["%%", "%%", "%%"]:
SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'utf8' at <<closure>>
0. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... '", Doctrine\DBAL\Dr ... ]})
1. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... '")
2. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 911
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "SELECT `uid`, ` ... 0", {1: "%%",2: "%%",3: "%%"})
3. /var/www/nextcloud/lib/private/DB/Connection.php line 199
Doctrine\DBAL\Connection->executeQuery("SELECT `uid`, ` ... 0", {1: "%%",2: "%%",3: "%%"}, {1: 2,2: 2,3: 2}, "*** sensitive parameter replaced ***")
4. /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 200
OC\DB\Connection->executeQuery("SELECT `uid`, ` ... 0", {1: "%%",2: "%%",3: "%%"}, {1: 2,2: 2,3: 2})
5. /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 215
Doctrine\DBAL\Query\QueryBuilder->execute()
6. /var/www/nextcloud/lib/private/User/Database.php line 285
OC\DB\QueryBuilder\QueryBuilder->execute()
7. /var/www/nextcloud/lib/private/User/Manager.php line 275
OC\User\Database->getDisplayNames("", 30, 0)
8. /var/www/nextcloud/apps/files_external/ajax/applicable.php line 50
OC\User\Manager->searchDisplayName("", 30, 0)
9. /var/www/nextcloud/lib/private/Route/Route.php line 155
require_once("/var/www/nextcl ... p")
10. <<closure>>
OC\Route\Route->OC\Route\{closure}("*** sensitive parameters replaced ***")
11. /var/www/nextcloud/lib/private/Route/Router.php line 299
call_user_func(Closure {}, {_route: "files_ ... "})
12. /var/www/nextcloud/lib/base.php line 1008
OC\Route\Router->match("/apps/files_external/applicable")
13. /var/www/nextcloud/index.php line 38
OC::handleRequest()
GET /index.php/apps/files_external/applicable?pattern=&limit=30&offset=0&_=1582851635731
from 71.113.130.24 by jeff at 2020-02-28T01:00:40+00:00
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
<?php
$CONFIG = array (
'instanceid' => 'ocl7nygyhse3',
'passwordsalt' => 'D5xZZu37L/W+9RVop6uLkAGOGGZu1G',
'secret' => 'secret',
'trusted_domains' =>
array (
0 => 'mydomain.com',
),
'datadirectory' => '/home/data',
'dbtype' => 'mysql',
'version' => '18.0.1.3',
'overwrite.cli.url' => 'https://bmydomain.com',
'dbname' => 'nextcloud',
'dbhost' => 'localhost:5432',
'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'jeff',
'dbpassword' => 'password',
'installed' => true,
'maintenance' => false,
'mysql.utf8mb4' => true,
'mail_smtpmode' => 'smtp',
'mail_smtpsecure' => 'ssl',
'mail_sendmailmode' => 'smtp',
'mail_from_address' => 'myemail',
'mail_domain' => 'address.com',
'mail_smtpauth' => 1,
'mail_smtpauthtype' => 'LOGIN',
'mail_smtphost' => 'smtp.gmail.com',
'mail_smtpport' => '465',
'mail_smtpname' => 'myemail@assress.com',
'mail_smtppassword' => 'password',
'updater.release.channel' => 'stable',
);
The output of your Apache/nginx/system log in /var/log/____
:
[Thu Feb 27 00:09:04.291810 2020] [mpm_prefork:notice] [pid 6234] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2u configured -- resuming normal operations
[Thu Feb 27 00:09:04.291854 2020] [core:notice] [pid 6234] AH00094: Command line: '/usr/sbin/apache2'
[Thu Feb 27 19:42:41.876984 2020] [mpm_prefork:notice] [pid 6234] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[Thu Feb 27 19:42:42.020110 2020] [mpm_prefork:notice] [pid 6234] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2u configured -- resuming normal operations
[Thu Feb 27 19:42:42.020133 2020] [core:notice] [pid 6234] AH00094: Command line: '/usr/sbin/apache2'
[Thu Feb 27 19:42:42.391296 2020] [mpm_prefork:notice] [pid 6234] AH00171: Graceful restart requested, doing restart
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
[Thu Feb 27 19:42:42.476206 2020] [mpm_prefork:notice] [pid 6234] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2u configured -- resuming normal operations
[Thu Feb 27 19:42:42.476235 2020] [core:notice] [pid 6234] AH00094: Command line: '/usr/sbin/apache2'
[Thu Feb 27 19:55:12.171503 2020] [mpm_prefork:notice] [pid 6234] AH00169: caught SIGTERM, shutting down
[Thu Feb 27 19:55:12.317859 2020] [mpm_prefork:notice] [pid 25781] AH00163: Apache/2.4.25 (Debian) OpenSSL/1.0.2u configured -- resuming normal operations
[Thu Feb 27 19:55:12.317946 2020] [core:notice] [pid 25781] AH00094: Command line: '/usr/sbin/apache2'