Managed to get my home database on the PC to sync fully with the Android App on the phone (after a while!) and it updated fine the first couple of times I tried it. Then I got the App for my Kindle Fire HD and it didn't seem to want to do the first sync and kept 'stalling' partway through reading the database. At the time I thought it maybe the Kindle as it worked fine on the phone. However next time I tried to update the phone it also stalled at the same point, which made me think...

Now I know it's the most common advice given but in this case it may not be obvious... run a database repair! If there's a glitch in the database you're trying to sync it seems the App can (obviously when you think about it) stall when it reaches the problem.

I ran the Db repair on the PC database and now both devices sync properly with the database on the PC. I hope that this information helps someone who maybe only has one device (and therefore wouldn't notice it's affecting different devices at the same point in the sync cycle).

I have a feeling it's quite common there are small database issues/glitches that don't have an obvious  physical manifestation so you don't notice them in normal use and (and then they get fixed when you ran a Db Repair for a problem you do notice) but the App sync can have trouble with these smaller issues.

Quoting mediadogg:

Quote:
Wise advice. Perhaps change the title of your post to catch attention: "Solve Sync Problems with DB Repair" or something like that.

Done; thanks for the idea!

This is a good tip to try, but it doesn't work for everyone. The next thing to try is to create a new database, copying the data from the old one as you create it. At that point the initial sync worked for me. Updates still don't work, it hangs on copying images, but creating a new database gives me one good sync. Not a big deal since I don't add titles that often.