Forums

SystemError: more argument specifiers than keyword list entries (remaining format:'s#|O!O!O!')

Could you please tell me how can I resolve this issue? When running o localhost everything is ok but everything crashes when trying to run the function on the server. I've created virtualenv and installed all libraries manually:

2021-06-08 10:05:29,064: Exception on /content_repository [POST] Traceback (most recent call last): File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/flask/app.py", line 2070, in wsgi_app response = self.full_dispatch_request() File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/flask/app.py", line 1515, in full_dispatch_request rv = self.handle_user_exception(e) File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/flask/app.py", line 1513, in full_dispatch_request rv = self.dispatch_request() File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/flask/app.py", line 1499, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**req.view_args) File "/home/BusinessIntelligencePF23/SEO_Tools/pythonlogin/main.py", line 189, in content_repository data = sql.execute_query( File "/home/BusinessIntelligencePF23/SEO_Tools/pythonlogin/sql_connector.py", line 45, in execute_query connection = mysql.connector.connect( File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/mysql/connector/__init__.py", line 272, in connect return CMySQLConnection(*args, **kwargs) File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/mysql/connector/connection_cext.py", line 85, in __init__ self.connect(**kwargs) File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/mysql/connector/abstracts.py", line 1007, in connect self._post_connection() File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/mysql/connector/abstracts.py", line 979, in _post_connection self.set_charset_collation(self._charset_id) File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/mysql/connector/abstracts.py", line 937, in set_charset_collation self._execute_query("SET NAMES '{0}' COLLATE '{1}'".format( File "/home/BusinessIntelligencePF23/.virtualenvs/seo_tool_env/lib/python3.8/site-packages/mysql/connector/connection_cext.py", line 506, in cmd_query self._cmysql.query(query, SystemError: more argument specifiers than keyword list entries (remaining format:'s#|O!O!O!')

It looks like you're introducing some sort of formatting code into your SQL. Check the SQL that you're generating to send to the database and make sure it's what you expect it to be.