flask db doesn't make migrations

[skabdulhaq]

executing flask db migrate, flask db upgrade iam getting this error don't even know why iam getting this error using iam using flask-migrate==2.5.3

  File "/opt/venv/bin/flask", line 8, in <module>
    sys.exit(main())
             ^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/flask/cli.py", line 995, in main
    cli.main(args=sys.argv[1:])
  File "/opt/venv/lib/python3.11/site-packages/flask/cli.py", line 601, in main
    return super().main(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/click/core.py", line 782, in main
    rv = self.invoke(ctx)
         ^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/click/core.py", line 1259, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/click/core.py", line 1066, in invoke
    return ctx.invoke(self.callback, **ctx.params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/click/core.py", line 610, in invoke
    return callback(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/click/decorators.py", line 21, in new_func
    return f(get_current_context(), *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/flask/cli.py", line 444, in decorator
    with __ctx.ensure_object(ScriptInfo).load_app().app_context():
         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/flask/cli.py", line 411, in load_app
    app = locate_app(self, import_name, None, raise_if_not_found=False)
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/flask/cli.py", line 260, in locate_app
    __import__(module_name)
  File "/opt/CTFd/wsgi.py", line 11, in <module>
    app = create_app()
          ^^^^^^^^^^^^
  File "/opt/CTFd/CTFd/__init__.py", line 217, in create_app
    url = create_database()
          ^^^^^^^^^^^^^^^^^
  File "/opt/CTFd/CTFd/utils/migrations/__init__.py", line 28, in create_database
    x = create_database_util(url, encoding="utf8mb4")
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/sqlalchemy_utils/functions/database.py", line 579, in create_database
    quote(conn, database),
    ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/sqlalchemy_utils/functions/orm.py", line 529, in quote
    return dialect.preparer(dialect).quote(ident)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/sql/compiler.py", line 5458, in quote
    if self._requires_quotes(ident):
       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/venv/lib/python3.11/site-packages/sqlalchemy/sql/compiler.py", line 5364, in _requires_quotes
    lc_value = value.lower()
               ^^^^^^^^^^^
AttributeError: 'NoneType' object has no attribute 'lower'```

[miguelgrinberg]

First of all I'd like to ask that you follow the instructions and when you have a question about your own application use the discussion forum. The issues board is for actual bugs in Flask-Migrate, it's not the right place to ask questions. Thanks.

Now regarding your question. What is your database URL?

[skabdulhaq]

Sorry about that i was unaware of discussion forum my database URL looks like this mysql+pymysql://user:password@host:port Iam using digitalocean's managed database mysql and i even added the public certificate in

    "ssl": {
        "ssl_ca": "/etc/ssl/certs/ca-certificate.crt",
    }
}

as connection arguments

[miguelgrinberg]

Your connection URL is missing the database name. See the SELAlchemy document if you need a refresher on how database URL should be constructed.