<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style>body { line-height: 1.5; }body { font-size: 10.5pt; font-family: 'Microsoft YaHei UI'; color: rgb(0, 0, 0); line-height: 1.5; }</style>
</head>
<body>
<div><span></span>Hello,</div>
<div><br>
</div>
<div>When config mailman3-web with SQLite, it works OK. But when config it with mysql, it always says:</div>
<div><br>
</div>
<div>django.db.utils.OperationalError: (1071, 'Specified key was too long; max key length is 767 bytes')</div>
<div>dpkg: error processing package mailman3-web (--configure):</div>
<div> subprocess installed post-installation script returned error exit status 1</div>
<div><br>
</div>
<div><img src="cid:_Foxmail.1@d6d71d4d-690b-bd89-7852-11f9fd661153" border="0"></div>
<div><br>
</div>
<div>In /var/log/mailman3/web/mailman-web.log, there is below:</div>
<div>---------</div>
<div>
<div>ERROR 2018-04-25 13:08:05,397 13557 hyperkitty.lib.utils Failed to update the fulltext index: (1146, "Table 'mailman3web.hyperkitty_email' doesn't exist")</div>
<div>Traceback (most recent call last):</div>
<div> File "/usr/lib/python2.7/dist-packages/hyperkitty/lib/utils.py", line 186, in run_with_lock</div>
<div> fn(*args, **kwargs)</div>
<div> File "/usr/lib/python2.7/dist-packages/hyperkitty/search_indexes.py", line 87, in update_index</div>
<div> update_cmd.update_backend("hyperkitty", "default")</div>
<div> File "/usr/lib/python2.7/dist-packages/haystack/management/commands/update_index.py", line 240, in update_backend</div>
<div> total = qs.count()</div>
<div> File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 364, in count</div>
<div> return self.query.get_count(using=self.db)</div>
<div> File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 499, in get_count</div>
<div> number = obj.get_aggregation(using, ['__count'])['__count']</div>
<div> File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 480, in get_aggregation</div>
<div> result = compiler.execute_sql(SINGLE)</div>
<div> File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 899, in execute_sql</div>
<div> raise original_exception</div>
<div>ProgrammingError: (1146, "Table 'mailman3web.hyperkitty_email' doesn't exist")</div>
</div>
<div>---------</div>
<div><br>
</div>
<div>If run $dpkg-reconfigure mailman3-web</div>
<div><br>
</div>
<div>It says mailman3-web is broken or not fully installed.</div>
<div><br>
</div>
<div>Rex</div>
</body>
</html>