AutoSync doesn't work

[rdethurens]

Hi,
First, thanks a lot for your work.
I'm experiencing a trouble with the "autoSchemaSync: true". It seems that it doesn't work nor in webBrowser nor on android Device. Each time i add a column i get this SQLError code : 5 /message : "could not prepare statement (1 no such column: EntityName.ColumnName)". I tried to use the ionic-orm test and it seems to have the same issue.

Any idea ?

Thanks in advance.

[jase88]

Same here on websql

[bolivir]

Can confirm this problem (websql). If you change something on the schema, and then run you're app it will throw a sql object error.
After wiping the DB the app wil run as expected.

This is a big problem when giving out updates where DB changes are required, are there any ways to it manually without the user losing his data?

[rdethurens]

Hi, I found a solution by changing some code. But i don't commit my changes to github. (I never do this so it will take time for me, and haven't yet). Hope, i work on it next week.

[mo-ba]

any progress?
#14

[rdethurens]

I Update the component :
Enable AutoSync On SQLite
Enable AutoSync On WebWSql With issues : Always recreate Table / Just Add Column supported Not Update and Delete

available with npm instal ionic-orm3