Rank 3: Container
I was trying to create a new document in Appwrite Database, it was working fine but suddenly started giving me "Server Error"
I've self hosted on version 1.3.1
Votes
0
Replies
24
Participants
Unknown
Messages
25
Rank 3: Container
I was trying to create a new document in Appwrite Database, it was working fine but suddenly started giving me "Server Error"
I've self hosted on version 1.3.1
Admin
Check the docker logs for your appwrite container
Rank 3: Container
what is the command for that?
Admin
Rank 3: Container
done
Rank 3: Container
I can now add from console
Rank 3: Container
but still getting the same error in from function
Rank 3: Container
Only SMTP is down, because I've configured it
Admin
Make sure you're looking at logs for the right container and then find the log entry related to the server error
Rank 3: Container
Which container I should look for in this case?
Admin
Btw, you should really upgrade Appwrite to 1.3.4 and run the migrate command
Admin
Rank 3: Container
umm understood, I was just thinking about this.
Rank 3: Container
I understood the error, but why this error.
paymentStatus is an enum. And I added a new Enum by editing this attribute, which was a bit long than the others. Do you think mariadb registered the following enum length and now any enum greater than that length would be forbidden?
Rank 3: Container
done \✅
Rank 3: Container
ahh its working now, this was the issue YES.
Rank 3: Container
Steven, we should tell people to not add Enums greater than the highest length already present in that attribute.
eg:
paymentStatus Attrib has
Success - Pending - FailureIntiated this won't work, because mariaDB has already taken the highest length of Pending and Failure that is 7.Admin
Would you please create an issue for this?
Rank 3: Container
tomorrow morning first thing :)
Rank 3: Container
Rank 4: Virtual Machine
Wrong copy paste : https://github.com/appwrite/appwrite/issues/5595
Rank 4: Virtual Machine
@Nimit Savant While you're waiting for a fix, you can modify the attribute length by editing the field directly in the database.
Rank 3: Container
oops
Rank 3: Container
yes but I'll have to go into mariabDB and do that, I found a fix. I deleted the attribute and made it again
Rank 4: Virtual Machine
Without data you can also do that yes