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.
