« назад напред »
Страници: [1] 2

Автор Тема: Андроид Урок 48 - Yarss - 7  (Прочетена 18303 пъти)

0 Потребители и 1 Гост преглежда(т) тази тема.

metost

  • Administrator
  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 41
  • Публикации: 764
Андроид Урок 48 - Yarss - 7
« -: 21 Април 2013, 21:01:11 »
** Тази тема дискутира:: Андроид Урок 48 - Yarss - 7  **
Автор: gatakka
« Последна редакция: 22 Март 2015, 16:56:05 от Avalanche »
Активен
(рɐǝɥ ɹпoʎ uɹпʇ ʇ,uoр)

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #1 -: 26 Април 2013, 02:31:18 »
здр гледах урока много внимателно но ми се появи грешка ето
 
Код: [Маркирай кода]
04-25 23:19:35.885: E/AndroidRuntime(2546): FATAL EXCEPTION: main
04-25 23:19:35.885: E/AndroidRuntime(2546): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.smarfy02.smrss/com.smarfy02.smrss.FeedActivity}: android.database.sqlite.SQLiteException: near "kay": syntax error (code 1): , while compiling: create table feeds(_id intger primary kay autoincrement, feed_url text not null);
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.ActivityThread.access$600(ActivityThread.java:141)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.os.Handler.dispatchMessage(Handler.java:99)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.os.Looper.loop(Looper.java:137)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.ActivityThread.main(ActivityThread.java:5041)
04-25 23:19:35.885: E/AndroidRuntime(2546): at java.lang.reflect.Method.invokeNative(Native Method)
04-25 23:19:35.885: E/AndroidRuntime(2546): at java.lang.reflect.Method.invoke(Method.java:511)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
04-25 23:19:35.885: E/AndroidRuntime(2546): at dalvik.system.NativeStart.main(Native Method)
04-25 23:19:35.885: E/AndroidRuntime(2546): Caused by: android.database.sqlite.SQLiteException: near "kay": syntax error (code 1): , while compiling: create table feeds(_id intger primary kay autoincrement, feed_url text not null);
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.smarfy02.smrss.db.DBHelper.onCreate(DBHelper.java:20)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.smarfy02.smrss.db.DBHelper.open(DBHelper.java:32)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.smarfy02.smrss.SmRss.getDB(SmRss.java:16)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.smarfy02.smrss.SmRss.getFeedsDB(SmRss.java:23)
04-25 23:19:35.885: E/AndroidRuntime(2546): at com.smarfy02.smrss.FeedActivity.onCreate(FeedActivity.java:34)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.Activity.performCreate(Activity.java:5104)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
04-25 23:19:35.885: E/AndroidRuntime(2546): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
04-25 23:19:35.885: E/AndroidRuntime(2546): ... 11 more
като видях че приложението умира като тествах  погледнах  екрана за грешки и си мисля че проблем е с бд...   прегледах предишните няколко урока и не открих разлика от това което съм написал и това което бе показано в урока.Ще се радвам ако няккой ме насочи къде ми е грешката ...
Активен

wicked92

  • Full Member
  • ***
  • Благодарности
  • -Казани: 13
  • -Получени: 7
  • Публикации: 178
Re: Андроид Урок 48 - Yarss - 7
« Отговор #2 -: 26 Април 2013, 07:52:53 »
@smarfy02

Не съм изгледал всички уроци още, но от грешката разбирам, че имаш синтактична грешка.

primary kay трябва да е primary key
Активен

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #3 -: 26 Април 2013, 10:59:47 »
 правси но тази грешка не ми троши в момента приложението ето пак съобщението
