WebCloud

cannot create 2 relationships with the same collection

Aug 29, 2024, 18:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

yuvrajOriginal post

Rank 1: Thread

Aug 29, 2024, 17:33

JavaScript

export type DelayedDowngradeSchema = Models.Document & {
    planFrom: PlanSchema;
    planTo: PlanSchema;
    effectiveDate: Date;
    subscription: SubscriptionSchema;
}

JavaScript

 await this.databases.createCollection(databaseId, delayedDowngradeCollectionId, "DelayedDowngrades");
        await this.databases.createRelationshipAttribute(databaseId, delayedDowngradeCollectionId, planCollectionId, RelationshipType.ManyToOne, false, "planFrom");
        await this.databases.createRelationshipAttribute(databaseId, delayedDowngradeCollectionId, planCollectionId, RelationshipType.ManyToOne, false, "planTo");
        await this.databases.createDatetimeAttribute(databaseId, delayedDowngradeCollectionId, "effectiveDate", true);
        await this.databases.createRelationshipAttribute(databaseId, delayedDowngradeCollectionId, subscriptionCollectionId, RelationshipType.OneToOne, false, "subscription");

i keep getting error ⨯ AppwriteException: Attribute with the requested key already exists. Attribute keys must be unique, try again with a different key.
i set the keys planFrom and planTo which are different
plans can be free/standard/professional

Summary

Issue: Developers are trying to create 2 relationships with the same collection but encountering an error stating that the attribute keys must be unique. Solution: The error is due to trying to create relationships with the same key names (`planFrom` and `planTo`) pointing to the `planCollectionId`. To resolve this, ensure that the attribute keys are unique, even if they point to the same collection. Consider using different keys for the relationships despite pointing to the same collection structure.

cannot create 2 relationships with the same collection

Need support?_