You mean character set UTF? Make sure environment variable set to UTF. Have had problems with Windows being NON UTF before.
*Ben Duncan* DBA / Chief Software Architect Mississippi State Supreme Court Electronic Filing Division On Tue, Feb 19, 2019 at 2:58 PM Andrea Fae' <and...@gmail.com> wrote: > Hello, I deleted a foreign key and I was able to import. But I have a > strange problem. When I export all data is ok, when I import I don't have > problems to do now but in mysql database some information chenged! > > Could it depend on the charset umtf....? > Thank you in advance who will answer. > > Il giorno lunedì 18 febbraio 2019 08:57:38 UTC+1, Web2_3py ha scritto: >> >> Hi, >> >> I am having the same error (Failure to connect). >> >> I checked the connection to mysql using python command line >> 1 >> 2 >> >>> import mysql.connector >> >>> mysql.connector.connect(host='localhost',database='mysql',user='root' >> ,password='') >> and it is success. >> >> What could be the reason of that error? >> >> Thanks. >> >> On Wednesday, February 13, 2019 at 10:55:32 PM UTC+3, Andrea Fae' wrote: >>> >>> >>> <type 'exceptions.RuntimeError'> Failure to connect, tried 5 times: >>> Traceback (most recent call last): File >>> "C:\web2py\gluon\packages\dal\pydal\base.py", line 454, in __init__ >>> self._adapter = adapter(**kwargs) File >>> "C:\web2py\gluon\packages\dal\pydal\adapters\__init__.py", line 40, in >>> __call__ obj = super(AdapterMeta, cls).__call__(*args, **kwargs) File >>> "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 368, in >>> __init__ super(SQLAdapter, self).__init__(*args, **kwargs) File >>> "C:\web2py\gluon\packages\dal\pydal\adapters\base.py", line 52, in __init__ >>> self.reconnect() File "C:\web2py\gluon\packages\dal\pydal\connection.py", >>> line 172, in reconnect self.connection = self.connector() File >>> "C:\web2py\gluon\packages\dal\pydal\adapters\mysql.py", line 52, in >>> connector return self.driver.connect(**self.driver_args) File >>> "C:\web2py\gluon\contrib\pymysql\__init__.py", line 90, in Connect return >>> Connection(*args, **kwargs) File >>> "C:\web2py\gluon\contrib\pymysql\connections.py", line 688, in __init__ >>> self.connect() File "C:\web2py\gluon\contrib\pymysql\connections.py", line >>> 905, in connect self._get_server_information() File >>> "C:\web2py\gluon\contrib\pymysql\connections.py", line 1231, in >>> _get_server_information self.server_charset = charset_by_id(lang).name File >>> "C:\web2py\gluon\contrib\pymysql\charset.py", line 38, in by_id return >>> self._by_id[id] KeyError: 255 >>> >>>> >>>> >>>> -- > 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. > For more options, visit https://groups.google.com/d/optout. > -- 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. For more options, visit https://groups.google.com/d/optout.