Код: [Маркирай кода]
04-26 07:56:01.066: I/Process(834): Sending signal. PID: 834 SIG: 9
04-26 07:56:17.176: I/Choreographer(930): Skipped 60 frames!  The application may be doing too much work on its main thread.
04-26 07:56:17.737: D/dalvikvm(930): GC_CONCURRENT freed 42K, 6% free 2777K/2944K, paused 39ms+5ms, total 393ms
04-26 07:56:18.026: D/dalvikvm(930): GC_FOR_ALLOC freed 3K, 6% free 2773K/2944K, paused 122ms, total 137ms
04-26 07:56:18.046: I/dalvikvm-heap(930): Grow heap (frag case) to 3.386MB for 589840-byte allocation
04-26 07:56:18.236: D/dalvikvm(930): GC_FOR_ALLOC freed <1K, 5% free 3349K/3524K, paused 187ms, total 187ms
04-26 07:56:18.516: D/dalvikvm(930): GC_CONCURRENT freed 0K, 5% free 3354K/3524K, paused 19ms+66ms, total 280ms
04-26 07:56:18.727: D/gralloc_goldfish(930): Emulator without GPU emulation detected.
04-26 07:56:44.756: D/dalvikvm(1056): GC_CONCURRENT freed 45K, 6% free 2776K/2948K, paused 20ms+15ms, total 137ms
04-26 07:56:44.896: D/dalvikvm(1056): GC_FOR_ALLOC freed 3K, 6% free 2772K/2948K, paused 46ms, total 47ms
04-26 07:56:44.906: I/dalvikvm-heap(1056): Grow heap (frag case) to 3.385MB for 589840-byte allocation
04-26 07:56:44.986: D/dalvikvm(1056): GC_FOR_ALLOC freed <1K, 6% free 3348K/3528K, paused 72ms, total 72ms
04-26 07:56:45.126: D/dalvikvm(1056): GC_CONCURRENT freed <1K, 5% free 3353K/3528K, paused 14ms+39ms, total 141ms
04-26 07:56:45.136: D/gralloc_goldfish(1056): Emulator without GPU emulation detected.
04-26 07:56:50.296: D/dalvikvm(1056): GC_FOR_ALLOC freed 267K, 11% free 3197K/3588K, paused 447ms, total 480ms
04-26 07:56:50.326: I/dalvikvm-heap(1056): Grow heap (frag case) to 3.843MB for 635812-byte allocation
04-26 07:56:50.667: D/dalvikvm(1056): GC_FOR_ALLOC freed <1K, 10% free 3817K/4208K, paused 205ms, total 210ms
04-26 07:56:51.637: E/SQLiteLog(1056): (1) AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY
04-26 07:56:51.667: D/AndroidRuntime(1056): Shutting down VM
04-26 07:56:51.697: W/dalvikvm(1056): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
04-26 07:56:51.976: E/AndroidRuntime(1056): FATAL EXCEPTION: main
04-26 07:56:51.976: E/AndroidRuntime(1056): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.smarfy02.smrss/com.smarfy02.smrss.FeedActivity}: android.database.sqlite.SQLiteException: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY (code 1): , while compiling: create table feeds(_id intger primary key autoincrement, feed_url text not null);
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.ActivityThread.access$600(ActivityThread.java:141)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.os.Handler.dispatchMessage(Handler.java:99)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.os.Looper.loop(Looper.java:137)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.ActivityThread.main(ActivityThread.java:5041)
04-26 07:56:51.976: E/AndroidRuntime(1056): at java.lang.reflect.Method.invokeNative(Native Method)
04-26 07:56:51.976: E/AndroidRuntime(1056): at java.lang.reflect.Method.invoke(Method.java:511)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
04-26 07:56:51.976: E/AndroidRuntime(1056): at dalvik.system.NativeStart.main(Native Method)
04-26 07:56:51.976: E/AndroidRuntime(1056): Caused by: android.database.sqlite.SQLiteException: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY (code 1): , while compiling: create table feeds(_id intger primary key autoincrement, feed_url text not null);
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.smarfy02.smrss.db.DBHelper.onCreate(DBHelper.java:20)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.smarfy02.smrss.db.DBHelper.open(DBHelper.java:32)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.smarfy02.smrss.SmRss.getDB(SmRss.java:16)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.smarfy02.smrss.SmRss.getFeedsDB(SmRss.java:23)
04-26 07:56:51.976: E/AndroidRuntime(1056): at com.smarfy02.smrss.FeedActivity.onCreate(FeedActivity.java:34)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.Activity.performCreate(Activity.java:5104)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
04-26 07:56:51.976: E/AndroidRuntime(1056): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)



Активен

NoBBy

  • Sr. Member
  • ****
  • Благодарности
  • -Казани: 4
  • -Получени: 38
  • Публикации: 309
Re: Андроид Урок 48 - Yarss - 7
« Отговор #4 -: 26 Април 2013, 13:30:53 »
Грешката е вече различна, и пише доста ясно каква е - Позволено е да имаш AUTOINCREMENT само на колона от числов тип (integer)

while compiling: create table feeds(_id intger primary key autoincrement, feed_url text not null);

Виж твоята колона от какъв "тип" е
Активен

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #5 -: 26 Април 2013, 14:07:25 »
дам, integer се отнася за id,  има една фатална грешка но нз каква е.
Активен

