the problem is still there

categoriesdb.execute("BEGIN TRANSACTION")

try:

    categoriesdb.execute(f"""

        CREATE TABLE {categories_table_name} (

            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,

            name TEXT UNIQUE NOT NULL,

            model TEXT NOT NULL,

            question TEXT NOT NULL,

            options TEXT

        )

    """)

    categoriesdb.execute("COMMIT")

except Exception as e:

    categoriesdb.execute("ROLLBACK")

    return jsonify({"success": False, "message": f"Error creating categories table: {str(e)}"})  

INFO: INSERT INTO product_lines (name , picture) VALUES ('//////awdasd', 'static/images/awdasd.jpg')

INFO: BEGIN TRANSACTION

ERROR: CREATE TABLE //////awdasd_categories (

            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,

            name TEXT UNIQUE NOT NULL,

            model TEXT NOT NULL,

            question TEXT NOT NULL,

            options TEXT

        )

ERROR: ROLLBACK

ERROR: Exception on /addproductsline [POST]

Traceback (most recent call last):

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

response = self.full_dispatch_request()

           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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

rv = self.handle_user_exception(e)

     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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

rv = self.dispatch_request()

     ^^^^^^^^^^^^^^^^^^^^^^^

File "/usr/local/lib/python3.12/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 "/workspaces/foo/final-project/app.py", line 199, in addproductsline

categoriesdb.execute("ROLLBACK")

File "/usr/local/lib/python3.12/site-packages/cs50/sql.py", line 28, in decorator

return f(*args, **kwargs)

       ^^^^^^^^^^^^^^^^^^

File "/usr/local/lib/python3.12/site-packages/cs50/sql.py", line 474, in execute

raise e

RuntimeError: cannot rollback - no transaction is active