Hi
I've recently updated my MySQL test server to version 5.1.61 on Ubuntu.
In my db.py I specify my field names with mixed case.
In my.cnf I have:
lower-case-table-names = 1
In the past this has always worked for me. But today, once I upgraded
MySQL, I'm getting the following on any request to any of my apps:
Traceback(most recent call last):
File"C:\dev\web2py\gluon\restricted.py",line205,inrestricted
execccodeinenvironment
File"C:/dev/web2py/applications/mustangs/models/db.py"
<http://127.0.0.1:8000/admin/default/edit/mustangs/models/db.py>,line76,in<module>
format='%(heading)s')
File"C:\dev\web2py\gluon\dal.py",line6677,indefine_table
polymodel=polymodel)
File"C:\dev\web2py\gluon\dal.py",line795,increate_table
fake_migrate=fake_migrate)
File"C:\dev\web2py\gluon\dal.py",line861,inmigrate_table
and notisinstance(table[key].type,SQLCustomType)\
File"C:\dev\web2py\gluon\dal.py",line7105,in__getitem__
returndict.__getitem__(self,str(key))
KeyError:'newsitemid'
In the database, the field name is newsItemId.
Anyone else seeing this behavior with the latest MySQL on Ubuntu? My
other MySQL tools are working as you'd expect regardless of the case I use.
-Jim
