Sqlite ошибка no such table

I am trying to store data about pupils at a school. I’ve done a few tables before, such as one for passwords and Teachers which I will later bring together in one program.

I have pretty much copied the create table function from one of these and changed the values to for the Pupil’s information. It works fine on the other programs but I keep getting:

sqlite3.OperationalError: no such table: PupilPremiumTable

when I try to add a pupil to the table, it occurs on the line:

cursor.execute("select MAX(RecordID) from PupilPremiumTable")

I look in the folder and there is a file called PupilPremiumTable.db and the table has already been created before, so I don’t know why it isn’t working.

Here is some of my code, if you need more feel free to tell me so, as I said it worked before so I have no clue why it isn’t working or even what isn’t working:

with sqlite3.connect("PupilPremiumTable.db") as db:
    cursor = db.cursor()
    cursor.execute("select MAX(RecordID) from PupilPremiumTable")
    Value = cursor.fetchone()
    Value = str('.'.join(str(x) for x in Value))
    if Value == "None":
        Value = int(0)
    else:
        Value = int('.'.join(str(x) for x in Value))
    if Value == 'None,':
        Value = 0
    TeacherID = Value + 1
    print("This RecordID is: ",RecordID)

Пишу систему регистрации для ТГ бота, создал базу данных, все что нужно написал и запускаю и ошибка sqlite3.OperationalError: no such table: users
Код, где класс для базы данных: (оттуда ошибка)

import sqlite3
conn = sqlite3.connect('database.db')
class Database:
    def __init__(self, db_file):
        self.connection = sqlite3.connect(db_file)
        self.cursor = self.connection.cursor()
    
    def add_user(self, user_id):
        with self.connection:
           return self.cursor.execute("INSERT INTO 'users' ('user_id') VALUES (?)", (user_id,))
    
    def user_exists(self, user_id):
        with self.connection:
            result = self.cursor.execute("SELECT * FROM 'users' WHERE 'user_id' = ?", (user_id,)).fetchall()
            return bool(len(result))

    def set_nicname(self, user_id, nickname):
         with self.connection:
            return self.cursor.execute("UPDATE 'users' 'SET' 'nickname' = ? WHERE 'user_id' = ?", (nickname, user_id,))

    def get_signup(self, user_id):
        with self.connection:
            result = self.cursor.execute("SELECT 'signup' FROM 'users' WHERE 'user_id' = ?", (user_id,)).fetchall()
            for row in result:
                signup = str(row(0))
            return signup

    def set_signup(self, user_id, signup):
         with self.connection:
            return self.cursor.execute("UPDATE 'users' 'SET' 'signup' = ? WHERE 'user_id' = ?", (signup, user_id,))

И ошибка раздаётся из 14-той строчки кода — вот она

result = self.cursor.execute("SELECT * FROM 'users' WHERE 'user_id' = ?", (user_id,)).fetchall()
            return bool(len(result))

Если надо, то вот скрин базы данных и таблицы:

Не пойму: В чём ошибка, если таблица существует…
Подскажите, кто знает.

Sqlite and Python Error – sqlite3.OperationalError: no such table is an error which occurs when the directory of your database is different than your working directory.

Today I will be explaining why this error is taking place and how to solve it.

This is an error which occurs when the directory of your database is different than your working directory.

Beware of mixing between different errors. Please make sure you are dealing with the same error.

                                                                       #
sqlite3.OperationalError: no such table: <yourTable>
                                                                       #

Bellow is a number of tested solutions that I have tried and worked for me.

The Method that eliminated my problem : Correctly get the directory where the database lives

The error occurs when the directory of the database is not the same as the directory of your scripts.

It gets confusing yes, since this is most likely a new database and you do not know it is path. Do not worry the fix is simple, you can just derive the path of your database from the path of your working directory.

This is how your code is going to look like.

First, you should start by importing os.path. using the line of code bellow.

                                                                       #
import os.path
                                                                       #

Store the path of the directory in DIRorigin for example

                                                                       #
DIRorigin = os.path.dirname(os.path.abspath(__file__))
                                                                       #

Now, we should use the line of code bellow to store the path to the database in DBpath

                                                                       #
DBpath = os.path.join(BASE_DIR, "mydatabase.db")
                                                                       #

and Voila, do not forget to add this line at the end.

                                                                       #
with sqlite3.connect(DBpath) as db:
                                                                       #

This method should fix the issue for most people, If that is not the case for you, I am sorry but I do not know any other way to solve this issue. The only method that solved my problem is the method above.

I hope this guide solved your problem, thank you for reading. Goof luck with your Python Journey.

Summing-up : 

This is the end of this article guys, I hope one of these solutions worked for you depending on which OS you have, I wish you good luck with your Python Journey. For donations you can use the red Kofi button above.

Thank you for reading, keep coding and cheers. If you want to learn more about Python, please check out the Python Documentation : https://docs.python.org/3/