My user can not sync his changes, because he had unsaved changed on a previous version

[Arnaud_T]

Hi,

I added yesterday 2 new columns to my app and updated the stable version of the app from 280 to 291. I did not warn one user, and he did not pay attention to the fact that his changes were stuck on his device. He used this app a looot today and eventually realised there is 120 sync pending. When he tried to force the synchronisation, he gets the classic error 'There is a mismatch in the number of columns between the spreadsheet for Pieces_a_remplacer and the table schema. The table has 11 columns but the schema has 9 columns. Please regenerate the table column structure.\n\nError: Data table 'ControlePIBIIvry-1551390:1.000280:Pieces_a_remplacer' is not available'. He disconnected and reconnected from the app but nothing changed.

I activated the recovery mode => not working. I asked him to go to the page "Show changes" so at least i can copy his data but he tells me that it redirect him to the homepage of the app. Anyway i also need him to save the photos he took so it would not be a perfect solution.

He must not reset his data as we use the app as a proof for our client that we did some work and we are paid based on it. 

The weirdest point is that on the 'About' page, the app version is "1.000291", which is the recent version.

Any idea on how to solve this situation ?

[AleksiAlkio]

Have you checked is there already a Recovery folder within the root folder for this app?

[Arnaud_T]

There is one but files in this fold are several months old

[AleksiAlkio]

What do you mean by "homepage of the app" exactly? Or is it just one view from the same app?

[Arnaud_T]

Yes it is one view of the same app.

[AleksiAlkio]

Both of these are very weird. And silly question, after you set the recovery mode ON, the user has tried to sync the app couple of times?

[Arnaud_T]

Yes he did try to sync after i set it on, several times as he's still using the app even today.

[AleksiAlkio]

Please file a support ticket as something is wrong if it doesn't save the data with the recovery mode.

[Metworks_IT1 · Accepted solution]

i have this occasionally,  what i do, i make a copy of the table, then delete the data and the two new columns added, sync until the point it picks up the change, then add the data and columns back, continue syncing till the end.

[Arnaud_T]

I thought about it but i did not know if it would require him to disconnect / reconnect and i really do not want him to lose the local data. I'm gonna try it and just ask him to sync until it works. I will let you know if it works, thanks 

[Metworks_IT1]

should work,  just keep an eye of any other users you might have writing to the table in same time. i learned it the hard way...