search

pardom-zz / ActiveAndroid

Active record style SQLite persistence for Android
http://www.activeandroid.com
4.7k stars 1.03k forks source link

Another error when db upgrade: executeLegacySqlScript #486

Open MrEko opened 8 years ago

MrEko commented 8 years ago

The strange thing is that this error is reported only by 1% of users. So I believe it is not a syntax error.

Any ideias?

Caused by: android.database.sqlite.SQLiteException: near "INSERT": syntax error at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method) at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:90) at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1899) at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1839) at com.activeandroid.DatabaseHelper.executeLegacySqlScript(DatabaseHelper.java:247) at com.activeandroid.DatabaseHelper.executeSqlScript(DatabaseHelper.java:212) at com.activeandroid.DatabaseHelper.executeMigrations(DatabaseHelper.java:178) at com.activeandroid.DatabaseHelper.onUpgrade(DatabaseHelper.java:85) at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:170) at com.activeandroid.Cache.openDatabase(Cache.java:106) at com.activeandroid.Cache.initialize(Cache.java:75) at com.activeandroid.ActiveAndroid.initialize(ActiveAndroid.java:44) at com.activeandroid.ActiveAndroid.initialize(ActiveAndroid.java:34) at com.activeandroid.content.ContentProvider.onCreate(ContentProvider.java:39)