Hi,
After having errors in PostgreSQL, I moved to MySQL and also got errors.
With MySQL, I can't create some tables (but some tables worked!).
Error:
Traceback (most recent call last):
File "/home/dotcloud/current/gluon/restricted.py", line 204, in restricted
exec ccode in environment
File
"/home/dotcloud/rsync-1325304927060/applications/myapp/models/db_wizard.py",
line 54, in <module>
migrate=settings.migrate)
File "/home/dotcloud/current/gluon/dal.py", line 5097, in define_table
polymodel=polymodel)
File "/home/dotcloud/current/gluon/dal.py", line 705, in create_table
self.create_sequence_and_triggers(query,table)
File "/home/dotcloud/current/gluon/dal.py", line 1348, in
create_sequence_and_triggers
self.execute(query)
File "/home/dotcloud/current/gluon/dal.py", line 1359, in execute
return self.log_execute(*a, **b)
File "/home/dotcloud/current/gluon/dal.py", line 1353, in log_execute
ret = self.cursor.execute(*a, **b)
File "/home/dotcloud/current/gluon/contrib/pymysql/cursors.py", line 108, in
execute
self.errorhandler(self, exc, value)
File "/home/dotcloud/current/gluon/contrib/pymysql/connections.py", line 184,
in defaulterrorhandler
raise errorclass, errorvalue
InternalError: (1005, u"Can't create table 'mysql.sub_comment' (errno: 150)")
My sub_comment table is defined as follow:
db.define_table('sub_comment',
Field('sub', type='reference sub',
label=T('Sub')),
Field('user', type='reference auth_user',
label=T('User')),
Field('date_added', type='datetime',
label=T('Date Added')),
Field('error_types', type='list:reference error_type',
label=T('Error Type')),
Field('balises', type='list:reference balise',
label=T('Balise')),
Field('content', type='text', notnull=True, required=True,
label=T('Content')),
auth.signature,
format='%(content)s',
migrate=settings.migrate)
And the referenced tables are already created by web2py (worked)
Maybe "list:" doesn't work with MySQL?
Best regards,
Thomas
