Skip to main content

TypeError: 'options' is an invalid keyword argument for Connection() What do i do? [closed]

if im doing anything wrong then im sorry its my first time using stack overflow and python. Im trying to setup FCMS for the game Elite Dangerous Because i want to modify stuff and upgrade it a bit And keep Getting an error wich from what i read is probably from sqlalchmy:

Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Scripts\initialize_FCMS_db.exe\__main__.py", line 7, in <module>
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\FCMS\scripts\initialize_db.py", line 34, in main
    with env['request'].tm:
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\transaction\_manager.py", line 142, in __exit__
    self.commit()
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\transaction\_manager.py", line 133, in commit
    return self.get().commit()
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\transaction\_transaction.py", line 282, in commit
    raise v.with_traceback(tb)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\transaction\_transaction.py", line 273, in commit
    self._commitResources()
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\transaction\_transaction.py", line 456, in _commitResources
    raise v.with_traceback(tb)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\transaction\_transaction.py", line 428, in _commitResources
    rm.tpc_begin(self)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\zope\sqlalchemy\datamanager.py", line 140, in tpc_begin
    self.session.flush()
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\session.py", line 4312, in flush
    self._flush(objects)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\session.py", line 4447, in _flush
    with util.safe_reraise():
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\session.py", line 4408, in _flush
    flush_context.execute()
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 466, in execute
    rec.execute(self)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\unitofwork.py", line 642, in execute
    util.preloaded.orm_persistence.save_obj(
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\persistence.py", line 60, in save_obj
    for (
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\persistence.py", line 221, in _organize_states_for_save
    for state, dict_, mapper, connection in _connections_for_states(
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\persistence.py", line 1726, in _connections_for_states
    connection = uowtransaction.transaction.connection(base_mapper)
                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in connection
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\state_changes.py", line 139, in _go
    ret_value = fn(self, *arg, **kw)
                ^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\session.py", line 995, in connection
    return self._connection_for_bind(bind, execution_options)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in _connection_for_bind
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\state_changes.py", line 139, in _go
    ret_value = fn(self, *arg, **kw)
                ^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\session.py", line 1129, in _connection_for_bind
    conn = self._parent._connection_for_bind(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "<string>", line 2, in _connection_for_bind
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\state_changes.py", line 139, in _go
    ret_value = fn(self, *arg, **kw)
                ^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\orm\session.py", line 1143, in _connection_for_bind
    conn = bind.connect()
           ^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\engine\base.py", line 3268, in connect
    return self._connection_cls(self)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\engine\base.py", line 145, in __init__
    self._dbapi_connection = engine.raw_connection()
                             ^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\engine\base.py", line 3292, in raw_connection
    return self.pool.connect()
           ^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 452, in connect
    return _ConnectionFairy._checkout(self)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 1269, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 716, in checkout
    rec = pool._do_get()
          ^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\impl.py", line 169, in _do_get
    with util.safe_reraise():
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\impl.py", line 167, in _do_get
    return self._create_connection()
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 393, in _create_connection
    return _ConnectionRecord(self)
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 678, in __init__
    self.__connect()
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 902, in __connect
    with util.safe_reraise():
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\util\langhelpers.py", line 146, in __exit__
    raise exc_value.with_traceback(exc_tb)
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\pool\base.py", line 898, in __connect
    self.dbapi_connection = connection = pool._invoke_creator(self)
                                         ^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\engine\create.py", line 637, in connect
    return dialect.connect(*cargs, **cparams)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\mmuch\Desktop\FCMS-master\FCMS\env\Lib\site-packages\sqlalchemy\engine\default.py", line 616, in connect
    return self.loaded_dbapi.connect(*cargs, **cparams)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
TypeError: 'options' is an invalid keyword argument for Connection()

it tried changing python versions and playing around with modules but i just cant get it to work



source https://stackoverflow.com/questions/77629494/typeerror-options-is-an-invalid-keyword-argument-for-connection-what-do-i-d

Comments

Popular posts from this blog

Prop `className` did not match in next js app

I have written a sample code ( Github Link here ). this is a simple next js app, but giving me error when I refresh the page. This seems to be the common problem and I tried the fix provided in the internet but does not seem to fix my issue. The error is Warning: Prop className did not match. Server: "MuiBox-root MuiBox-root-1" Client: "MuiBox-root MuiBox-root-2". Did changes for _document.js, modified _app.js as mentioned in official website and solutions in stackoverflow. but nothing seems to work. Could someone take a look and help me whats wrong with the code? Via Active questions tagged javascript - Stack Overflow https://ift.tt/2FdjaAW

How to show number of registered users in Laravel based on usertype?

i'm trying to display data from the database in the admin dashboard i used this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count(); echo $users; ?> and i have successfully get the correct data from the database but what if i want to display a specific data for example in this user table there is "usertype" that specify if the user is normal user or admin i want to user the same code above but to display a specific usertype i tried this: <?php use Illuminate\Support\Facades\DB; $users = DB::table('users')->count()->WHERE usertype =admin; echo $users; ?> but it didn't work, what am i doing wrong? source https://stackoverflow.com/questions/68199726/how-to-show-number-of-registered-users-in-laravel-based-on-usertype

Why is my reports service not connecting?

I am trying to pull some data from a Postgres database using Node.js and node-postures but I can't figure out why my service isn't connecting. my routes/index.js file: const express = require('express'); const router = express.Router(); const ordersCountController = require('../controllers/ordersCountController'); const ordersController = require('../controllers/ordersController'); const weeklyReportsController = require('../controllers/weeklyReportsController'); router.get('/orders_count', ordersCountController); router.get('/orders', ordersController); router.get('/weekly_reports', weeklyReportsController); module.exports = router; My controllers/weeklyReportsController.js file: const weeklyReportsService = require('../services/weeklyReportsService'); const weeklyReportsController = async (req, res) => { try { const data = await weeklyReportsService; res.json({data}) console