Massimo, The error originates from 2115, but you are showing below other (correct) lines of code (line 1253 and further). I think I documented the error and the solution in http://groups.google.com/group/web2py/msg/d9d11284a1e83a3e , wil send you the patch separately.
Nico de Groot On 18 mei, 01:33, mdipierro <[email protected]> wrote: > I am going to need your help in debugging this. In sql.py around lines > 2115 > > for key in args: > if key not in [ > 'migrate', > 'primarykey', > 'fake_migrate', > 'format', > 'trigger_name', > 'sequence_name']: > raise SyntaxError, 'invalid table "%s" attribute: %s' % > (tablename, key) > > Somehow the last lines raises this exception: > > SyntaxError: invalid table "area" attribute: sequence_name > > but sequence_name is in the list above so the exception should not be > raised. > > Any idea? > > On May 17, 6:31 pm, drayco <[email protected]> wrote: > > > > > Hi, I updated my web2py, but I had a problem with web2py 1.78.3, I use > > legacy databases. When I try to go to my application I got this > > > Error traceback > > > Traceback (most recent call last): > > File "/media/RESPALDO/web2py/gluon/restricted.py", line 178, in > > restricted > > exec ccode in environment > > File "/media/RESPALDO/web2py/applications/scada/models/ > > calenergy.py", line 8, in <module> > > migrate = False) > > File "/media/RESPALDO/web2py/gluon/sql.py", line 1296, in > > define_table > > **dict(primarykey=args['primarykey'], trigger_name=trigger_name, > > sequence_name=sequence_name)) > > File "/media/RESPALDO/web2py/gluon/sql.py", line 2115, in __init__ > > raise SyntaxError, 'invalid table "%s" attribute: %s' % > > (tablename, k) > > SyntaxError: invalid table "area" attribute: sequence_name > > > In file: /media/RESPALDO/web2py/applications/scada/models/calenergy.py > > > calenergy=SQLDB('mysql://xxx:[email protected]:3306/xxx',pool_size=10) > > > calenergy.define_table('area', > > Field('clave', type = 'char' , length = 3 ), > > Field('IdZona', type = 'integer' , length = 10 ), > > Field('nombre', type = 'string' , length = 50 ), > > primarykey=['clave','IdZona'], > > migrate = False) > > > Even with web2py 1.77.3. > > > What this mean? > > > with my older version of web2py, I work well.- Tekst uit oorspronkelijk > > bericht niet weergeven - > > - Tekst uit oorspronkelijk bericht weergeven -
