Back
[SOLVED] Create document with unique() id and no unique indexes throws document_already_exists
no - everything is ok with my relationships - here is data
TypeScript
{
"name":"Współczesność – o epoce",
"onlyForPremium":false,
"isMediaPremiumOnly":false,
"mainMedia":"https://vimeo.com/855166568",
"mediaType":"video",
"mediaSource":"vimeo",
"mediaThumbnail":"64f5c6fef098d9d485d8",
"mediaContent":"64f5c6ff0ce0bb1785b0",
"slug":null,
"createdBy":null,
"createdById":null,
"updatedBy":null,
"updatedById":null,
"oldTitle":null,
"oldAuthor":null,
"oldCategory":null,
"preview":"word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word",
"metaTitle":null,
"metaDescription":null,
"metaKeywords":null,
"zdayId":"29005",
"content":[
],
"contentIds":null,
"oldId":null,
"assignedToCategories":[
"64f79cced50f0fee7825"
],
"search_name_zdayId":"Współczesność – o epoce 29005"
}
TL;DR
A user was trying to create a document with a unique ID and no unique indexes but encountered the error "document_already_exists." They discovered that the error was caused by a one-to-one relationship between the documents. The solution was to remove the relationship or add a unique index. However, the user suggested that there should be an error log to identify which unique parameter is causing the failure. this is interesting
TypeScript
65 Query START TRANSACTION
65 Query INSERT INTO `appwrite`.`_1_database_1_collection_19`
(`name`, `onlyForPremium`, `isMediaPremiumOnly`, `mainMedia`, `mediaType`, `mediaSource`, `mediaThumbnail`, `mediaContent`, `slug`, `createdBy`, `createdById`, `updatedBy`, `updatedById`, `oldTitle`, `oldAuthor`, `oldCategory`, `preview`, `metaTitle`, `metaDescription`, `metaKeywords`, `zdayId`, `contentIds`, `oldId`, `search_name_zdayId`, `_createdAt`, `_updatedAt`, `_permissions`, _uid) VALUES ('Współczesność – o epoce', 0, 0, 'https://vimeo.com/855166568', 'video', 'vimeo', '64f5c6fef098d9d485d8', '64f5c6ff0ce0bb1785b0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word', NULL, NULL, NULL, '29005', NULL, NULL, 'Współczesność – o epoce 29005', '2023-09-05 21:40:15.225', '2023-09-05 21:40:15.225', '[]', '64f7a03f3663e31c0619')
65 Query ROLLBACK
removing relationship doesn't change anything
shouldn't be there some error log that points out which unique parameter is failing? like unique _uid
ya we need to improve that error
what collection is that? _1_database_1_collection_19 is it supposed to be inserting? I don't think so, right?
how to check that? collection name is content_entry
but content is blank here 🧐
yes. empty list for that one
same for content null
TypeScript
{
"name":"Współczesność – o epoce",
"onlyForPremium":false,
"isMediaPremiumOnly":false,
"mainMedia":"https://vimeo.com/855166568",
"mediaType":"video",
"mediaSource":"vimeo",
"mediaThumbnail":"64f5c6fef098d9d485d8",
"mediaContent":"64f5c6ff0ce0bb1785b0",
"slug":null,
"createdBy":null,
"createdById":null,
"updatedBy":null,
"updatedById":null,
"oldTitle":null,
"oldAuthor":null,
"oldCategory":null,
"preview":"word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word word",
"metaTitle":null,
"metaDescription":null,
"metaKeywords":null,
"zdayId":"29005",
"content":null,
"contentIds":null,
"oldId":null,
"assignedToCategories":null,
"search_name_zdayId":"Współczesność – o epoce 29005"
}
inside appwrite sdk - documentId is unique for sure
ok i found something
when creating document with the same values
1:1 data - it cannot be created event if there is no unique index
ok found it
this is caused by a one to one relationship
and I'm trying to assign manytoone
the assignedToCategories?
mediaThumbnail
and mediaContent
message was just a litle bit misleading
thanks for help!
[SOLVED] Create document with unique() id and no unique indexes throws document_already_exists
