table already exists (code 1)

来源：互联网发布：数据库模型编辑：程序博客网时间：2024/06/04 19:24

E/AndroidRuntime: FATAL EXCEPTION: main
Process: com.isport.isporttracker, PID: 26015
java.lang.RuntimeException: Unable to start service com.isport.isporttracker.MainService@119ea48 with Intent { cmp=com.isport.isporttracker/.MainService VirtualScreenParam=Params{mDisplayId=-1, null, mFlags=0x00000000)} }: android.database.sqlite.SQLiteException: table 'historySport' already exists (code 1): , while compiling: Create table 'historySport'('dateString' varchar(50) not null,'mac' varchar(30) not null,'stepNum' int,'sleepState' int,PRIMARY KEY ('dateString','mac'));
#################################################################
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(table 'historySport' already exists (code 1): , while compiling: Create table 'historySport'('dateString' varchar(50) not null,'mac' varchar(30) not null,'stepNum' int,'sleepState' int,PRIMARY KEY ('dateString','mac'));)
#################################################################
at android.app.ActivityThread.handleServiceArgs(ActivityThread.java:4080)
at android.app.ActivityThread.access$2400(ActivityThread.java:222)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1898)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:158)
at android.app.ActivityThread.main(ActivityThread.java:7229)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
Caused by: android.database.sqlite.SQLiteException: table 'historySport' already exists (code 1): , while compiling: Create table 'historySport'('dateString' varchar(50) not null,'mac' varchar(30) not null,'stepNum' int,'sleepState' int,PRIMARY KEY ('dateString','mac'));
#################################################################
Error Code : 1 (SQLITE_ERROR)
Caused By : SQL(query) error or missing database.
(table 'historySport' already exists (code 1): , while compiling: Create table 'historySport'('dateString' varchar(50) not null,'mac' varchar(30) not null,'stepNum' int,'sleepState' int,PRIMARY KEY ('dateString','mac'));)
#################################################################
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1058)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:623)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1812)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1743)
at com.isport.isportlibrary.database.DatabaseHelper.onCreate(DatabaseHelper.java:41)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
at com.isport.isportlibrary.database.DatabaseHelper.query(DatabaseHelper.java:67)
at com.isport.isportlibrary.database.DatabaseHelper.query(DatabaseHelper.java:74)
at com.isport.isportlibrary.database.DbBaseDevice.findAll(DbBaseDevice.java:107)
at com.isport.isportlibrary.services.BleService.getHistoryDevice(BleService.java:215)
at com.isport.isportlibrary.services.BleService.initDb(BleService.java:224)
at com.isport.isportlibrary.services.BleService.onStartCommand(BleService.java:181)
at com.isport.isporttracker.MainService.onStartCommand(MainService.java:43)
at android.app.ActivityThread.handleServiceArgs(ActivityThread.java:4063)

... 8 more

出现上述错误，很有可能是表名重复了

0 0