ok I'll send a PR on github right away. TY for spotting this.
On Saturday, August 3, 2013 2:41:33 PM UTC+2, Adi wrote:
>
> Niphlod... as always... that did it :)
>
> only one field that I saw:
> Field('title', unique=True, length=255),
>
> Thank you!
>
>
> On Saturday, August 3, 2013 8:23:09 AM UTC-4, Niphlod wrote:
>>
>> dreaded mysql...... dropping the support for it will cut in half
>> developing time.
>>
>> Seems the same problem that hit the scheduler since default length for
>> columns was altered.
>>
>> Can you try to alter gluon/tools.py in the wiki class, where the table
>> are defined, adding "length=255" to every column that has a unique=True
>> constraint ?
>> If that works out, we pinned it down properly ^_^
>>
>> On Saturday, August 3, 2013 2:06:13 PM UTC+2, Adi wrote:
>>>
>>> Upgraded from 2.5.1 to 2.6.0, and it seems that auth.wiki is causing
>>> this. If I comment it out, everything else works fine.
>>>
>>> #auth.wiki(resolve=False)
>>> #wiki = Wiki(auth=auth, render='html')
>>>
>>>
>>> Ticket ID
>>>
>>> 127.0.0.1.2013-08-03.08-03-20.34cb1611-c6d4-46fc-b59e-106ad21d723e
>>> <class 'gluon.contrib.pymysql.err.InternalError'> (1071, u'Specified key
>>> was too long; max key length is 767 bytes') Version web2py™ Version
>>> 2.6.0-development+timestamp.2013.08.01.08.22.32 Traceback
>>>
>>> 1.
>>> 2.
>>> 3.
>>> 4.
>>> 5.
>>> 6.
>>> 7.
>>> 8.
>>> 9.
>>> 10.
>>> 11.
>>> 12.
>>> 13.
>>> 14.
>>> 15.
>>> 16.
>>> 17.
>>> 18.
>>> 19.
>>> 20.
>>> 21.
>>> 22.
>>> 23.
>>> 24.
>>> 25.
>>> 26.
>>> 27.
>>>
>>> Traceback (most recent call last):
>>> File "/Users/adnan/web2py24/gluon/restricted.py", line 212, in restricted
>>> exec ccode in environment
>>> File "/Users/adnan/web2py24/applications/bsp/models/db.py"
>>> <http://127.0.0.1:8000/admin/default/edit/bsp/models/db.py>, line 84, in
>>> <module>
>>> auth.wiki(resolve=False)
>>> File "/Users/adnan/web2py24/gluon/tools.py", line 3467, in wiki
>>> function=function)
>>> File "/Users/adnan/web2py24/gluon/tools.py", line 5152, in __init__
>>> db.define_table(key, *args, **value['vars'])
>>> File "/Users/adnan/web2py24/gluon/dal.py", line 7779, in define_table
>>> table = self.lazy_define_table(tablename,*fields,**args)
>>> File "/Users/adnan/web2py24/gluon/dal.py", line 7816, in lazy_define_table
>>> polymodel=polymodel)
>>> File "/Users/adnan/web2py24/gluon/dal.py", line 1021, in create_table
>>> fake_migrate=fake_migrate)
>>> File "/Users/adnan/web2py24/gluon/dal.py", line 1126, in migrate_table
>>> self.execute(sub_query)
>>> File "/Users/adnan/web2py24/gluon/dal.py", line 1816, in execute
>>> return self.log_execute(*a, **b)
>>> File "/Users/adnan/web2py24/gluon/dal.py", line 1810, in log_execute
>>> ret = self.cursor.execute(command, *a[1:], **b)
>>> File "/Users/adnan/web2py24/gluon/contrib/pymysql/cursors.py", line 117,
>>> in execute
>>> self.errorhandler(self, exc, value)
>>> File "/Users/adnan/web2py24/gluon/contrib/pymysql/connections.py", line
>>> 202, in defaulterrorhandler
>>> raise errorclass, errorvalue
>>> InternalError: (1071, u'Specified key was too long; max key length is 767
>>> bytes')
>>>
>>>
>>>
--
---
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.
