nextcloud / server

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

Problem Sharing files (NextCloud 16 - Ubuntu 18.04 LTS) - Invalid query, please check the syntax. API specifications are here: http://www.freedesktop.org/wiki/Specifications/open-collaboration-services sharing #16059

Closed sebastienserre closed 5 years ago

sebastienserre commented 5 years ago

Hello

Steps to reproduce

CReate a folder, click on icon to share it then in input add a nextcloud user

Expected behaviour

We should be allowed to share the folder to the user

Actual behaviour

Nothing happen and a message "Invalid query, please check the syntax. API specifications are here: http://www.freedesktop.org/wiki/Specifications/open-collaboration-services sharing"

Server configuration

Operating system: Ubuntu Server 18.04

Web server: Apache

Database: Mariadb

PHP version:

$ php --version PHP 7.2.19-0ubuntu0.18.04.1 (cli) (built: Jun 4 2019 14:48:12) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies with Zend OPcache v7.2.19-0ubuntu0.18.04.1, Copyright (c) 1999-2018, by Zend Technologies $

Nextcloud version: (see Nextcloud admin page) 16.0.1

Updated from an older Nextcloud/ownCloud or fresh install: Fresh Install

Where did you install Nextcloud from: from official Nextcloud website

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 ``` $ sudo -u www-data php occ app:list Enabled: - accessibility: 1.2.0 - activity: 2.9.1 - admin_audit: 1.6.0 - bruteforcesettings: 1.3.0 - caniupdate: 0.2.0 - carnet: 0.16.2 - checksum: 0.4.3 - cloud_federation_api: 0.2.0 - dashboard: 6.0.0 - dav: 1.9.2 - encryption: 2.4.0 - extract: 1.2.0 - federatedfilesharing: 1.6.0 - federation: 1.6.0 - files: 1.11.0 - files_antivirus: 2.1.1 - files_pdfviewer: 1.5.0 - files_rightclick: 0.13.0 - files_sharing: 1.8.0 - files_texteditor: 2.8.0 - files_trashbin: 1.6.0 - files_versions: 1.9.0 - fulltextsearch_elasticsearch: 1.3.3 - gallery: 18.3.0 - hsts: 0.2.0 - logreader: 2.1.0 - lookup_server_connector: 1.4.0 - nextcloud_announcements: 1.5.0 - notifications: 2.4.1 - oauth2: 1.4.2 - password_policy: 1.6.0 - previewgenerator: 2.1.0 - privacy: 1.0.0 - provisioning_api: 1.6.0 - ransomware_protection: 1.4.0 - recommendations: 0.4.0 - serverinfo: 1.6.0 - sharebymail: 1.6.0 - sharerenamer: 2.6.0 - theming: 1.7.0 - twofactor_backupcodes: 1.5.0 - unsplash: 1.1.3 - updatenotification: 1.6.0 - viewer: 1.0.0 - workflowengine: 1.6.0 Disabled: - announcementcenter - calendar - circles - comments - contacts - deck - dropit - files_external - files_frommail - files_mindmap - files_videoplayer - firstrunwizard - groupfolders - keeporsweep - mail - music - notes - quicknotes - quota_warning - scanner - social - spreed - spreedme - support - survey_client - systemtags - tasks - user_ldap - video_converter $ ```

Nextcloud configuration:

Config report ``` $ sudo -u www-data php occ config:list system { "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "cloud.thivinfo.com" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "dbtype": "mysql", "version": "16.0.1.1", "overwrite.cli.url": "http:\/\/cloud.thivinfo.com", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.local": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 6379 }, "app_install_overwrite": [ "tasks", "end_to_end_encryption", "admin_notifications", "spreedme", "caniupdate", "files_clipboard" ], "maintenance": false, "theme": "", "loglevel": 2, "mysql.utf8mb4": true, "mail_smtpmode": "smtp", "mail_smtpsecure": "ssl", "mail_sendmailmode": "smtp", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtpauthtype": "LOGIN", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "465", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "has_rebuilt_cache": true } } $ ```

Are you using external storage, if yes which one: local/smb/sftp/... no Are you using encryption: yes/no yes Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/... no

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) ... ```
kesselb commented 5 years ago

Duplicate of #15990