pymysql.err.ProgrammingError: (1146, "Table 'sdf.marques_sdf' doesn't exist") // Werkzeug Debugger

ProgrammingError

pymysql.err.ProgrammingError: (1146, "Table 'sdf.marques_sdf' doesn't exist")

Traceback (most recent call last)

File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 1536, in `call`

    ) -> cabc.Iterable[bytes]:

        """The WSGI server calls the Flask application object as the

        WSGI application. This calls :meth:`wsgi_app`, which can be

        wrapped to apply middleware.

"""

        return self.wsgi_app(environ, start_response)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 1514, in `wsgi_app`

            try:

                ctx.push()

                response = self.full_dispatch_request()

            except Exception as e:

                error = e

                response = self.handle_exception(e)
                           ^^^^^^^^^^^^^^^^^^^^^^^^

            except:  # noqa: B001

                error = sys.exc_info()[1]

                raise

            return response(environ, start_response)

        finally:

File "/usr/local/lib/python3.11/site-packages/flask_cors/extension.py", line 176, in `wrapped_function`

        # These error handlers will still respect the behavior of the route

        if options.get("intercept_exceptions", True):

            def _after_request_decorator(f):

                def wrapped_function(*args, **kwargs):

                    return cors_after_request(app.make_response(f(*args, **kwargs)))
                                                                ^^^^^^^^^^^^^^^^^^

                return wrapped_function

            if hasattr(app, "handle_exception"):

                app.handle_exception = _after_request_decorator(app.handle_exception)

File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 1511, in `wsgi_app`

        ctx = self.request_context(environ)

        error: BaseException | None = None

        try:

            try:

                ctx.push()

                response = self.full_dispatch_request()
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

            except Exception as e:

                error = e

                response = self.handle_exception(e)

            except:  # noqa: B001

                error = sys.exc_info()[1]

