Skip to content
Back

Error importing data after server migration

  • 0
  • Self Hosted
  • Databases
  • Web
  • Cloud
tomlit
7 Aug, 2025, 03:07

Hello, I recently purchased a new web server and when trying to migrate my data from the old server to the new (both self-hosted instances of appwrite on coolify) I get errors when trying to migrate document. I also tried importing the data using the cloud to see if it was an issue with the servers but it failed on the cloud as well. This is the error I'm currently seeing - ```

{ "$id": "689414fb168ee4eaa96e", "$createdAt": "2025-08-07T02:52:43.093+00:00", "$updatedAt": "2025-08-07T02:55:17.033+00:00", "status": "failed", "stage": "finished", "source": "Appwrite", "destination": "Appwrite", "resources": [ "database", "collection", "attribute", "index", "document" ], "resourceId": "", "statusCounters": { "database": { "pending": 0, "success": 2, "error": 0, "skip": 0, "processing": 0, "warning": 0 }, "collection": { "pending": 0, "success": 24, "error": 0, "skip": 0, "processing": 0, "warning": 0 }, "attribute": { "pending": 0, "success": 237, "error": 0, "skip": 0, "processing": 0, "warning": 0 }, "index": { "pending": 0, "success": 35, "error": 0, "skip": 0, "processing": 0, "warning": 0 }, "document": { "pending": 0, "success": 118645, "error": 2, "skip": 0, "processing": 0, "warning": 0 } }, "resourceData": [], "errors": [ { "code": 0, "message": "Invalid document structure: Missing required attribute status" }, { "code": 500, "message": "SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens" } ] }```

How can I get my data properly migrated over without these errors? I'm currently unable to see some critical data in several of my collections.

TL;DR
Developers are facing errors when trying to import data after server migration, specifically related to migrating 'document'. The error log mentions missing required attributes and SQL parameter issues. To resolve the problem, developers should ensure that the document structure is valid with all necessary attributes included, and verify that the number of bound variables matches the number of tokens in SQL queries for successful migration.
tomlit
7 Aug, 2025, 03:14

The original app ID with the correct data is 67c1dbc30019aa814e4d and I'm trying to transfer it to 6892ec5b0020565cf738. The cloud ID I used for testing importing is 68941310002465bb7e10

tomlit
7 Aug, 2025, 03:17

here's an error log from the new server when trying to import:

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more