This helps a lot. Can you please email me (confidentially) your email and
controller?
On Saturday, 14 September 2013 21:15:11 UTC-5, tomt wrote:
>
> Yes, the program worked before. The error appears when I select the
> 'note_list' function/controller. I've attached a screenshot.(I hope it
> works)
>
> When I re-install web2py_src-2.5.1 the note_list function works without
> error.
>
> - Tom
>
> On Saturday, September 14, 2013 7:34:18 PM UTC-6, Massimo Di Pierro wrote:
>>
>> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
