(1)NO such Column found: Keyotp1

04-28 01:21:20.140: E/SQLiteLog(1652): (1) no such column: keyotp1 04-28 01:21:20.140: W/dalvikvm(1652): threadid=11: thread exiting with uncaught exception (group=0xb3a84ba8) 04-28 01:21:20.200: E/AndroidRuntime(1652): FATAL EXCEPTION: AsyncTask #1 04-28 01:21:20.200: E/AndroidRuntime(1652): Process: com.example.sklalhindusindhiapp, PID: 1652 04-28 01:21:20.200: E/AndroidRuntime(1652): java.lang.RuntimeException: An error occured while executing doInBackground() 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.os.AsyncTask$3.done(AsyncTask.java:300) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:355) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.util.concurrent.FutureTask.setException(FutureTask.java:222) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.util.concurrent.FutureTask.run(FutureTask.java:242) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:231) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.lang.Thread.run(Thread.java:841) 04-28 01:21:20.200: E/AndroidRuntime(1652): Caused by: android.database.sqlite.SQLiteException: no such column: keyotp1 (code 1): , while compiling: SELECT * FROM userinfo where fname LIKE '%' + keyfname + '%' + 'OR' + fname LIKE '%' +' '+ '%' + 'AND' + lname LIKE '%' + keylname + '%' + 'OR' + lname LIKE '%' +' '+'%' + 'AND' + city LIKE '%' + keycity + '%' + 'OR' + city LIKE '%' +' '+'%' + 'AND' + state LIKE '%' + keystate + '%' +' OR' + state LIKE '%' +' '+'%' + 'AND' + phone_number LIKE '%' + keyotp1 + '%' + ' OR' + phone_number LIKE '%' +' '+'%' 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253) 04-28 01:21:20.200: E/AndroidRuntime(1652): at com.example.sklalhindusindhiapp.Off_Search_Record$offsearch.doInBackground(Off_Search_Record.java:126) 04-28 01:21:20.200: E/AndroidRuntime(1652): at com.example.sklalhindusindhiapp.Off_Search_Record$offsearch.doInBackground(Off_Search_Record.java:1) 04-28 01:21:20.200: E/AndroidRuntime(1652): at android.os.AsyncTask$2.call(AsyncTask.java:288) 04-28 01:21:20.200: E/AndroidRuntime(1652): at java.util.concurrent.FutureTask.run(FutureTask.java:237) 04-28 01:21:20.200: E/AndroidRuntime(1652): ... 4 more 04-28 01:21:20.330: I/Choreographer(1652): Skipped 79 frames! The application may be doing too much work on its main thread. 04-28 01:21:20.600: I/Choreographer(1652): Skipped 65 frames! The application may be doing too much work on its main thread. 04-28 01:21:21.010: I/Choreographer(1652): Skipped 108 frames! The application may be doing too much work on its main thread. 04-28 01:21:21.360: I/Choreographer(1652): Skipped 74 frames! The application may be doing too much work on its main thread. 04-28 01:21:22.730: I/Choreographer(1652): Skipped 325 frames! The application may be doing too much work on its main thread. 04-28 01:21:22.920: I/Choreographer(1652): Skipped 48 frames! The application may be doing too much work on its main thread. 04-28 01:21:23.550: E/WindowManager(1652): android.view.WindowLeaked: Activity com.example.sklalhindusindhiapp.Off_Search_Record has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView{b4e807e0 V.E..... R.....ID 0,0-480,144} that was originally added here 04-28 01:21:23.550: E/WindowManager(1652): at android.view.ViewRootImpl.(ViewRootImpl.java:348) 04-28 01:21:23.550: E/WindowManager(1652): at android.view.WindowManagerGlobal.addView(WindowManagerGlobal.java:248) 04-28 01:21:23.550: E/WindowManager(1652): at android.view.WindowManagerImpl.addView(WindowManagerImpl.java:69) 04-28 01:21:23.550: E/WindowManager(1652): at android.app.Dialog.show(Dialog.java:286) 04-28 01:21:23.550: E/WindowManager(1652): at com.example.sklalhindusindhiapp.Off_Search_Record$offsearch.onPreExecute(Off_Search_Record.java:93) 04-28 01:21:23.550: E/WindowManager(1652): at android.os.AsyncTask.execute(AsyncTask.java:535) 04-28 01:21:23.550: E/WindowManager(1652): at com.example.sklalhindusindhiapp.Off_Search_Record$1.onClick(Off_Search_Record.java:69) 04-28 01:21:23.550: E/WindowManager(1652): at android.view.View.performClick(View.java:4438) 04-28 01:21:23.550: E/WindowManager(1652): at android.view.View$PerformClick.run(View.java:18422) 04-28 01:21:23.550: E/WindowManager(1652): at android.os.Handler.handleCallback(Handler.java:733) 04-28 01:21:23.550: E/WindowManager(1652): at android.os.Handler.dispatchMessage(Handler.java:95) 04-28 01:21:23.550: E/WindowManager(1652): at android.os.Looper.loop(Looper.java:136) 04-28 01:21:23.550: E/WindowManager(1652): at android.app.ActivityThread.main(ActivityThread.java:5017) 04-28 01:21:23.550: E/WindowManager(1652): at java.lang.reflect.Method.invokeNative(Native Method) 04-28 01:21:23.550: E/WindowManager(1652): at java.lang.reflect.Method.invoke(Method.java:515) 04-28 01:21:23.550: E/WindowManager(1652): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779) 04-28 01:21:23.550: E/WindowManager(1652): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595) 04-28 01:21:23.550: E/WindowManager(1652): at dalvik.system.NativeStart.main(Native Method) 04-28 01:21:23.550: I/Choreographer(1652): Skipped 44 frames! The application may be doing too much work on its main thread.