Skip to content

Instantly share code, notes, and snippets.

@jokamjohn
Created March 30, 2015 20:27
Show Gist options
  • Save jokamjohn/8fb9c05ac8a77d1f77cc to your computer and use it in GitHub Desktop.
Save jokamjohn/8fb9c05ac8a77d1f77cc to your computer and use it in GitHub Desktop.
Have failed to create table
03-30 18:55:02.112 2156-2156/com.example.android.database I/art﹕ Late-enabling -Xcheck:jni
03-30 18:55:04.163 2156-2156/com.example.android.database E/SQLiteLog﹕ (1) near "TABLETEMPERATURES": syntax error
03-30 18:55:04.257 2156-2156/com.example.android.database D/AndroidRuntime﹕ Shutting down VM
03-30 18:55:04.302 2156-2156/com.example.android.database E/AndroidRuntime﹕ FATAL EXCEPTION: main
Process: com.example.android.database, PID: 2156
java.lang.RuntimeException: Unable to resume activity {com.example.android.database/com.example.android.database.Ui.MainActivity}: android.database.sqlite.SQLiteException: near "TABLETEMPERATURES": syntax error (code 1): , while compiling: CREATE TABLETEMPERATURES (_IDINTEGER PRIMARY KEYTEMPERATUREREAL)
at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2951)
at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2982)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2365)
at android.app.ActivityThread.access$800(ActivityThread.java:144)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1278)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:135)
at android.app.ActivityThread.main(ActivityThread.java:5221)
at java.lang.reflect.Method.invoke(Native Method)
at java.lang.reflect.Method.invoke(Method.java:372)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:899)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:694)
Caused by: android.database.sqlite.SQLiteException: near "TABLETEMPERATURES": syntax error (code 1): , while compiling: CREATE TABLETEMPERATURES (_IDINTEGER PRIMARY KEYTEMPERATUREREAL)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
at com.example.android.database.Database.ForecastHelper.onCreate(ForecastHelper.java:27)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
at com.example.android.database.Database.ForecastDataSource.open(ForecastDataSource.java:26)
at com.example.android.database.Ui.MainActivity.onResume(MainActivity.java:57)
at android.app.Instrumentation.callActivityOnResume(Instrumentation.java:1241)
at android.app.Activity.performResume(Activity.java:6019)
at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2940)
            at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2982)
            at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2365)
            at android.app.ActivityThread.access$800(ActivityThread.java:144)
            at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1278)
            at android.os.Handler.dispatchMessage(Handler.java:102)
            at android.os.Looper.loop(Looper.java:135)
            at android.app.ActivityThread.main(ActivityThread.java:5221)
            at java.lang.reflect.Method.invoke(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:372)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:899)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:694)
03-30 19:01:10.186 2505-2505/com.example.android.database E/SQLiteLog﹕ (1) near "TABLETEMPERATURES": syntax error
03-30 19:01:10.228 2505-2505/com.example.android.database D/AndroidRuntime﹕ Shutting down VM
03-30 19:01:10.285 2505-2505/com.example.android.database E/AndroidRuntime﹕ FATAL EXCEPTION: main
Process: com.example.android.database, PID: 2505
java.lang.RuntimeException: Unable to resume activity {com.example.android.database/com.example.android.database.Ui.MainActivity}: android.database.sqlite.SQLiteException: near "TABLETEMPERATURES": syntax error (code 1): , while compiling: CREATE TABLETEMPERATURES (_ID INTEGER PRIMARY KEY,TEMPERATURE REAL)
at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2951)
at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2982)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2365)
at android.app.ActivityThread.access$800(ActivityThread.java:144)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1278)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:135)
at android.app.ActivityThread.main(ActivityThread.java:5221)
at java.lang.reflect.Method.invoke(Native Method)
at java.lang.reflect.Method.invoke(Method.java:372)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:899)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:694)
Caused by: android.database.sqlite.SQLiteException: near "TABLETEMPERATURES": syntax error (code 1): , while compiling: CREATE TABLETEMPERATURES (_ID INTEGER PRIMARY KEY,TEMPERATURE REAL)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1674)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1605)
at com.example.android.database.Database.ForecastHelper.onCreate(ForecastHelper.java:28)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)
at com.example.android.database.Database.ForecastDataSource.open(ForecastDataSource.java:26)
at com.example.android.database.Ui.MainActivity.onResume(MainActivity.java:57)
at android.app.Instrumentation.callActivityOnResume(Instrumentation.java:1241)
at android.app.Activity.performResume(Activity.java:6019)
at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2940)
            at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2982)
            at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2365)
            at android.app.ActivityThread.access$800(ActivityThread.java:144)
            at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1278)
            at android.os.Handler.dispatchMessage(Handler.java:102)
            at android.os.Looper.loop(Looper.java:135)
            at android.app.ActivityThread.main(ActivityThread.java:5221)
            at java.lang.reflect.Method.invoke(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:372)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:899)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:694)
