violet gorge
As said above, Im trying to upload a json string to my database. However i get the following error:
Uncaught (in promise) AppwriteException: Invalid document structure: Attribute "JSONFile" has invalid type. Value must be a valid string and no longer than 9999 chars. Im pretty sure the issue is the filesize in this case. Now my question. What is the best workaround for this?
winter sluice
As said above, Im trying to upload a json string to my database. However i get t...
What size have you set on the Attribute?
violet gorge
Code that goes with this btw
export async function WriteSheetToDatabase(FileToSend) {
console.log(FileToSend)
//Make JSON string
const JsonData = JSON.stringify(FileToSend);
let SheetID = FileToSend.SheetID;
const userID = await userId;
if (!userID) {
console.error("Could not find active Session!");
return;
}
const fileObject = {
UserID: userID,
JSONFile: JsonData,
SheetID: SheetID,
};
//If there is already an existing version, overwrite new saveData
if (!SheetID) {
//make document with unique ID.
const Doc = await database.createDocument(
process.env.NEXT_PUBLIC_DATABASE_ID,
process.env.NEXT_PUBLIC_SHEET_COLLECTION_ID,
ID.unique(),
fileObject
);
fileObject.SheetID = Doc.$id;
FileToSend.SheetID = fileObject.SheetID;
fileObject.JSONFile = JSON.stringify(FileToSend);
console.log("Saved CharacterSheet");
//Grab doc and grab the $id which is uniqueID. add said ID to to FileToSend.SheetID;
if (fileObject.SheetID !== null) {
await database.updateDocument(
process.env.NEXT_PUBLIC_DATABASE_ID,
process.env.NEXT_PUBLIC_SHEET_COLLECTION_ID,
fileObject.SheetID,
fileObject
);
} else {
console.error("SheetID is null");
}
}
also this only happens when i try to console.log() the data out.
violet gorge
What size have you set on the Attribute?
9999
violet gorge
yes its: 9011
though I will go over that 9999 when i update the app further
so i need to find a way around it
I am self hosting so if anything needs to be changed i can do that
winter sluice
so i need to find a way around it
Changing the maximum length of an Attribute is not currently supported, so you'll have to delete and recreate the Attribute with a longer max length - you'll probably want to do that before you go into production and have data you don't want to lose
violet gorge
Yeah fair enough. What is the max i can set it to though?
kinda thought i was pushing it with that length
winter sluice
yes its: 9011
If you check the length after the JSON.stringify(), this is accurate?
winter sluice
Yeah fair enough. What is the max i can set it to though?
It's pretty high - I don't remember off the top of my head, but I'm pretty sure it's more than 8 digits
winter sluice
this is the result if i get json stringify
Yeah, that's 9000
violet gorge
Yeah im not sure why it was giving me errors too be honest. Seems to be working fine now. Just cant console.log the object. have to use json stringify
winter sluice
Yeah im not sure why it was giving me errors too be honest. Seems to be working ...
Wait, the error only shows up when you console.log(JsonData)?!
violet gorge
yeah
well before i stringify.
so if i console.log(fileobject)
it shows up and same goes with fileToSend
winter sluice
yeah
No other changes to the code whatsover - the only addition is exactly console.log(FileToSend)?
winter sluice
which now somehow also seems to work???? im getting so confused..
Is it possible the string being passed in before was different?
violet gorge
Shouldnt be.
winter sluice
You mentioned above that it was 9011 characters, but the one you posted here was only 9000