Still the same problem.
Here is the stacktrace and the logcat from creating the tables until
crashing:
10-04 15:35:59.795: WARN/DbAdapter(9542): Starting to create db!
10-04 15:35:59.805: WARN/DbAdapter(9542): table1 created!
10-04 15:35:59.805: WARN/DbAdapter(9542): table2 created!
10-04 15:35:59.805: WARN/DbAdapter(9542): table3 created!
10-04 15:35:59.805: WARN/DbAdapter(9542): table4 created!
10-04 15:35:59.805: WARN/DbAdapter(9542): table5 created!
10-04 15:35:59.805: WARN/DbAdapter(9542): table6 created!
10-04 15:35:59.805: WARN/DbAdapter(9542): table7 created!
10-04 15:35:59.815: WARN/DbAdapter(9542): table8 created!
10-04 15:35:59.815: WARN/DbAdapter(9542): table9 created!
10-04 15:35:59.815: WARN/DbAdapter(9542): table10 created!
10-04 15:35:59.815: WARN/DbAdapter(9542): table11 created!
10-04 15:35:59.815: WARN/DbAdapter(9542): table12 created!
10-04 15:36:00.105: INFO/MyHTC(6729): SyncSpePluginFlow - SYNCHING
SPECIFIC APP com.htc.recommend.cs.MyDownloadsSyncAdapter
10-04 15:36:00.255: DEBUG/szipinf(1445): Initializing inflate state
10-04 15:36:00.265: INFO/FacebookSyncService(7293): Sync contacts
batch from null
10-04 15:36:00.265: DEBUG/SimpleFacebookInterface(7293): get friend
10-04 15:36:00.265: DEBUG/SimpleFacebookInterface(7293): query =
{"query1":"select id , name , pic_big , pic_square from profile where
id in (select uid2 from friend where uid1=736411284 or
uid2=736411284) order by name limit 500","query2":"select uid ,
current_location , notes_count , profile_url , profile_update_time ,
status , wall_count , work_history , birthday_date , cell ,
other_phone , email from user where uid in (select id from #query1)"}
10-04 15:36:00.375: DEBUG/[CSExceptionUtil](6729): ++++++++
syncMessageQueue ++++++
10-04 15:36:00.645: DEBUG/szipinf(1445): Initializing inflate state
10-04 15:36:00.866: DEBUG/dalvikvm(7293): GC_CONCURRENT freed 221K,
41% free 4310K/7303K, external 0K/0K, paused 2ms+3ms
10-04 15:36:01.086: DEBUG/Database(6729): dbopen(): path = /data/data/
com.htc.cs/databases/MQDB, flag = 6
10-04 15:36:01.086: DEBUG/Database(6729): dbopen(): path = /data/data/
com.htc.cs/databases/MQDB, free size = 791
10-04 15:36:01.096: DEBUG/MyHTC(6729): CSSyncMaster - SyncAdapter
onPerformSync end SyncAdapterThread-1
10-04 15:36:01.126: DEBUG/dalvikvm(7293): GC_CONCURRENT freed 877K,
47% free 3943K/7303K, external 0K/0K, paused 2ms+2ms
10-04 15:36:01.847: DEBUG/AndroidRuntime(9542): Shutting down VM
10-04 15:36:01.847: WARN/dalvikvm(9542): threadid=1: thread exiting
with uncaught exception (group=0x4001d5a0)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): FATAL EXCEPTION: main
10-04 15:02:28.791: ERROR/AndroidRuntime(8904):
java.lang.RuntimeException: Unable to start activity
ComponentInfo{package/package.Tabs}: java.lang.RuntimeException:
Unable to start activity ComponentInfo{package.Main}:
java.lang.IllegalArgumentException: the bind value at index 1 is null
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
1816)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:
1837)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.access$1500(ActivityThread.java:132)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread$H.handleMessage(ActivityThread.java:1033)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.os.Handler.dispatchMessage(Handler.java:99)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.os.Looper.loop(Looper.java:143)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.main(ActivityThread.java:4196)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
java.lang.reflect.Method.invokeNative(Native Method)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
java.lang.reflect.Method.invoke(Method.java:507)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
com.android.internal.os.ZygoteInit
$MethodAndArgsCaller.run(ZygoteInit.java:839)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
dalvik.system.NativeStart.main(Native Method)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): Caused by:
java.lang.RuntimeException: Unable to start activity
ComponentInfo{package/package.Main}:
java.lang.IllegalArgumentException: the bind value at index 1 is null
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
1816)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.startActivityNow(ActivityThread.java:1651)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.LocalActivityManager.moveToState(LocalActivityManager.java:
127)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.LocalActivityManager.startActivity(LocalActivityManager.java:
339)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.widget.TabHost
$IntentContentStrategy.getContentView(TabHost.java:656)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.widget.TabHost.setCurrentTab(TabHost.java:326)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.widget.TabHost.addTab(TabHost.java:216)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
package.Tabs.onCreate(Tabs.java:65)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:
1093)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
1780)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): ... 11 more
10-04
15:02:28.791: ERROR/AndroidRuntime(8904): Caused by:
java.lang.IllegalArgumentException: the bind value at index 1 is null
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:
237)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteQuery.bindString(SQLiteQuery.java:185)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:
59)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:
1438)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:
1317)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1271)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1391)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
package.Tabs.checkListName(DbAdapter.java:310)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
package.Main.getListId(Main.java:567)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
package.Main.fillItems(Main.java:191)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
package.Main.toggleCheckAll(Main.java:322)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
package.Main.onCreate(Main.java:79)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:
1093)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): at
android.app.ActivityThread.performLaunchActivity(ActivityThread.java:
1780)
10-04 15:02:28.791: ERROR/AndroidRuntime(8904): ... 20 more
Thanks
//André
On Oct 4, 3:17 pm, Kostya Vasilyev <[email protected]> wrote:
> The output looks good.
>
> If you're still getting the errors, post logcat output(s) with stack traces.
>
> 04.10.2011 17:08, André пишет:
>
> > I never had the version set to 0 so it should be onCreate.
>
> > I put a log like this for each db.executeSql: Log.w(TAG, "Starting to
> > create db!");
>
> > And got this output. Did I misunderstand you of how to find the
> > problem?
>
> --
> Kostya Vasilyev
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en