When I fill the input with the username or email to share some folder, I’m getting the following ajax error from API:
{“ocs”:{“meta”:{“status”:“failure”,“statuscode”:998,“message”:“Invalid query, please check the syntax. API specifications are here: http://www.freedesktop.org/wiki/Specifications/open-collaboration-services. DEBUG OUTPUT:\n”},“data”: }}
Query String parameters:
format:json
search:test
perPage:200
itemType:folder
Request info:
Request URL:https://ra10.domain.com/ocs/v1.php/apps/files_sharing/api/v1/sharees?format=json&search=fdsf&perPage=200&itemType=folder
Request Method:GET
Status Code:200 OK
Remote Address:10.73.1.30:443
Referrer Policy:no-referrer
Thanks in advance!
tflidd
June 14, 2017, 9:56pm
2
There is the same message on an existing bug report:
opened 04:47AM - 12 Feb 17 UTC
closed 03:04PM - 15 Aug 17 UTC
needs info
feature: sharing
<!--
Thanks for reporting issues back to Nextcloud! This is the issue tracker o… f Nextcloud, if you have any support question please check out https://nextcloud.com/support
This is the bug tracker for the Server component. Find other components at https://github.com/nextcloud/
For reporting potential security issues please see https://nextcloud.com/security/
To make it possible for us to help you please fill out below information carefully.
-->
### Steps to reproduce
1. Enable share by mail
2. Try and share a folder
3. Name resolution does not show and therefore can't not share
### Expected behaviour
When share by mail is disabled name lookup works and I am able to share a folder
### Actual behaviour
No name resolution so unable to share even if type name correctly.
### Server configuration
**Operating system**:
Ubuntu Server 16.04
**Web server:**
Apache
**Database:**
MySQ
**PHP version:**
7
**Nextcloud version:** (see Nextcloud admin page)
11.0.1
**Updated from an older Nextcloud/ownCloud or fresh install:**
Updated from fresh 11
**Where did you install Nextcloud from:**
Nextcloud VM/Repos
**Are you using external storage, if yes which one:** local/smb/sftp/...
local
**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:**
Chrome
**Operating system:**
OSX/Windows 10
### Logs
#### Browser log
<details>
<summary>Browser log</summary>
```
This is what the browser response is when it requests a search using the API
{"ocs":{"meta":{"status":"failure","statuscode":998,"message":"Invalid query, please check the syntax. API specifications are here: http://www.freedesktop.org/wiki/Specifications/open-collaboration-services. DEBUG OUTPUT:\n"},"data":[]}}
```
</details>
More information is required for developers that they can reproduce this problem.
Yes, but is not my situation because I have turned off Share By Mail and my version is 12… I think is a diferent problem…
I found this error in the background…
Base table or view not found: 1146 Table ‘nextcloud.oc_addressbooks’ doesn’t exist"
So… I run in linux
grep -ri 'create table address' *
And I founded the SQL statement in apps/dav/appinfo/database.xml
CREATE TABLE oc_addressbooks (
id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
principaluri VARBINARY(255),
displayname VARCHAR(255),
uri VARBINARY(200),
description TEXT,
synctoken INT(11) UNSIGNED NOT NULL DEFAULT '1',
UNIQUE(principaluri(100), uri(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
What’s apps/dav/?? I dont know… but I enabled it by console running
php occ app:enable dav
And problem solved!