Application Issues After MySQL Database Update

[patelsa...@gmail.com]

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

[villas]

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

[sandeep patel]

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~

--
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+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/901b6a08-70dd-47b4-bc65-e85f4c570369n%40googlegroups.com.