As this error seems to indicate a mismatch in the expected char set of the
data.
You can either connect with the correct char set, or convert your data for
example to unicode. There are DB tools to help, if you search online.
In my experience, char set problems can be tricky, especially if, heaven
forbid, you end up mixing them in the same DB.
BTW I am not very conversant with MySql and I only replied because you have
been waiting for 3 days. Hopefully, others will also make suggestions, if
they have any.
Best wishes
On Monday 27 May 2024 at 15:39:04 UTC+1 patelsa...@gmail.com wrote:
> 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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/901b6a08-70dd-47b4-bc65-e85f4c570369n%40googlegroups.com.
