'bigint' is not a valid type in web2py. It never was. It never appeared in any documentation.
BTW. You should use Field, not SQLField. SQLField was deprecated 2 years ago. On Feb 17, 10:42 am, Rupesh Pradhan <[email protected]> wrote: > I made the table definition script using the script that was in the > following post:https://groups.google.com/d/topic/web2py/AnJ0iPH0WaI/discussion > > of an existing MySQL table. > > web2py_win_1.91.6 did not complain about the following table definition and > work just fine. > > db.define_table('admin', > SQLField('ID', type = 'bigint' , length = 20 ), > SQLField('StudentID', type = 'string' , length = 50 ), > SQLField('Checked', type = 'string' , length = 1 ), > migrate = False) > > When i upgraded to version web2py_1.92.1, I am getting the following error: > > Traceback (most recent call last): > File "gluon/restricted.py", line 188, in restricted > File "D:/web2py/applications/sandbox/models/db.py", line 7, in <module> > File "gluon/dal.py", line 3488, in define_table > File "gluon/dal.py", line 3758, in __init__ > SyntaxError: duplicate field ID in table admin > > When I delete the first line of the SQLField i.e. > > SQLField('ID', type = 'bigint' , length = 20 ) > > obviously, the error does not occur! > > Am I going to have to stick to web2py_win_1.91.6, because it works? > > Version information is given below: > > web2py™ Version 1.92.1 (2011-02-16 15:04:40) > Python Python 2.5.4: D:\web2py\web2py_no_console.exe
