Migration Tool Fails with Fatal error: Uncaught Utopia\Database\Exception\Query
- 0
- Self Hosted
- Databases
From 1.4.x to 1.5.7 getting the following error:
Migrating Collection attributes:
100 / 213
Fatal error: Uncaught Utopia\Database\Exception\Query: Invalid query: Invalid cursor: UID must contain at most 36 chars. Valid chars are a-z, A-Z, 0-9, and undersc ore. Can't start with a leading underscore in :0
Stack trace:
#0 /usr/src/code/src/Appwrite/Migration/Migration.php(224): Utopia\Database\Database->find(Object(Utopia\Database\Document), Array)
#1 /usr/src/code/src/Appwrite/Migration/Migration.php(174): Appwrite\Migration\Migration->documentsIterator('attributes')
#2 [internal function]: Appwrite\Migration\Migration->Appwrite\Migration\{closure}(Array, Array)
#3 {main}
thrown in Unknown on line 0
The key value is tax_identification_number_dependent and has 35 chars, but _uid value has more beacuse of prefix 1_11_ and became 1_11_tax_identification_number_dependent
We tried to delete this attribute and recreate it with a samaller name, but unsuccessfully. We tried to delete and recreate the colletion, but it stills in DB.
Any ideias?
I don't know if it's necessary, but did you upgrade directly to 1.5.7 or did you go through the intermediate updates?
because I believe there are some updates inbetween 1.4.x and 1.5.7 that require the mirgate command
I believe i can upgrade from 1.4.x to 1.5.x coz its a immediately higher version. https://appwrite.io/docs/advanced/self-hosting/update
Recommended threads
- THE COLUMNS STUCK ON PROCESSING HOW DO I...
I HAVE SELF HOSTED THE APPWRITE ON VPS
- Update row sheet not loading
After right clicking a row header and click update, the sidebar fails to load (never-ending skeleton)
- Impossible to create project via CLI?
Is it possible to create a new project via the appwrite CLI ? I need to create a few projects for something I'm working on and because i don't want to do it man...