Dear Web2py Community,
I hope this message finds you well.
I am reaching out to seek your assistance regarding an issue I am
experiencing with my application. After updating the database version from
MySQL 5.7 to MySQL 8.0.35, my application has encountered problems and is
no longer functioning as expected.
Here are the details of my setup:
Python Version: 3.8.10
Web2py Version: 2.27.1
Thank you in advance for your support and assistance. I look forward to
your suggestions and advice.
Here is the issue I am getting:
Traceback (most recent call last):
File "/home/ubuntu/api_server/web2py/gluon/restricted.py", line 219, in
restricted
exec(ccode, environment)
File
"/home/ubuntu/api_server/web2py/applications/warehouse/controllers/default.py",
line 1910, in <module>
File "/home/ubuntu/api_server/web2py/gluon/globals.py", line 463, in
<lambda>
self._caller = lambda f: f()
File
"/home/ubuntu/api_server/web2py/applications/warehouse/controllers/default.py",
line 208, in user
form=auth()
File "/home/ubuntu/api_server/web2py/gluon/tools.py", line 2047, in
__call__
return getattr(self, args[0])()
File "/home/ubuntu/api_server/web2py/gluon/tools.py", line 3008, in login
user = table_user(**{username: entered_username})
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/objects.py", line
683, in __call__
self._db(query)
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/objects.py", line
2686, in select
return adapter.select(self.query, fields, attributes)
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 885, in select
return self._select_aux(sql, fields, attributes, colnames)
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 842, in _select_aux
rows = self._select_aux_execute(sql)
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 836, in _select_aux_execute
self.execute(sql)
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
line 66, in wrap
if not args[0].connection:
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/connection.py",
line 33, in connection
return self.get_connection()
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/connection.py",
line 66, in get_connection
connection = self.connector()
File
"/home/ubuntu/api_server/web2py/gluon/packages/dal/pydal/adapters/mysql.py",
line 65, in connector
conn = self.driver.connect(**self.driver_args)
File "/home/ubuntu/api_server/web2py/gluon/contrib/pymysql/__init__.py",
line 90, in Connect
return Connection(*args, **kwargs)
File
"/home/ubuntu/api_server/web2py/gluon/contrib/pymysql/connections.py", line
688, in __init__
self.connect()
File
"/home/ubuntu/api_server/web2py/gluon/contrib/pymysql/connections.py", line
905, in connect
self._get_server_information()
File
"/home/ubuntu/api_server/web2py/gluon/contrib/pymysql/connections.py", line
1231, in _get_server_information
self.server_charset = charset_by_id(lang).name
File "/home/ubuntu/api_server/web2py/gluon/contrib/pymysql/charset.py",
line 38, in by_id
return self._by_id[id]
KeyError: 255
Best regards,
Sandeep
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/8a008ac4-6fd6-40fe-b29a-529f6c173e34n%40googlegroups.com.
