Hi Folks,
I am trying to create some tables using DAL + Mysql and I got:
Ticket ID
127.0.0.1.2012-12-05.11-51-55.a267bd2c-0651-43c1-8194-56f3e5ee8fb8
<class 'gluon.contrib.pymysql.err.InternalError'> (1005, u"Can't create
table 'frasesdb.frase' (errno: 150)")
This is my model:
db.define_table('tag',
Field('nome', requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db, 'tag.nome')],
unique=True),
format='%(nome)s')
from smarthumb import SMARTHUMB
box = (250, 250)
db.define_table('frase',
Field('frase', requires=IS_NOT_EMPTY()),
Field('slug', requires=IS_SLUG()),
Field('tag', 'list:reference tag'),
Field('site', 'reference site', requires=IS_IN_DB(db, 'site.id',
'%(dominio)s')),
Field('image_filename', readable=False, writable=False),
Field('image', 'upload', requires=IS_IMAGE(), uploadseparate=True,
autodelete=True),
Field('thumb', 'upload', requires=IS_IMAGE(), compute = lambda row:
SMARTHUMB(row.image, box), autodelete=True),
Field('postar_em', 'datetime', default=None),
format='%(frase)s')
Why does it happen? I could see some posts on the list about it but none
seems to solve my problem.
Regards,
Tito
--
Linux User #387870
.........____
.... _/_õ|__|
..º[ .-.___.-._| . . . .
.__( o)__( o).:_______
--
