Hi,
I have just started with web2py, setting up a simple page with MySQL.
In db.py I added/changed the following:
db = DAL('mysql://root:xxxxxxx@localhost:3306/test')
db.define_table('testdata',Field('idtestdata'),Field('nyckel'),Field('data'))
But when accessing the app I get an error ticket:
Ticket ID
127.0.0.1.2011-12-21.11-11-59.27d5caca-b9cf-4f73-b3e7-4a7a61318e19
<class 'gluon.contrib.pymysql.err.InternalError'> (1060, u"Duplicate column
name
'nyckel'")
Shouldn't define_table create or just use the table which is already present in
the database?
Any suggestions are welcome.
Regards,
Axel