Could be this table 'frase' exists of is a mysql keyword?
On Wednesday, 5 December 2012 15:31:37 UTC-6, Tito Garrido wrote:
>
> 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).:_______
>
--
