Thank you for using Codebook and for posting on discuss, although I’m sorry to hear about the ditto_replicate issue during sync. This error points to corruption within the table that’s used to “smartly” track and exchange changes between Codebook clients during the sync process.
Could I ask if one of your devices is most up-to-date (i.e. has all the most recent changes you’ve made to your Codebook data on it)?
The reason I ask, is because if there is, the easiest way to resolve this issue would be to replace all other database with this most up-to-date database which will “skip over” this issue.
It sounds as if you’re using Desktop WiFi sync – is that correct? And you mentioned that the correct password is on the iOS version, is your iOS version the most up-to-date?
If that’s the case, here are the steps I would recommend taking:
- Manually take a backup of your Desktop database (as an added precaution just in case we end up overwriting it and then you realize that there was something on there that hadn’t been synced). – On Codebook for Mac you can take a backup through File > Backups > Backup, On Codebook for Windows you can take a backup through File > Database Info > Backups tab > Backup now.
- On your iPhone, visit the sync view, set the operation to “Overwrite” the mode to “Desktop WiFi” and select your Desktop, then tap start – This will replace your Desktop database with your iPhone database.
- After the overwrite is complete, switch the operation back to sync, try making a test change to both Codebook for Desktop and Codebook for iOS and ensure that you’re able to perform a regular sync operation without the error anymore.
Do you use Codebook on any additional devices as well? I can provide further instructions for overwriting other devices depending on which sync method you’re using if needed.
Let me know if these steps allow you to sync properly again, and if you have any further questions along the way. Thanks!