search

ali-shahKust / Quiz

Changing in app to remove the Copyrights
0 stars 0 forks source link

Sir Please Help #1

Open trrahat01 opened 4 years ago

trrahat01 commented 4 years ago

E/AndroidRuntime: FATAL EXCEPTION: main Process: com.cricket.quiz, PID: 26265 android.database.sqlite.SQLiteException: no such table: questions_list (code 1 SQLITE_ERROR): , while compiling: select * FROM questions_list where level=1 ORDER BY RANDOM() LIMIT 10 at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:514) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:46) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1408) at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1347) at com.cricket.quiz.adapter.DBHelper.getQuestionGuj(DBHelper.java:93) at com.cricket.quiz.model.QuizLevel.setQuestionGuj(QuizLevel.java:34) at com.cricket.quiz.fragment.FragmentPlay.resetAllValue(FragmentPlay.java:966) at com.cricket.quiz.fragment.FragmentPlay.onCreateView(FragmentPlay.java:125) at androidx.fragment.app.Fragment.performCreateView(Fragment.java:2439) at androidx.fragment.app.FragmentManagerImpl.moveToState(FragmentManager.java:1460) at androidx.fragment.app.FragmentManagerImpl.moveFragmentToExpectedState(FragmentManager.java:1784) at androidx.fragment.app.FragmentManagerImpl.moveToState(FragmentManager.java:1852) at androidx.fragment.app.BackStackRecord.executeOps(BackStackRecord.java:802) at androidx.fragment.app.FragmentManagerImpl.executeOps(FragmentManager.java:2625) at androidx.fragment.app.FragmentManagerImpl.executeOpsTogether(FragmentManager.java:2411) at androidx.fragment.app.FragmentManagerImpl.removeRedundantOperationsAndExecute(FragmentManager.java:2366) at androidx.fragment.app.FragmentManagerImpl.execPendingActions(FragmentManager.java:2273) at androidx.fragment.app.FragmentManagerImpl$1.run(FragmentManager.java:733) at android.os.Handler.handleCallback(Handler.java:873) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:201) at android.app.ActivityThread.main(ActivityThread.java:6820) at java.lang.reflect.Method.invoke(Native Method) at com.android.internal.os.RuntimeInit$MethodAndArgsCaller.run(RuntimeInit.java:547) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:922)

trrahat01 commented 4 years ago

sir, DBHelper.java public List getQuestionGuj(int noOfQuestion, int level) { List quizplay = new ArrayList(); int total = noOfQuestion; String sql = "select * FROM questions_list where level=" + level + " ORDER BY RANDOM() LIMIT " + total; SQLiteDatabase db = this.getReadableDatabase(); //SQLiteDatabase db = SQLiteDatabase.openDatabase("/data/data/" + packageName + "/databases/" + DATABASE_NAME, null, 0); Cursor cursor = db.rawQuery(sql, null);

problem show in Cursor cursor = db.rawQuery(sql, null); this line