Back
1.5.4 migration error - Invalid query: Invalid cursor
I have previously successfully migrated an identical copy of this Appwrite instance to 1.5 and had no issues but now I've tried to upgrade I'm getting this error during the migration:
TypeScript
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 underscore. Can't start with a leading underscore in /usr/src/code/vendor/utopia-php/database/src/Database/Database.php:4694
Stack trace:
#0 /usr/src/code/src/Appwrite/Migration/Migration.php(221): Utopia\Database\Database->find(Object(Utopia\Database\Document), Array)
#1 /usr/src/code/src/Appwrite/Migration/Migration.php(171): Appwrite\Migration\Migration->documentsIterator('cache')
#2 [internal function]: Appwrite\Migration\Migration->Appwrite\Migration\{closure}(Array, Array)
#3 {main}
thrown in /usr/src/code/vendor/utopia-php/database/src/Database/Database.php on line 4694
TL;DR
Developers are encountering an 'Invalid cursor' error during a migration to version 1.5.4 of Appwrite due to UIDs exceeding the allowed 36 characters and containing invalid characters. The solution is to truncate UIDs to a maximum of 36 characters and ensure they only include a-z, A-Z, 0-9, and underscores.