۱۳۹۳/۰۷/۰۳, ۱۲:۲۷ ق.ظ
باسلام
برنامه ای با استفاده از دیتابیس نوشتم ولی متاسفانه اون رو اجرا نمیکنه ارور های اون به شرح ذیل است :
* اسم جدول دیتابیس من هم Love هست .
لطفا راهنمایی کنید .
برنامه ای با استفاده از دیتابیس نوشتم ولی متاسفانه اون رو اجرا نمیکنه ارور های اون به شرح ذیل است :
کد پی‌اچ‌پی:
09-24 20:05:58.956: D/dalvikvm(3952): GC_FOR_ALLOC freed 69K, 4% free 7961K/8259K, paused 13ms, total 13ms
09-24 20:05:58.964: I/dalvikvm-heap(3952): Grow heap (frag case) to 15.849MB for 8370940-byte allocation
09-24 20:05:58.976: D/dalvikvm(3952): GC_FOR_ALLOC freed <1K, 2% free 16135K/16455K, paused 12ms, total 12ms
09-24 20:05:58.976: D/dalvikvm(3952): GC_CONCURRENT freed 1K, 2% free 16135K/16455K, paused 1ms+1ms, total 3ms
09-24 20:05:59.160: D/libEGL(3952): loaded /system/lib/egl/libEGL_emulation.so
09-24 20:05:59.160: D/(3952): HostConnection::get() New Host Connection established 0xb789a240, tid 3952
09-24 20:05:59.168: D/libEGL(3952): loaded /system/lib/egl/libGLESv1_CM_emulation.so
09-24 20:05:59.168: D/libEGL(3952): loaded /system/lib/egl/libGLESv2_emulation.so
09-24 20:05:59.252: W/EGL_emulation(3952): eglSurfaceAttrib not implemented
09-24 20:05:59.260: D/OpenGLRenderer(3952): Enabling debug mode 0
09-24 20:05:59.324: W/EGL_emulation(3952): eglSurfaceAttrib not implemented
09-24 20:05:59.448: D/OpenGLRenderer(3952): TextureCache::get: create texture(0xb78c8f38): name, size, mSize = 1, 8370928, 8370928
09-24 20:06:02.188: E/SQLiteLog(3952): (1) near ")": syntax error
09-24 20:06:02.188: W/System.err(3952): android.database.sqlite.SQLiteException: near ")": syntax error (code 1): , while compiling: CREATE TABLE Love(id INTEGER PRIMARY KEY NOT NULL,khande INTEGER NOT NULL DEFAULT 0, fav INTEGER NOT NULL DEFAULT 0, onvan TEXT, matn TEXT, manba TEXT, )
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteProgram.<init>;(SQLiteProgram.java:58)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteStatement.<init>;(SQLiteStatement.java:31)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
09-24 20:06:02.192: W/System.err(3952): at ir.Reyhaneh.database.DBAdapter$DatabaseHelper.onCreate(DBAdapter.java:69)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
09-24 20:06:02.192: W/System.err(3952): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
09-24 20:06:02.192: W/System.err(3952): at ir.Reyhaneh.database.DBAdapter.open(DBAdapter.java:91)
09-24 20:06:02.192: W/System.err(3952): at ir.Reyhaneh.AkharZaman.MainActivity.onCreate(MainActivity.java:47)
09-24 20:06:02.192: W/System.err(3952): at android.app.Activity.performCreate(Activity.java:5008)
09-24 20:06:02.192: W/System.err(3952): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
09-24 20:06:02.192: W/System.err(3952): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)
09-24 20:06:02.192: W/System.err(3952): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
09-24 20:06:02.192: W/System.err(3952): at android.app.ActivityThread.access$600(ActivityThread.java:130)
09-24 20:06:02.192: W/System.err(3952): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
09-24 20:06:02.192: W/System.err(3952): at android.os.Handler.dispatchMessage(Handler.java:99)
09-24 20:06:02.192: W/System.err(3952): at android.os.Looper.loop(Looper.java:137)
09-24 20:06:02.192: W/System.err(3952): at android.app.ActivityThread.main(ActivityThread.java:4745)
09-24 20:06:02.192: W/System.err(3952): at java.lang.reflect.Method.invokeNative(Native Method)
09-24 20:06:02.192: W/System.err(3952): at java.lang.reflect.Method.invoke(Method.java:511)
09-24 20:06:02.192: W/System.err(3952): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
09-24 20:06:02.192: W/System.err(3952): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
09-24 20:06:02.192: W/System.err(3952): at dalvik.system.NativeStart.main(Native Method)
09-24 20:06:02.192: I/FullBook Esfandune(3952): 3
09-24 20:06:02.196: E/SQLiteLog(3952): (1) no such table: Love
09-24 20:06:02.196: D/AndroidRuntime(3952): Shutting down VM
09-24 20:06:02.196: W/dalvikvm(3952): threadid=1: thread exiting with uncaught exception (group=0xa622a288)
09-24 20:06:02.196: E/AndroidRuntime(3952): FATAL EXCEPTION: main
09-24 20:06:02.196: E/AndroidRuntime(3952): java.lang.RuntimeException: Unable to start activity ComponentInfo{ir.Reyhanehsoft.blog.Love_Famouse/ir.Reyhaneh.AkharZaman.MainActivity}: android.database.sqlite.SQLiteException: no such table: Love (code 1): , while compiling: SELECT id, onvan, matn, manba, fav, khande FROM Love
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2059)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.ActivityThread.access$600(ActivityThread.java:130)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.os.Handler.dispatchMessage(Handler.java:99)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.os.Looper.loop(Looper.java:137)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.ActivityThread.main(ActivityThread.java:4745)
09-24 20:06:02.196: E/AndroidRuntime(3952): at java.lang.reflect.Method.invokeNative(Native Method)
09-24 20:06:02.196: E/AndroidRuntime(3952): at java.lang.reflect.Method.invoke(Method.java:511)
09-24 20:06:02.196: E/AndroidRuntime(3952): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
09-24 20:06:02.196: E/AndroidRuntime(3952): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
09-24 20:06:02.196: E/AndroidRuntime(3952): at dalvik.system.NativeStart.main(Native Method)
09-24 20:06:02.196: E/AndroidRuntime(3952): Caused by: android.database.sqlite.SQLiteException: no such table: Love (code 1): , while compiling: SELECT id, onvan, matn, manba, fav, khande FROM Love
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteProgram.<init>;(SQLiteProgram.java:58)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteQuery.<init>;(SQLiteQuery.java:37)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1161)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1032)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1200)
09-24 20:06:02.196: E/AndroidRuntime(3952): at ir.Reyhaneh.database.DBAdapter.getAllContacts(DBAdapter.java:119)
09-24 20:06:02.196: E/AndroidRuntime(3952): at ir.Reyhaneh.AkharZaman.MainActivity.onCreate(MainActivity.java:49)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.Activity.performCreate(Activity.java:5008)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
09-24 20:06:02.196: E/AndroidRuntime(3952): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)
09-24 20:06:02.196: E/AndroidRuntime(3952): ... 11 more
* اسم جدول دیتابیس من هم Love هست .
لطفا راهنمایی کنید .
