Hi, I do this revert, thank's try: import MySQLdb drivers.append('MySQL') except ImportError: logger.debug('no MySQLdb driver')
And self.pool_connection(lambda db=db, user=credential_decoder(user), password=credential_decoder(password), host=host, port=port, charset=charset: MySQLdb.Connection(db=db, user=user, passwd=password, host=host, port=port, charset=charset, )) In dal.py However, the error is still appear Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/models/cfedb.py", line 16, in <module> migrate = False) File "/home/drayco/web2py/gluon/dal.py", line 3457, in define_table sequence_name=sequence_name)) File "/home/drayco/web2py/gluon/dal.py", line 3741, in __init__ "primarykey must be a list of fields from table '%s " % tablename SyntaxError: primarykey must be a list of fields from table 'med_dnpmst_4 Well I think this is a problem with compatibility. Do you have any suggestions? On Jan 14, 6:36 pm, Luther Goh Lu Feng <elf...@yahoo.com> wrote: > To test if the issue is with pymysql, you could edit the dal file to > use mysqldb > > http://code.google.com/p/web2py/source/diff?spec=svnfc75444ca55590835... > > On Jan 13, 11:31 am, drayco <antrod...@gmail.com> wrote: > > > I need that some of you guys check this, in my case, Pymysql have some > > issues with legacy databases (First, I think this issue is of new dal, > > but I'm not sure) > > However mysqldb, my application work well > > > this is my report: > > >http://groups.google.com/group/web2py/browse_thread/thread/72e91e281e... > > > On Jan 12, 11:46 am, Vasile Ermicioi <elff...@gmail.com> wrote: > > > > hi, > > > > Massimo, there is a new version of pymysql > > > > I think pymysql has a few advantages > > > - being pure Python, PyMySQL is easily patched by gevent and the likes to > > > make it cooperative > > > >http://code.google.com/p/pymysql/wiki/WhyPyMySQL > > > > I use it with web2py and works fine > >