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
