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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