03-30 19:26:15.305 2805-2826/com.example.android.database D/OpenGLRenderer﹕ Render dirty regions requested: true
03-30 19:26:15.562 2805-2805/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c60280, tid 2805
03-30 19:26:15.626 2805-2805/com.example.android.database D/Atlas﹕ Validating map...
03-30 19:26:15.763 2805-2826/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libEGL_emulation.so
03-30 19:26:15.767 2805-2826/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv1_CM_emulation.so
03-30 19:26:15.813 2805-2826/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv2_emulation.so
03-30 19:26:15.836 2805-2826/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c604e0, tid 2826
03-30 19:26:15.935 2805-2826/com.example.android.database I/OpenGLRenderer﹕ Initialized EGL, version 1.4
03-30 19:26:16.009 2805-2826/com.example.android.database D/OpenGLRenderer﹕ Enabling debug mode 0
03-30 19:26:16.062 2805-2826/com.example.android.database W/EGL_emulation﹕ eglSurfaceAttrib not implemented
03-30 19:26:16.062 2805-2826/com.example.android.database W/OpenGLRenderer﹕ Failed to set EGL_SWAP_BEHAVIOR on surface 0xa5c14380, error=EGL_SUCCESS
03-30 19:26:16.553 2805-2805/com.example.android.database I/Choreographer﹕ Skipped 48 frames! The application may be doing too much work on its main thread.
03-30 19:53:57.331 3353-3353/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c6b280, tid 3353
03-30 19:53:57.347 3353-3353/com.example.android.database D/Atlas﹕ Validating map...
03-30 19:53:57.597 3353-3368/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libEGL_emulation.so
03-30 19:53:57.600 3353-3368/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv1_CM_emulation.so
03-30 19:53:57.612 3353-3368/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv2_emulation.so
03-30 19:53:57.622 3353-3368/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c6b6c0, tid 3368
03-30 19:53:57.636 3353-3368/com.example.android.database I/OpenGLRenderer﹕ Initialized EGL, version 1.4
03-30 19:53:57.662 3353-3368/com.example.android.database D/OpenGLRenderer﹕ Enabling debug mode 0
03-30 19:53:57.681 3353-3368/com.example.android.database W/EGL_emulation﹕ eglSurfaceAttrib not implemented
03-30 19:53:57.681 3353-3368/com.example.android.database W/OpenGLRenderer﹕ Failed to set EGL_SWAP_BEHAVIOR on surface 0xa5c36f40, error=EGL_SUCCESS
03-30 20:02:48.668 3727-3727/com.example.android.database I/art﹕ Late-enabling -Xcheck:jni
03-30 20:02:49.225 3727-3742/com.example.android.database D/OpenGLRenderer﹕ Render dirty regions requested: true
03-30 20:02:49.244 3727-3727/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c68280, tid 3727
03-30 20:02:49.253 3727-3727/com.example.android.database D/Atlas﹕ Validating map...
03-30 20:02:49.339 3727-3742/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libEGL_emulation.so
03-30 20:02:49.341 3727-3742/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv1_CM_emulation.so
03-30 20:02:49.409 3727-3742/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv2_emulation.so
03-30 20:02:49.445 3727-3742/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c68770, tid 3742
03-30 20:02:49.464 3727-3742/com.example.android.database I/OpenGLRenderer﹕ Initialized EGL, version 1.4
03-30 20:02:49.515 3727-3742/com.example.android.database D/OpenGLRenderer﹕ Enabling debug mode 0
03-30 20:02:49.546 3727-3742/com.example.android.database W/EGL_emulation﹕ eglSurfaceAttrib not implemented
03-30 20:02:49.546 3727-3742/com.example.android.database W/OpenGLRenderer﹕ Failed to set EGL_SWAP_BEHAVIOR on surface 0xad4f4b40, error=EGL_SUCCESS
03-30 20:08:35.998 3814-3829/com.example.android.database D/OpenGLRenderer﹕ Render dirty regions requested: true
03-30 20:08:36.011 3814-3814/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c68280, tid 3814
03-30 20:08:36.019 3814-3814/com.example.android.database D/Atlas﹕ Validating map...
03-30 20:08:36.078 3814-3829/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libEGL_emulation.so
03-30 20:08:36.080 3814-3829/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv1_CM_emulation.so
03-30 20:08:36.100 3814-3829/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv2_emulation.so
03-30 20:08:36.157 3814-3829/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c68590, tid 3829
03-30 20:08:36.179 3814-3829/com.example.android.database I/OpenGLRenderer﹕ Initialized EGL, version 1.4
03-30 20:08:36.231 3814-3829/com.example.android.database D/OpenGLRenderer﹕ Enabling debug mode 0
03-30 20:08:36.263 3814-3829/com.example.android.database W/EGL_emulation﹕ eglSurfaceAttrib not implemented
03-30 20:08:36.263 3814-3829/com.example.android.database W/OpenGLRenderer﹕ Failed to set EGL_SWAP_BEHAVIOR on surface 0xa5c44dc0, error=EGL_SUCCESS
03-30 20:08:36.778 3814-3814/com.example.android.database I/Choreographer﹕ Skipped 41 frames! The application may be doing too much work on its main thread.
03-30 20:15:41.973 3874-3890/com.example.android.database D/OpenGLRenderer﹕ Render dirty regions requested: true
03-30 20:15:41.990 3874-3874/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c5f280, tid 3874
03-30 20:15:41.998 3874-3874/com.example.android.database D/Atlas﹕ Validating map...
03-30 20:15:42.027 3874-3890/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libEGL_emulation.so
03-30 20:15:42.028 3874-3890/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv1_CM_emulation.so
03-30 20:15:42.049 3874-3890/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv2_emulation.so
03-30 20:15:42.083 3874-3890/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c5f450, tid 3890
03-30 20:15:42.095 3874-3890/com.example.android.database I/OpenGLRenderer﹕ Initialized EGL, version 1.4
03-30 20:15:42.203 3874-3890/com.example.android.database D/OpenGLRenderer﹕ Enabling debug mode 0
03-30 20:15:42.240 3874-3890/com.example.android.database W/EGL_emulation﹕ eglSurfaceAttrib not implemented
03-30 20:15:42.241 3874-3890/com.example.android.database W/OpenGLRenderer﹕ Failed to set EGL_SWAP_BEHAVIOR on surface 0xa5c16f60, error=EGL_SUCCESS
03-30 20:26:31.733 4263-4263/com.example.android.database I/art﹕ Late-enabling -Xcheck:jni
03-30 20:26:32.028 4263-4278/com.example.android.database D/OpenGLRenderer﹕ Render dirty regions requested: true
03-30 20:26:32.047 4263-4263/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c6e2b0, tid 4263
03-30 20:26:32.052 4263-4263/com.example.android.database D/Atlas﹕ Validating map...
03-30 20:26:32.119 4263-4278/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libEGL_emulation.so
03-30 20:26:32.122 4263-4278/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv1_CM_emulation.so
03-30 20:26:32.197 4263-4278/com.example.android.database D/libEGL﹕ loaded /system/lib/egl/libGLESv2_emulation.so
03-30 20:26:32.311 4263-4278/com.example.android.database D/﹕ HostConnection::get() New Host Connection established 0xa5c6e450, tid 4278
03-30 20:26:32.342 4263-4278/com.example.android.database I/OpenGLRenderer﹕ Initialized EGL, version 1.4
03-30 20:26:32.498 4263-4278/com.example.android.database D/OpenGLRenderer﹕ Enabling debug mode 0
03-30 20:26:32.532 4263-4278/com.example.android.database W/EGL_emulation﹕ eglSurfaceAttrib not implemented
03-30 20:26:32.532 4263-4278/com.example.android.database W/OpenGLRenderer﹕ Failed to set EGL_SWAP_BEHAVIOR on surface 0xa5c4ae60, error=EGL_SUCCESS
03-30 20:26:32.666 4263-4263/com.example.android.database I/Choreographer﹕ Skipped 32 frames! The application may be doing too much work on its main thread.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment