You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
After User clicked on Link in Registration Email (To create a new account on DN NextCloud, just click the following link:) an internal Server Error occured
User is not shown in User directory
Expected behaviour
User should be shown in Group we are using for new users
Actual behaviour
User is not shown in Nextcloud but could be found in Database
The group disabled & "group for new users" indicates 1 user but no user actually is displayed
Server configuration
Operating system:
Ubuntu 14.04 Web server:
Apache Database:
MySQL 5.5.62 PHP version:
7.0.32 Nextcloud version: (see Nextcloud admin page)
13.07 Updated from an older Nextcloud/ownCloud or fresh install:
Update from 12.0.12 Where did you install Nextcloud from:
Update through nextcloud Updater Signing status:
Are you using external storage, if yes which one: local/smb/sftp/...
1 local folder Are you using encryption: yes/no
no Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no
Client configuration
Browser:
IE11, Chrome Operating system:
Windows 7 Pro
Logs
Web server error log
Web server error log
2018-11-12 09:06:32 | Error | 80.154.98.131 | 500 | POST /nextcloud/index.php/apps/registration/verify/X7CRQF HTTP/1.1
Nextcloud log (data/nextcloud.log)
Nextcloud log
OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM `*PREFIX*registration` WHERE `token` = ? "; parameters Array ( [0] => X7CRQF ) ; limit ""; offset ""
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/public/AppFramework/Db/Mapper.php - line 359: OCP\AppFramework\Db\Mapper->findOneQuery('SELECT * FROM `...', Array, NULL, NULL)
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/apps/registration/db/registrationmapper.php - line 47: OCP\AppFramework\Db\Mapper->findEntity('SELECT * FROM `...', Array)
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/apps/registration/service/registrationservice.php - line 337: OCA\Registration\Db\RegistrationMapper->findByToken('X7CRQF')
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/apps/registration/controller/registercontroller.php - line 144: OCA\Registration\Service\RegistrationService->getRegistrationForToken('X7CRQF')
[internal function] OCA\Registration\Controller\RegisterController->createAccount('X7CRQF')
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 161: call_user_func_array(Array, Array)
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 91: OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Registration\Controller\RegisterController), 'createAccount')
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/App.php - line 115: OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Registration\Controller\RegisterController), 'createAccount')
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47: OC\AppFramework\App main('OCA\\Registratio...', 'createAccount', Object(OC\AppFramework\DependencyInjection\DIContainer), Array)
[internal function] OC\AppFramework\Routing\RouteActionHandler->__invoke(Array)
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/Route/Router.php - line 297: call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array)
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/base.php - line 999: OC\Route\Router->match('/apps/registrat...')
/var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/index.php - line 42: OC handleRequest()
{main}
The text was updated successfully, but these errors were encountered:
I did an additional test and created another user using Registration App.
Now there was no error message after clicking on registration link and no errors in NExtcloud/Apache Log
The Groups disabled & new user group now indicates 2 users but none is shown in list..
If I create a new user directly in Nextcloud it's working.
I did some more investigations and it seems this is a Nextcloud related Bug: nextcloud/server#8917
After enabling the "hidden" User using occ command line it is visible and he can login now.
Seems this happens only on systems >50 Users, we habe 88 so that's why it was not shown I guess.
Steps to reproduce
Expected behaviour
User should be shown in Group we are using for new users
Actual behaviour
User is not shown in Nextcloud but could be found in Database
The group disabled & "group for new users" indicates 1 user but no user actually is displayed
Server configuration
Operating system:
Ubuntu 14.04
Web server:
Apache
Database:
MySQL 5.5.62
PHP version:
7.0.32
Nextcloud version: (see Nextcloud admin page)
13.07
Updated from an older Nextcloud/ownCloud or fresh install:
Update from 12.0.12
Where did you install Nextcloud from:
Update through nextcloud Updater
Signing status:
Signing status
No errors have been found.List of activated apps:
App list
Enabled: - activity: 2.6.1 - admin_notifications: 1.0.1 - announcementcenter: 3.2.1 - bruteforcesettings: 1.1.0 - calendar: 1.6.1 - caniupdate: 0.1.3 - checksum: 0.4.1 - comments: 1.3.0 - dav: 1.4.7 - external: 3.0.4 - federatedfilesharing: 1.3.1 - files: 1.8.0 - files_downloadactivity: 1.2.0 - files_external: 1.4.1 - files_pdfviewer: 1.2.1 - files_sharing: 1.5.0 - files_texteditor: 2.5.1 - files_trashbin: 1.3.0 - files_versions: 1.6.0 - files_videoplayer: 1.2.0 - flowupload: 0.0.8 - groupfolders: 1.3.3 - impersonate: 1.0.4 - logreader: 2.0.0 - lookup_server_connector: 1.1.0 - nextcloud_announcements: 1.2.0 - notifications: 2.1.2 - oauth2: 1.1.1 - password_policy: 1.3.0 - provisioning_api: 1.3.0 - quicknotes: 0.1.4 - quota_warning: 1.2.0 - ransomware_protection: 1.1.2 - registration: 0.4.5 - serverinfo: 1.3.0 - sharebymail: 1.3.0 - survey_client: 1.1.0 - systemtags: 1.3.0 - theming: 1.4.5 - twofactor_backupcodes: 1.2.3 - updatenotification: 1.3.0 - workflowengine: 1.3.0 Disabled: - admin_audit - encryption - federation - firstrunwizard - gallery - user_external - user_ldapThe content of config/config.php:
Config report
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "www.dieboldnixdorfaustria.com", "dieboldnixdorfaustria.com" ], "integrity.check.disabled": false, "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "https:\/\/www.dieboldnixdorfaustria.com\/nextcloud", "dbtype": "mysql", "version": "13.0.7.2", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "php", "mail_domain": "***REMOVED SENSITIVE VALUE***", "forcessl": true, "theme": "", "maintenance": false, "forceSSLforSubdomains": true, "loglevel": 1, "trashbin_retention_obligation": "auto", "filelocking.enabled": "true", "memcache.local": "\\OC\\Memcache\\Redis", "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379, "timeout": 0, "dbindex": 0 }, "updater.release.channel": "production" } }Are you using external storage, if yes which one: local/smb/sftp/...
1 local folder
Are you using encryption: yes/no
no
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...
no
Client configuration
Browser:
IE11, Chrome
Operating system:
Windows 7 Pro
Logs
Web server error log
Web server error log
2018-11-12 09:06:32 | Error | 80.154.98.131 | 500 | POST /nextcloud/index.php/apps/registration/verify/X7CRQF HTTP/1.1Nextcloud log (data/nextcloud.log)
Nextcloud log
OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM `*PREFIX*registration` WHERE `token` = ? "; parameters Array ( [0] => X7CRQF ) ; limit ""; offset "" /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/public/AppFramework/Db/Mapper.php - line 359: OCP\AppFramework\Db\Mapper->findOneQuery('SELECT * FROM `...', Array, NULL, NULL) /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/apps/registration/db/registrationmapper.php - line 47: OCP\AppFramework\Db\Mapper->findEntity('SELECT * FROM `...', Array) /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/apps/registration/service/registrationservice.php - line 337: OCA\Registration\Db\RegistrationMapper->findByToken('X7CRQF') /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/apps/registration/controller/registercontroller.php - line 144: OCA\Registration\Service\RegistrationService->getRegistrationForToken('X7CRQF') [internal function] OCA\Registration\Controller\RegisterController->createAccount('X7CRQF') /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 161: call_user_func_array(Array, Array) /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 91: OC\AppFramework\Http\Dispatcher->executeController(Object(OCA\Registration\Controller\RegisterController), 'createAccount') /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/App.php - line 115: OC\AppFramework\Http\Dispatcher->dispatch(Object(OCA\Registration\Controller\RegisterController), 'createAccount') /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php - line 47: OC\AppFramework\App main('OCA\\Registratio...', 'createAccount', Object(OC\AppFramework\DependencyInjection\DIContainer), Array) [internal function] OC\AppFramework\Routing\RouteActionHandler->__invoke(Array) /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/private/Route/Router.php - line 297: call_user_func(Object(OC\AppFramework\Routing\RouteActionHandler), Array) /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/lib/base.php - line 999: OC\Route\Router->match('/apps/registrat...') /var/www/vhosts/lvps83-169-1-226.dedicated.hosteurope.de/dieboldnixdorfaustria.com/nextcloud/index.php - line 42: OC handleRequest() {main}The text was updated successfully, but these errors were encountered: