nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
27.31k stars 4.06k forks source link

improve GUI administration for multi-language collaborative efforts #17631

Closed TP75 closed 5 years ago

TP75 commented 5 years ago

Steps to reproduce

Establish several items i.e. a set of mixed website entries to the 'External sites' app sequentially and with different locales selected to the admin account in use. Arbitrarily re-order these items by help of the 'App order' app with different locales selected.

Arbitrarily select and deselect the administrative views of both apps several times each and make changes to the resp. app settings inside each of their views. This is understood as an usual administration task in a multi-language collaborative environment like a productive distributed Nextcloud in the EU.

Expected behaviour

Presumably all NC administration and certainly the GUI administration tasks in a multi-language collaborative effort require:

  1. Any combination of locales and languages with selectable setup items shall establish a stable and reasonable setup (i.e. list of apps in this use case) in the database.
  2. Any administrative entries to the NC database shall happen in a reasonable & transparent way and the integrity of the administrative setup shall be ensured at all times.
  3. Use of locales and translations should be as flexible as possible and should be evenly distributed to the connected clients and the accessing web browsers.
  4. The combination of both the 'External sites' app and the 'App order' app should always provide a stable set of data.

Furthermore, the NC PHP and SQL code should provide some reasonable safety measures for the extended reliability and improved usability of all desktop clients connected.

Actual behaviour

While establishing the a.m. mixed items by the 'External sites' app view several times some or even more superfluous items were observed. These entires appeared automatically and were redundantly listed in the view i.e. became added automatically to the bottom of the websites list. However, the viewed superfluous entries apparently vanished after closing the 'External sites' app view and could not be found in the GUI administration later.

No errors were found in the 'Logging' GUI. Only some days later the apparent b.m. issue of "the 'app list' of doom" was observed by coincidence and from several different NC desktop clients connected to this NC server. Presumably, the a.m. superfluous entries only vanished from the GUI admin view but as data entries unfortunately remained in great numbers in the database.

Intended website items and app order of the 'External sites' setup in this use case:

See the screenshot below.

Server configuration detail

Operating system: Linux 4.19.0-6-amd64 - Debian 4.19.67-2+deb10u1 (2019-09-20) x86_64

Webserver: Apache (apache2handler) -- 2.4.38-3+deb10u3

Database: mysql 10.3.17 -- mariadb-server 10.3.17-0+deb10u1

PHP version:

7.3.9-1~deb10u1 Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, sodium, standard, apache2handler, mysqlnd, PDO, xml, apcu, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, igbinary, imagick, imap, intl, json, ldap, exif, mysqli, pdo_mysql, apc, posix, readline, redis, shmop, SimpleXML, smbclient, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, Phar, libsmbclient, Zend OPcache

Nextcloud version: 16.0.5 - 16.0.5.1

Updated from an older Nextcloud/ownCloud or fresh install: updated from 16.0.4.1 via CLI

Where did you install Nextcloud from:

Signing status
List of activated apps ``` Enabled: - accessibility: 1.2.0 - activity: 2.9.1 - admin_audit: 1.6.0 - announcementcenter: 3.5.1 - **apporder: 0.8.0** - bruteforcesettings: 1.4.0 - calendar: 1.7.1 - cloud_federation_api: 0.2.0 - comments: 1.6.0 - contacts: 3.1.6 - dav: 1.9.2 - **external: 3.3.1** - federatedfilesharing: 1.6.0 - federation: 1.6.0 - files: 1.11.0 - files_accesscontrol: 1.6.0 - files_pdfviewer: 1.5.0 - files_rightclick: 0.15.1 - files_sharing: 1.8.0 - files_texteditor: 2.8.0 - files_trashbin: 1.6.0 - files_versions: 1.9.0 - files_videoplayer: 1.5.0 - firstrunwizard: 2.5.0 - gallery: 18.3.0 - groupfolders: 4.1.4 - issuetemplate: 0.5.0 - logreader: 2.1.0 - lookup_server_connector: 1.4.0 - nextcloud_announcements: 1.5.0 - notes: 3.0.3 - notifications: 2.4.1 - oauth2: 1.4.2 - password_policy: 1.6.0 - polls: 0.10.2 - privacy: 1.0.0 - provisioning_api: 1.6.0 - recommendations: 0.4.0 - richdocuments: 3.4.2 - serverinfo: 1.6.0 - sharebymail: 1.6.0 - survey_client: 1.4.0 - systemtags: 1.6.0 - tasks: 0.11.3 - text: 1.0.2 - theming: 1.7.0 - twofactor_backupcodes: 1.5.0 - updatenotification: 1.6.0 - viewer: 1.1.0 - workflowengine: 1.6.0 Disabled: - encryption - files_external - spreed - support - user_ldap ```
Configuration (config/config.php) ``` { "debug": false, "trusted_domains": [ "*redacted*", "*redacted*" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "16.0.5.1", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "logtimezone": "Europe\/Berlin", "logdateformat": "Y-m-d H:i:s", "log_rotate_size": 52428800, "loglevel": 2, "activity_expire_days": 190, "installed": true, "memcache.local": "\\OC\\Memcache\\APCu", "memcache.distributed": "\\OC\\Memcache\\Redis", "filelocking.enabled": "true", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0, "dbindex": 0, "timeout": 1.5 }, "ldapIgnoreNamingRules": false, "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "maintenance": false, "instanceid": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "*redacted*", "theme": "", "mail_smtpmode": "smtp", "mail_smtpauthtype": "PLAIN", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "updater.release.channel": "production", "mysql.utf8mb4": true } ```

Are you using external storage, if yes which one:

Are you using encryption:

Are you using an external user-backend, if yes which one:

Client configuration

Browser: Mozilla Firefox/60.0, Apple Safari 12.x / 13.x

Operating system: Mac OS X / macOS , Debian Linux, MS-Windows

For more details on the client config and some funny relevant NC desktop screenshots refer to the related issue i.e. the parallel bug report nextcloud/desktop - avoid "the 'app list' of doom" # 1545

Logs

Web server error log remains open until further clarification ``` ```
Nextcloud log * until now no errors were found in the 'logging' view of the NC GUI which would relate to this issue * remains open until further clarification ``` ```
Browser log seems to be *not applicable* to this issue until further clarification

Server Administration

View of the 'External sites' setup:

screenshot_GUI_2019-10-22a01_external

View of the resp. 'App order' setup with the 'English(US)' EN variant locale selected:

screenshot_GUI_2019-10-22b01_apporder_en-US

View of the resp. 'App order' setup with the 'Deutsch(Förmlich/Sie)' DE variant locale selected:

screenshot_GUI_2019-10-22c01_apporder_de-DE_Sie

View of the resp. 'App order' setup with the 'Deutsch(Du)' DE variant locale selected:

screenshot_GUI_2019-10-22d01_apporder_de-DE_Du

View of the resp. 'App order' setup with the 'Nederlands' NL locale selected:

screenshot_GUI_2019-10-22e01_apporder_NL

juliusknorr commented 5 years ago

Not as server issue but a limitation of the current apporder app. See https://github.com/nextcloud/external/issues/164#issuecomment-544890173 as well

TP75 commented 5 years ago

@juliushaertl Thank you.

I fully agree after myself learning the same NC server account and the same 'External sites' setup on a Linux machine with the Version 2.5.1git desktop client produces a stable view.

Maybe not truly related to 'External sites' as presumed before?

Maybe an issue limited to an unstable Version 2.6.1RC1 desktop client?

juliusknorr commented 5 years ago

Lets continue over at nextcloud/external#164 since you posted the same questions there :wink: