Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

missing entry of email address in oc_users table #3188

Closed
mr-bolle opened this issue Jan 21, 2017 · 1 comment
Closed

missing entry of email address in oc_users table #3188

mr-bolle opened this issue Jan 21, 2017 · 1 comment

Comments

@mr-bolle
Copy link

mr-bolle commented Jan 21, 2017

Steps to reproduce

  1. Admin Account > Setting > activate 'Show email address'
  2. into User Management a new Column 'E-Mail' exist
  3. Add a new User or adjust a existing User with the E-Mail Address
  4. SQL Request: select * from oc_users - only 'uid' 'displayname' 'password' is available

https://abload.de/img/adminaccount-user-setlns1h.jpg

Expected behaviour

Into the oc_users Table the E-Mail Address from the Users should be available

Actual behaviour

The User Account E-Mail Address is missing into the SQL Table. And that's why it isn't possible to create a Backup of this Information.

Server configuration

Operating system:
Rasbian Debian Jessie - Linux 4.4.38-v7+ on armv7l

Web server:
Apache2

Database:
MariaDB

PHP version:
PHP 5.6.29-0+deb8u1

Nextcloud version: (see Nextcloud admin page)
10.0.3 (stable) - the same behavior i recognize from the previous versions

Updated from an older Nextcloud/ownCloud or fresh install:
update from a older install

Where did you install Nextcloud from:
https://download.nextcloud.com/server/releases/

Signing status:

Signing status
Login as admin user into your Nextcloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

List of activated apps:

App list
If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

The content of config/config.php:

Config report
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your Nextcloud installation folder

or 

Insert your config.php content here
(Without the database password, passwordsalt and secret)

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/...

LDAP configuration (delete this part if not used)

LDAP config
With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your Nextcloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

Logs

Web server error log

Web server error log ``` Insert your webserver log here ```

Nextcloud log (data/nextcloud.log)

Nextcloud log ``` Insert your Nextcloud log here ```

Browser log

Browser log ``` Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...

</details>
@blizzz
Copy link
Member

blizzz commented Jan 23, 2017

The email is stored in the oc_preferences table.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants