Can you please explain this sentence "Web2py doesn't throw a ticket, rather
the mysql error shows up directly on the browser"? Where do you see this
error? What steps caused it? Can you post a screenshot?
You have a field called "date". That should not be allowed. Are you sure it
worked before?
Massimo
On Saturday, 14 September 2013 20:28:24 UTC-5, tomt wrote:
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
