hello i changed from sqlite to mysql and now i have an error
<class 'gluon.contrib.pymysql.err.ProgrammingError'> (1064, u"You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'desc VARCHAR(512),\n
validade DATE,\n PRIMARY KEY(id)\n) ENGINE=InnoDB CHARAC' at line 4")
Traceback (most recent call last):
File "/home/ubuntu/web2py/gluon/restricted.py", line 212, in restricted
exec ccode in environment
File "/home/ubuntu/web2py/applications/EMPRE/models/db.py"
<http://localhost/admin/default/edit/EMPRE/models/db.py>, line 115, in
<module>
Field('validade','date', required=True,label='Validade da
informação apresentada'))
File "/home/ubuntu/web2py/gluon/dal.py", line 7755, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "/home/ubuntu/web2py/gluon/dal.py", line 7792, in lazy_define_table
polymodel=polymodel)
File "/home/ubuntu/web2py/gluon/dal.py", line 963, in create_table
self.create_sequence_and_triggers(query,table)
File "/home/ubuntu/web2py/gluon/dal.py", line 1781, in
create_sequence_and_triggers
self.execute(query)
File "/home/ubuntu/web2py/gluon/dal.py", line 1798, in execute
return self.log_execute(*a, **b)
File "/home/ubuntu/web2py/gluon/dal.py", line 1792, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "/home/ubuntu/web2py/gluon/contrib/pymysql/cursors.py", line
117, in execute
self.errorhandler(self, exc, value)
File "/home/ubuntu/web2py/gluon/contrib/pymysql/connections.py",
line 202, in defaulterrorhandler
raise errorclass, errorvalue
ProgrammingError: (1064, u"You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'desc VARCHAR(512),\n validade DATE,\n
PRIMARY KEY(id)\n) ENGINE=InnoDB CHARAC' at line 4")
my model where i think is the problem is
db.define_table('validades',
Field
<http://localhost/examples/global/vars/Field>('empresa',db.auth_user,unique=True),
Field <http://localhost/examples/global/vars/Field>('desc',compute=lambda
row: db.auth_user[row.empresa]['empresa']),
Field <http://localhost/examples/global/vars/Field>('validade','date',
required=True,label='Validade da informação apresentada'))
# -requires
db.validades.empresa.requires=requires=IS_IN_DB
<http://localhost/examples/global/vars/IS_IN_DB>(db,
'auth_user.id','auth_user.empresa',error_message=e_m['not_in_db'])
db.validades.validade.requires=[IS_DATE(format=T('%Y/%m/%d'),error_message=T("Formato
pretendido aaa/mm/dd"))]
*What is the problem?*
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
