Thank you @villas for guidance. I'm pleased to inform you that I have
identified and fixed the problem. The application is now running smoothly.
Many Thanks
SP~
On Thu, May 30, 2024 at 5:25 PM villas <villa...@gmail.com> wrote:
> 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
> <https://groups.google.com/d/msgid/web2py/901b6a08-70dd-47b4-bc65-e85f4c570369n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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/CA%2BvcePXORUXR%2BKsDwH7FT3pz15pbuZnaxjUw7Mnv%3DrrfyjUx6Q%40mail.gmail.com.
