AppwriteException: document_already_exists, Document with the requested ID already exists. (409)
- 0
- Databases
- Flutter
- Cloud

Why I got this error I used this code:
final id = ID.unique();
_logger.info('Creating service overview for user $userId');
response = await database.createDocument(
databaseId: serviceCredential.databaseId,
collectionId: serviceCredential.collectionId,
documentId: id,
data: data,
permissions: [
Permission.read(Role.any()),
Permission.write(Role.user(userId)),
Permission.update(Role.user(userId)),
Permission.delete(Role.user(userId)),
],
);
As you can see I used an ID unique but still I got document_already exist in my appwrite cloud . I just have only one document in my collection

Maybe other attributes are unique?

But when I deleting the document it fix the error

If for example the name is unquie And you're trying to insert another one with the same name

You'll get that error

did you mean is the indexes?


I have this

Yes Exactly

Are the value of serverOwnerId
is unqiue each time or same as the one already inserted

So I re create this index


Yes

what should I choose?>

Key or FullText?


Key will suit your use case

thank you I will try

Ohh it works thank youuu so much

Except the cloud, after version 1.3.0 the key is not for allowing queries any more but to enhanced the filtering based on those attributes
Recommended threads
- Is it possible to getRow with all relati...
With the new Opt-In relationship loading, is it possible to query getRow to get all attributes and relationships and possibly even cascading relationships? I tr...
- TableDB.getRow() response does not conta...
This is for Web/React sdk 20.0.0 The row was created via `TableDB.createRow(...)` and I can see it in the console with the relationships correctly set. In the c...
- Permissions for bulk operation
Hi team, I have a question: βIn the databases.createDocuments bulk API, can I set document-level permissions? If yes, how exactly should I include the permissio...
