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

Reply via email to