Hi, I did my test with trunk version
this is the issue
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
On Jan 18, 9:50 pm, Massimo Di Pierro <massimo.dipie...@gmail.com>
wrote:
> I just included the latest pymysql in trunk. Does it make things
> better?
>
> On Jan 18, 6:05 pm, drayco <antrod...@gmail.com> wrote:
>
> > 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
>
>
