Android SQLite "no such table" exception

I had the same problem and fixed it by cleaning the project and deleting the app off my testing device and reinstalling it. I believe it occurred because I followed another tutorial that created an empty database by mistake. The corrected code was retrieving the old empty database.

If you are running your app in your device, go to >>Settings (in Android device)>>>application>>>locate your application>>clear data and cache. After that, debug or install again your new application..

I solved this problem by doing that...

The exception is very clear, you've created the database (ligas_db) but not a table within it (no such table exception = there is not a table named ligas_db)

Check this: http://www.vogella.de/articles/AndroidSQLite/article.html

(¿Eres Antonio Recio? jaja)

You have ligas_bd as the name of the database and you are trying to SELECT from it.

You need to create table first before you selecting from it. May you have created before but you need to create it after opening database connection.

My problem was I left "/databases/" off the end of my path name. What was so confusing for me is the code worked before when I was loading a dbconnection and storing it as an instance variable. Then when I needed to make use of the getReadableDatabase() and getWritableDatabase () methods, they kept pulling in the empty database created in the "real" databases path.

INCORRECT /data/data/mypackagename/

CORRECT /data/data/mypackagename/databases/

+1 to @Squonk who's answer finally helped me track this down!

I had the same problem try to include .db extension in the file name like:

private static String DB_NAME = "ligas_bd.db";

Faced same problem i suggest don't use rawQuery

SQLiteDatabase DB=this.getWritableDatabase();
Cursor data;
String[] columns = {"deviceid"};
String selection = "deviceid" + " =?";
String[] selectionArgs = { devicename };
data=DB.query("Btconnection",columns,selection,selectionArgs,null,null,null);

Use TFDQuery.Open('commands') or TFDQuery.ExecSql('commands') This resolve my problem.

i had copied the "DatabaseManager" class from somewhere and modified it, my problem as 'Squonk' said was that there was somewhere in the code that was using getReadableDatabase() before it get the chance to copy the database and it was creating an empty database by itself...

!!also another problem was that my assets folder was in the "/src/androidTest/assets" and it should be inside "/src/main" next to "res"!!

herer is the working class im using now :

package com.haghshenas.mafatih.Adapters;

import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import androidx.annotation.Nullable;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;


public class DatabaseManager extends SQLiteOpenHelper {

    private static String TAG = "DataBaseHelper";
    public SQLiteDatabase mDataBase;
    private final Context mContext;

    private static String DB_PATH = "";
    private static String DB_NAME ="mafatihdbv14.db";

    public DatabaseManager(@Nullable Context context) {
        super(context, DB_NAME, null, 1);
        this.mContext = context;
        DB_PATH = "/data/data/" + context.getPackageName() + "/";
        createDataBase();
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {

    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {

    }

    private boolean checkDataBase()
    {
        File dbFile = new File(DB_PATH + DB_NAME);
        return dbFile.exists();
    }

    public void createDataBase()
    {
        boolean mDataBaseExist = checkDataBase();
        if(!mDataBaseExist)
        {
            try
            {
                copyDataBase();
            }
            catch (IOException mIOException)
            {
                Log.i(TAG, "createDataBase "+mIOException+"");
            }
        }else{
            openDataBase();
        }
    }

    private void copyDataBase() throws IOException
    {
        try
        {
            InputStream mInput = mContext.getAssets().open("mafatihdbv14.db");
            String outFileName = DB_PATH + DB_NAME;
            OutputStream mOutput = new FileOutputStream(outFileName);
            byte[] mBuffer = new byte[1024];
            int mLength;
            while ((mLength = mInput.read(mBuffer))>0)
            {
                mOutput.write(mBuffer, 0, mLength);
            }
            mOutput.flush();
            mOutput.close();
            mInput.close();
            openDataBase();
        }
        catch (IOException mIOException)
        {
            Log.i(TAG,"copyDataBase "+ mIOException+"");
        }
    }

    public boolean openDataBase() throws SQLException
    {
        String mPath = DB_PATH + DB_NAME;
        mDataBase = SQLiteDatabase.openDatabase(mPath,null, SQLiteDatabase.OPEN_READWRITE);
        return mDataBase != null;
    }

    @Override
    public synchronized void close()
    {
        if(mDataBase != null)
            mDataBase.close();
        super.close();
    }
}