NoBBy

  • Sr. Member
  • ****
  • Благодарности
  • -Казани: 4
  • -Получени: 38
  • Публикации: 309
Re: Андроид Урок 48 - Yarss - 7
« Отговор #6 -: 26 Април 2013, 14:10:13 »
Оправи ли си правописната грешка в sql-a за създаването на таблицата?
написал си intger вместо integer, в случай че не си разбрал предишния ми пост.
Ако говориш вече за друга грешка след като си оправил тази, дай да я видим
Активен

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #7 -: 26 Април 2013, 14:19:20 »
 да оправих я, разбрах мисълта ти.ето нататък
Код: [Маркирай кода]
04-26 10:47:15.152: I/Process(1232): Sending signal. PID: 1232 SIG: 9
04-26 11:16:11.213: D/dalvikvm(1426): GC_CONCURRENT freed 42K, 6% free 2776K/2944K, paused 24ms+15ms, total 134ms
04-26 11:16:11.282: D/dalvikvm(1426): GC_FOR_ALLOC freed 3K, 6% free 2773K/2944K, paused 41ms, total 42ms
04-26 11:16:11.292: I/dalvikvm-heap(1426): Grow heap (frag case) to 3.385MB for 589840-byte allocation
04-26 11:16:11.362: D/dalvikvm(1426): GC_FOR_ALLOC freed <1K, 5% free 3349K/3524K, paused 68ms, total 68ms
04-26 11:16:11.452: D/dalvikvm(1426): GC_CONCURRENT freed <1K, 5% free 3354K/3524K, paused 12ms+13ms, total 90ms
04-26 11:16:11.472: D/gralloc_goldfish(1426): Emulator without GPU emulation detected.
04-26 11:16:15.522: D/dalvikvm(1426): GC_FOR_ALLOC freed 267K, 11% free 3197K/3588K, paused 192ms, total 216ms
04-26 11:16:15.562: I/dalvikvm-heap(1426): Grow heap (frag case) to 3.843MB for 635812-byte allocation
04-26 11:16:15.782: D/dalvikvm(1426): GC_CONCURRENT freed 2K, 10% free 3815K/4212K, paused 11ms+29ms, total 227ms
04-26 11:16:15.812: D/dalvikvm(1426): WAIT_FOR_CONCURRENT_GC blocked 84ms
04-26 11:16:16.832: E/SQLiteLog(1426): (1) table feeds already exists
04-26 11:16:16.872: D/AndroidRuntime(1426): Shutting down VM
04-26 11:16:16.893: W/dalvikvm(1426): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
04-26 11:16:17.072: E/AndroidRuntime(1426): FATAL EXCEPTION: main
04-26 11:16:17.072: E/AndroidRuntime(1426): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.smarfy02.smrss/com.smarfy02.smrss.FeedActivity}: android.database.sqlite.SQLiteException: table feeds already exists (code 1): , while compiling: create table feeds(_id integer primary key autoincrement, title text not null, description text not null, url text not null,guid text not null, date_time text not null);
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.ActivityThread.access$600(ActivityThread.java:141)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.os.Handler.dispatchMessage(Handler.java:99)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.os.Looper.loop(Looper.java:137)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.ActivityThread.main(ActivityThread.java:5041)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at java.lang.reflect.Method.invokeNative(Native Method)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at java.lang.reflect.Method.invoke(Method.java:511)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at dalvik.system.NativeStart.main(Native Method)
04-26 11:16:17.072: E/AndroidRuntime(1426): Caused by: android.database.sqlite.SQLiteException: table feeds already exists (code 1): , while compiling: create table feeds(_id integer primary key autoincrement, title text not null, description text not null, url text not null,guid text not null, date_time text not null);
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.smarfy02.smrss.db.DBHelper.onCreate(DBHelper.java:21)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.smarfy02.smrss.db.DBHelper.open(DBHelper.java:32)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.smarfy02.smrss.SmRss.getDB(SmRss.java:16)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.smarfy02.smrss.SmRss.getFeedsDB(SmRss.java:23)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at com.smarfy02.smrss.FeedActivity.onCreate(FeedActivity.java:33)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.Activity.performCreate(Activity.java:5104)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
04-26 11:16:17.072: E/AndroidRuntime(1426):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
04-26 11:16:17.072: E/AndroidRuntime(1426):    ... 11 more

интересно че живтоното се чупи следкато гатака  показа  грешния вариант в 8 или 7 урок ...
ето какво ме тревожи
Код: [Маркирай кода]
04-26 11:16:17.072: E/AndroidRuntime(1426): FATAL EXCEPTION: main

