Hi,
I am getting a mysql error after upgrading to 2.6.1(and 2.6.2)
Web2py doesn't throw a ticket, rather the mysql error shows up directly on
the browser:
Query Not Supported: (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
'LONGTEXT)) AND
(staffnotes.is_active = 'T')) ORDER BY staffnotes.date DESC, staf' at line
1")
I have record versioning enabled on the table in question:
db.define_table('staffnotes',
Field('staffid','string'),
Field('date','datetime',requires=IS_DATETIME(format='%Y-%m-%d
%H:%M:%S'), default=request.now),
Field('comment','string'),
auth.signature,
)
db.staffnotes._enable_record_versioning()
I chose to let the migration occur rather than go through the migrate_false
steps mentioned.
The sql.log for the app revealed that migrations were performed on all
string types, but not for the 'is_active' field defined with
auth.signature. It remains defined as char(1) in mysql.
Any suggestions?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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.