File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 919, in `full_dispatch_request`

            request_started.send(self, _async_wrapper=self.ensure_sync)

            rv = self.preprocess_request()

            if rv is None:

                rv = self.dispatch_request()

        except Exception as e:

            rv = self.handle_user_exception(e)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

        return self.finalize_request(rv)

    def finalize_request(

        self,

        rv: ft.ResponseReturnValue | HTTPException,

File "/usr/local/lib/python3.11/site-packages/flask_cors/extension.py", line 176, in `wrapped_function`

        # These error handlers will still respect the behavior of the route

        if options.get("intercept_exceptions", True):

            def _after_request_decorator(f):

                def wrapped_function(*args, **kwargs):

                    return cors_after_request(app.make_response(f(*args, **kwargs)))
                                                                ^^^^^^^^^^^^^^^^^^

                return wrapped_function

            if hasattr(app, "handle_exception"):

                app.handle_exception = _after_request_decorator(app.handle_exception)

File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 917, in `full_dispatch_request`

        try:

            request_started.send(self, _async_wrapper=self.ensure_sync)

            rv = self.preprocess_request()

            if rv is None:

                rv = self.dispatch_request()
                     ^^^^^^^^^^^^^^^^^^^^^^^

        except Exception as e:

            rv = self.handle_user_exception(e)

        return self.finalize_request(rv)

    def finalize_request(

File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 902, in `dispatch_request`

            and req.method == "OPTIONS"

):

            return self.make_default_options_response()

        # otherwise dispatch to the handler for that endpoint

        view_args: dict[str, t.Any] = req.view_args  # type: ignore[assignment]

        return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)  # type: ignore[no-any-return]
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    def full_dispatch_request(self) -> Response:

        """Dispatches the request and on top of that performs request

        pre and postprocessing as well as HTTP exception catching and

        error handling.

File "/app/middlewares.py", line 49, in `wrapper`

            return _json_error("Server misconfigured (SITE_API_TOKEN missing)", 500)

        if not header_token or header_token != expected:

            return _json_error("Invalid or missing site token", 401)

        return view_func(*args, **kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^

    return wrapper

# =======================================================

File "/app/routes/routes_articles.py", line 123, in `api_article_msdf`

                AND a.published_at IS NOT NULL

                AND a.published_at <= NOW()

            GROUP BY m.id, m.slug, m.label, m.description

            ORDER BY m.label ASC

"""

        rows = query_db(sql)
               ^^^^^^^^^^^^^

        items = [

                "id": r["id"],

                "slug": r["slug"],

File "/app/helpers.py", line 51, in `query_db`

"""

    Helper SELECT.

"""

    conn = get_db()

    with conn.cursor() as cur:

        cur.execute(sql, params or [])
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

        rows = cur.fetchall()

    if one:

        return rows[0] if rows else None

    return rows

File "/usr/local/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in `execute`

        while self.nextset():

            pass

        query = self.mogrify(query, args)

        result = self._query(query)
                 ^^^^^^^^^^^^^^^^^^

        self._executed = query

        return result

    def executemany(self, query, args):

        """Run several data against one query.

File "/usr/local/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in `_query`

        self.rownumber = r

    def _query(self, q):

        conn = self._get_db()

        self._clear_result()

        conn.query(q)
        ^^^^^^^^^^^^^

        self._do_get_result()

        return self.rowcount

    def _clear_result(self):

        self.rownumber = 0

File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 575, in `query`

        # if DEBUG:

        #     print("DEBUG: sending query:", sql)

        if isinstance(sql, str):

            sql = sql.encode(self.encoding, "surrogateescape")

        self._execute_command(COMMAND.COM_QUERY, sql)

        self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

        return self._affected_rows

    def next_result(self, unbuffered=False):

        self._affected_rows = self._read_query_result(unbuffered=unbuffered)

        return self._affected_rows

File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 826, in `_read_query_result`

        self._result = None

        result = MySQLResult(self)

        if unbuffered:

            result.init_unbuffered_query()

        else:

            result.read()
            ^^^^^^^^^^^^^

        self._result = result

        if result.server_status is not None:

            self.server_status = result.server_status

        return result.affected_rows

File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 1203, in `read`

        if self.unbuffered_active:

            self._finish_unbuffered_query()

    def read(self):

        try:

            first_packet = self.connection._read_packet()
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

            if first_packet.is_ok_packet():

                self._read_ok_packet(first_packet)

            elif first_packet.is_load_local_packet():

                self._read_load_local_packet(first_packet)

File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 782, in `_read_packet`

        packet = packet_type(bytes(buff), self.encoding)

        if packet.is_error_packet():

            if self._result is not None and self._result.unbuffered_active is True:

                self._result.unbuffered_active = False

            packet.raise_for_error()
            ^^^^^^^^^^^^^^^^^^^^^^^^

        return packet

    def _read_bytes(self, num_bytes):

        self._sock.settimeout(self._read_timeout)

        while True:

File "/usr/local/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in `raise_for_error`

        self.rewind()

        self.advance(1)  # field_count == error (we already know that)

        errno = self.read_uint16()

        if DEBUG:

            print("errno =", errno)

        err.raise_mysql_exception(self._data)
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    def dump(self):

        dump_packet(self._data)

File "/usr/local/lib/python3.11/site-packages/pymysql/err.py", line 150, in `raise_mysql_exception`

    else:

        errval = data[3:].decode("utf-8", "replace")

    errorclass = error_map.get(errno)

    if errorclass is None:

        errorclass = InternalError if errno < 1000 else OperationalError

    raise errorclass(errno, errval)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

pymysql.err.ProgrammingError: (1146, "Table 'sdf.marques_sdf' doesn't exist")

This is the Copy/Paste friendly version of the traceback.

Traceback (most recent call last):
  File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 1536, in __call__
    return self.wsgi_app(environ, start_response)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 1514, in wsgi_app
    response = self.handle_exception(e)
               ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask_cors/extension.py", line 176, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
                                                ^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 1511, in wsgi_app
    response = self.full_dispatch_request()
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 919, in full_dispatch_request
    rv = self.handle_user_exception(e)
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask_cors/extension.py", line 176, in wrapped_function
    return cors_after_request(app.make_response(f(*args, **kwargs)))
                                                ^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 917, in full_dispatch_request
    rv = self.dispatch_request()
         ^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/flask/app.py", line 902, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)  # type: ignore[no-any-return]
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/middlewares.py", line 49, in wrapper
    return view_func(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/routes/routes_articles.py", line 123, in api_article_msdf
    rows = query_db(sql)
           ^^^^^^^^^^^^^
  File "/app/helpers.py", line 51, in query_db
    cur.execute(sql, params or [])
  File "/usr/local/lib/python3.11/site-packages/pymysql/cursors.py", line 153, in execute
    result = self._query(query)
             ^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/pymysql/cursors.py", line 322, in _query
    conn.query(q)
  File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 575, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 826, in _read_query_result
    result.read()
  File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 1203, in read
    first_packet = self.connection._read_packet()
                   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/usr/local/lib/python3.11/site-packages/pymysql/connections.py", line 782, in _read_packet
    packet.raise_for_error()
  File "/usr/local/lib/python3.11/site-packages/pymysql/protocol.py", line 219, in raise_for_error
    err.raise_mysql_exception(self._data)
  File "/usr/local/lib/python3.11/site-packages/pymysql/err.py", line 150, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, "Table 'sdf.marques_sdf' doesn't exist")

The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error. If you enable JavaScript you can also use additional features such as code execution (if the evalex feature is enabled), automatic pasting of the exceptions and much more.

Console Locked

The console is locked and needs to be unlocked by entering the PIN. You can find the PIN printed out on the standard output of your shell that runs the server.

LA MARQUE SERRURIERS DE FRANCE®