« Последна редакция: 26 Април 2013, 14:21:43 от smarfy02 »
Активен

NoBBy

  • Sr. Member
  • ****
  • Благодарности
  • -Казани: 4
  • -Получени: 38
  • Публикации: 309
Re: Андроид Урок 48 - Yarss - 7
« Отговор #8 -: 26 Април 2013, 14:36:24 »
Цитат
04-26 11:16:17.072: E/AndroidRuntime(1426): FATAL EXCEPTION: main
04-26 11:16:17.072: E/AndroidRuntime(1426): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.smarfy02.smrss/com.smarfy02.smrss.FeedActivity}: android.database.sqlite.SQLiteException: table feeds already exists (code 1): , while compiling: create table feeds(_id integer primary key autoincrement, title text not null, description text not null, url text not null,guid text not null, date_time text not null);

Дам, просто продължаваш на долу, сравнително добре са описани грешките.
Пак е проблема в sql-а.

Изглежда се опитваш да създадеш таблицата feeds, а вече я има.

Понеже не съм гледал серията със самия проект още, не съм сигурен къде може да е проблема.

Може да пробваш да добавиш IF NOT EXISTS към заявката за създаване.
Също провери къде изпълняваш въпросната заявка, да не е някъде където се вика повече от 1 пъти в живота на приложението.

« Последна редакция: 26 Април 2013, 14:45:13 от NoBBy »
Активен

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #9 -: 26 Април 2013, 14:51:48 »
така  ли трябва да бъде
Код: [Маркирай кода]
db.execSQL("create table feeds IF NOT EXISTS"+ "(_id integer primary key autoincrement, feed_url text not null);");
db.execSQL("create table feeds IF NOT EXISTS"
+"(_id integer primary key autoincrement, title text not null, description text not null, url text not null," +
"guid text not null, date_time text not null);"); ето и резултата
Код: [Маркирай кода]
04-26 11:48:48.092: E/SQLiteLog(1650): (1) near "IF": syntax error
04-26 11:48:48.112: D/AndroidRuntime(1650): Shutting down VM
04-26 11:48:48.133: W/dalvikvm(1650): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
04-26 11:48:48.312: E/AndroidRuntime(1650): FATAL EXCEPTION: main
04-26 11:48:48.312: E/AndroidRuntime(1650): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.smarfy02.smrss/com.smarfy02.smrss.FeedActivity}: android.database.sqlite.SQLiteException: near "IF": syntax error (code 1): , while compiling: create table feeds IF NOT EXISTS(_id integer primary key autoincrement, feed_url text not null);
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.ActivityThread.access$600(ActivityThread.java:141)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.os.Handler.dispatchMessage(Handler.java:99)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.os.Looper.loop(Looper.java:137)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.ActivityThread.main(ActivityThread.java:5041)
04-26 11:48:48.312: E/AndroidRuntime(1650): at java.lang.reflect.Method.invokeNative(Native Method)
04-26 11:48:48.312: E/AndroidRuntime(1650): at java.lang.reflect.Method.invoke(Method.java:511)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
04-26 11:48:48.312: E/AndroidRuntime(1650): at dalvik.system.NativeStart.main(Native Method)
04-26 11:48:48.312: E/AndroidRuntime(1650): Caused by: android.database.sqlite.SQLiteException: near "IF": syntax error (code 1): , while compiling: create table feeds IF NOT EXISTS(_id integer primary key autoincrement, feed_url text not null);
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1663)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1594)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.smarfy02.smrss.db.DBHelper.onCreate(DBHelper.java:20)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:252)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:164)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.smarfy02.smrss.db.DBHelper.open(DBHelper.java:32)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.smarfy02.smrss.SmRss.getDB(SmRss.java:16)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.smarfy02.smrss.SmRss.getFeedsDB(SmRss.java:23)
04-26 11:48:48.312: E/AndroidRuntime(1650): at com.smarfy02.smrss.FeedActivity.onCreate(FeedActivity.java:33)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.Activity.performCreate(Activity.java:5104)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
04-26 11:48:48.312: E/AndroidRuntime(1650): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
04-26 11:48:48.312: E/AndroidRuntime(1650): ... 11 more
 от тоз иф ми пищи допълнително. . Единицата сигурно е версията на бд...
Активен

NoBBy

  • Sr. Member
  • ****
  • Благодарности
  • -Казани: 4
  • -Получени: 38
  • Публикации: 309
