You have a lot of indexes into one table Em segunda-feira, 23 de setembro de 2013 08h47min08s UTC-3, frasse escreveu: > > Hi All > I try to follow migration recommendation for mysql in web2py 2.6.4 . as > follow > > 1. I am setting migrate_enabled=False > 2. everything is ok > 3. length=255 to string Fields > 4. everything is ok > 5. re-enable migrations with migrate_enabled=True > 6. application crash > > Here is Error > > Traceback (most recent call last): > File "/var/web2py/gluon/restricted.py", line 217, in restricted > exec ccode in environment > File "/var/web2py/applications/myapp/models/db.py" > <https://farzad.dipconnect.com/admin/default/edit/btcpirates/models/db.py>, > line 72, in <module> > auth.define_tables() > File "/var/web2py/gluon/tools.py", line 1728, in define_tables > format='%(first_name)s %(last_name)s (%(id)s)')) > File "/var/web2py/gluon/dal.py", line 7895, in define_table > table = self.lazy_define_table(tablename,*fields,**args) > File "/var/web2py/gluon/dal.py", line 7932, in lazy_define_table > polymodel=polymodel) > File "/var/web2py/gluon/dal.py", line 1029, in create_table > fake_migrate=fake_migrate) > File "/var/web2py/gluon/dal.py", line 1136, in migrate_table > self.execute(sub_query) > File "/var/web2py/gluon/dal.py", line 1833, in execute > return self.log_execute(*a, **b) > File "/var/web2py/gluon/dal.py", line 1827, in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > File "/var/web2py/gluon/contrib/pymysql/cursors.py", line 117, in execute > self.errorhandler(self, exc, value) > File "/var/web2py/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') > > > any idea > Thanks > Frasse >
-- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
