Peggun / osd

Open-Source Data for everyone to use freely. Built upon the Flask framework in Python
Apache License 2.0
1 stars 0 forks source link

OperationalError: (sqlite3.OperationalError) no such table: books #28

Closed sentry-io[bot] closed 3 months ago

sentry-io[bot] commented 3 months ago

Sentry Issue: OSD-APP-T

OperationalError: no such table: books
  File "sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
  File "sqlalchemy\engine\default.py", line 941, in do_execute
    cursor.execute(statement, parameters)

OperationalError: (sqlite3.OperationalError) no such table: books
[SQL: SELECT books.id AS books_id, books.title AS books_title, books.author AS books_author, books.description AS books_description, books.file_path AS books_file_path, books.created_at AS books_created_at, books.updated_at AS books_updated_at 
FROM books 
WHERE lower(books.title) LIKE lower(?)]
[parameters: ('%bo%',)]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
(13 additional frame(s) were not displayed)
...
  File "C:\Users\prest\OneDrive - John Septimus Roe Anglican Community School\Documents\Software Engineering\Python\WorkSpace\osd\src\app\website\routes\database_page\database_route.py", line 17, in search
    db1_results = Book.query.filter(Book.title.ilike(f'%{query}%')).all()

This issue was automatically created by Sentry via Send a notification for new issues