Re: Андроид Урок 48 - Yarss - 7
« Отговор #10 -: 26 Април 2013, 15:03:10 »
Не - CREATE TABLE IF NOT EXISTS feeds
Но щом при Иван работи без това вероятно проблема е другаде.

Сигурен ли си че изпълняваш заявката в onCreate на базата?
Активен

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #11 -: 26 Април 2013, 15:10:48 »
ето кода , ами според мен да
Код: [Маркирай кода]
package com.smarfy02.smrss.db;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;


public class DBHelper extends SQLiteOpenHelper {
private static final String DB_NAME="smrss";
private static final int DB_VERSION=1;
public DBHelper(Context context) {
super(context, DB_NAME,null, DB_VERSION);

}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table feeds"+ "(_id integer primary key autoincrement, feed_url text not null);");
db.execSQL("create table feeds"
+"(_id integer primary key autoincrement, title text not null, description text not null, url text not null," +
"guid text not null, date_time text not null);");
}

@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {


}
public SQLiteDatabase open(){
return getWritableDatabase();
}
public void close(){
close();
}

}
Активен

NoBBy

  • Sr. Member
  • ****
  • Благодарности
  • -Казани: 4
  • -Получени: 38
  • Публикации: 309
Re: Андроид Урок 48 - Yarss - 7
« Отговор #12 -: 26 Април 2013, 15:19:43 »
Ти в този метод пускаш 2 поредни заявки за създаване на таблица и ползваш едно и също име. Грешката е точно за това. Сигурен ли си че Ванков не създава 2 различни таблици? Я кажи в кое видео и по кое време е този код да погледна
Активен

NoBBy

  • Sr. Member
  • ****
  • Благодарности
  • -Казани: 4
  • -Получени: 38
  • Публикации: 309
Re: Андроид Урок 48 - Yarss - 7
« Отговор #13 -: 26 Април 2013, 15:21:13 »
Цитат на: NoBBy в 26 Април 2013, 15:19:43
Ти в този метод пускаш 2 поредни заявки за създаване на таблица и ползваш едно и също име. Грешката е точно за това. Сигурен ли си че Ванков не създава 2 различни таблици? Я кажи в кое видео и по кое време е този код да погледна

Втората заявка е за създаване на таблица с име items, доколкото прецъках през видеата

Това трябваше да е едит
« Последна редакция: 26 Април 2013, 15:23:30 от NoBBy »
Активен

smarfy02

  • Hero Member
  • *****
  • Благодарности
  • -Казани: 13
  • -Получени: 0
  • Публикации: 907
  • https://www.facebook.com/pages/Стилияне-ние-сме-с-
Re: Андроид Урок 48 - Yarss - 7
« Отговор #14 -: 26 Април 2013, 15:47:27 »
няма промяна :(
Код: [Маркирай кода]
04-26 12:42:01.142: W/dalvikvm(1966): threadid=1: thread exiting with uncaught exception (group=0x40a71930)
04-26 12:42:01.262: E/AndroidRuntime(1966): FATAL EXCEPTION: main
04-26 12:42:01.262: E/AndroidRuntime(1966): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.smarfy02.smrss/com.smarfy02.smrss.FeedActivity}: java.lang.IllegalStateException: Invalid tables
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2180)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2230)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.ActivityThread.access$600(ActivityThread.java:141)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1234)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.os.Handler.dispatchMessage(Handler.java:99)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.os.Looper.loop(Looper.java:137)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.ActivityThread.main(ActivityThread.java:5041)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at java.lang.reflect.Method.invokeNative(Native Method)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at java.lang.reflect.Method.invoke(Method.java:511)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at dalvik.system.NativeStart.main(Native Method)
04-26 12:42:01.262: E/AndroidRuntime(1966): Caused by: java.lang.IllegalStateException: Invalid tables
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.database.sqlite.SQLiteDatabase.findEditTable(SQLiteDatabase.java:971)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1161)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1032)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1200)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at com.smarfy02.smrss.db.FeedsDB.getFeedsCursor(FeedsDB.java:24)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at com.smarfy02.smrss.FeedActivity.onCreate(FeedActivity.java:33)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.Activity.performCreate(Activity.java:5104)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1080)
04-26 12:42:01.262: E/AndroidRuntime(1966):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2144)
04-26 12:42:01.262: E/AndroidRuntime(1966):    ... 11 more

да не е от това което показва грешния код в Yarss - 7 за адаптера ? всеоще ме притеснява тази фатална грешка....
« Последна редакция: 26 Април 2013, 22:57:23 от smarfy02 »
Активен
Страници: [1] 2
« назад напред »