Hello
I faced this issue earlier and it got solved by using bench update.But now this time when i am doing bench update the error still remains same.
When i do bench update its is upto date.After that when i do bench migrate it is showing error as
_mysql_exceptions.OperationalError: (1071, ‘Specified key was too long; max key length is 1000 bytes’)
Traceback (most recent call last):
File “/usr/lib/python2.7/runpy.py”, line 174, in _run_module_as_main
“main”, fname, loader, pkg_name)
File “/usr/lib/python2.7/runpy.py”, line 72, in _run_code
exec code in run_globals
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 94, in
main()
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/utils/bench_helper.py”, line 18, in main
click.Group(commands=commands)(prog_name=‘bench’)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 722, in call
return self.main(*args, **kwargs)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 697, in main
rv = self.invoke(ctx)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 1066, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 895, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/core.py”, line 535, in invoke
return callback(*args, **kwargs)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/click/decorators.py”, line 17, in new_func
return f(get_current_context(), *args, **kwargs)
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/commands/init.py”, line 24, in _func
ret = f(frappe._dict(ctx.obj), *args, **kwargs)
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/commands/site.py”, line 217, in migrate
migrate(context.verbose, rebuild_website=rebuild_website)
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/migrate.py”, line 52, in migrate
frappe.utils.help.sync()
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/utils/help.py”, line 24, in sync
help_db.make_table()
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/utils/help.py”, line 81, in make_table
CHARACTER SET=utf8mb4’‘’)
File “/home/indictrans/webapps/benz/frappe-bench/apps/frappe/frappe/database.py”, line 165, in sql
self._cursor.execute(query)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/cursors.py”, line 250, in execute
self.errorhandler(self, exc, value)
File “/home/indictrans/webapps/benz/frappe-bench/env/local/lib/python2.7/site-packages/MySQLdb/connections.py”, line 50, in defaulterrorhandler
raise errorvalue
_mysql_exceptions.OperationalError: (1071, ‘Specified key was too long; max key length is 1000 bytes’)