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.
