<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-GB;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.errormessage, li.errormessage, div.errormessage
{mso-style-name:errormessage;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Verdana",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US">There’s a fix for this bug in the repo already – Andrew.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> cwb-bounces@sslmit.unibo.it <cwb-bounces@sslmit.unibo.it>
<b>On Behalf Of </b>Scott Sadowsky<br>
<b>Sent:</b> 11 June 2019 18:44<br>
<b>To:</b> Open source development of the Corpus WorkBench <CWB@liste.sslmit.unibo.it><br>
<b>Subject:</b> [CWB] [CQPweb] Manage users now throwing an error<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">This one seems to be my fault, as I was deleting an obsolete corpus, user groups and users as part of a spring cleaning, as it were, and this problem appeared.<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">When I choose <i>Manage Users</i> now, I get the error below. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mea culpa aside, and idea how I can fix this?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Best,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Scott<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<table class="MsoNormalTable" border="1" cellpadding="0" width="1440" style="width:1080.0pt;border:solid white 4.5pt">
<tbody>
<tr>
<td colspan="3" style="border:solid white 1.5pt;background:#FF8899;padding:5.25pt 2.25pt 5.25pt 2.25pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-US">Search for user account details<o:p></o:p></span></b></p>
</td>
</tr>
<tr>
<td colspan="3" style="border:solid white 1.5pt;background:#FFCFDD;padding:2.25pt 5.25pt 2.25pt 5.25pt">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-US"> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="border:solid white 1.5pt;background:#DDDDFF;padding:2.25pt 5.25pt 2.25pt 5.25pt">
<p class="errormessage"><span style="font-size:18.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-US">An SQL query did not run successfully!<o:p></o:p></span></p>
<p class="errormessage"><span style="font-size:18.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-US">Original query: select username from user_info order by username collate utf8_general_ci /* from User: scott | Function: list_sql_values()
| 2019-Jun-11 14:40 */<o:p></o:p></span></p>
<p class="errormessage"><span style="font-size:18.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-US">Error # 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'ascii'<o:p></o:p></span></p>
</td>
<td style="border:none;padding:.75pt .75pt .75pt .75pt"></td>
<td style="border:none;padding:.75pt .75pt .75pt .75pt"></td>
</tr>
<tr>
<td style="border:solid white 1.5pt;background:#FF8899;padding:5.25pt 2.25pt 5.25pt 2.25pt">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:EN-US">PHP debugging backtrace<o:p></o:p></span></b></p>
</td>
<td style="border:none;padding:.75pt .75pt .75pt .75pt"></td>
<td style="border:none;padding:.75pt .75pt .75pt .75pt"></td>
</tr>
<tr>
<td style="border:solid white 1.5pt;background:#DDDDFF;padding:2.25pt 5.25pt 2.25pt 5.25pt">
<pre><span style="color:black;mso-fareast-language:EN-US">array(8) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(300)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(9) "exiterror"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(3) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(3) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(38) "An SQL query did not run successfully!"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(167) "Original query: <o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"><o:p> </o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US">select username from user_info order by username collate utf8_general_ci <o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> /* from User: scott | Function: list_sql_values() | 2019-Jun-11 14:40 */<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"><o:p> </o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US">"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(81) "Error # 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'ascii' "<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> NULL<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> NULL<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(198)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(20) "exiterror_mysqlquery"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(3) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(1253)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(66) "COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'ascii'"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [2]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(147) "select username from user_info order by username collate utf8_general_ci <o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> /* from User: scott | Function: list_sql_values() | 2019-Jun-11 14:40 */"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [3]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(36) "/var/www/html/cqpweb/lib/sql-lib.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(537)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(12) "do_sql_query"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(1) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(147) "select username from user_info order by username collate utf8_general_ci <o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> /* from User: scott | Function: list_sql_values() | 2019-Jun-11 14:40 */"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [4]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(1955)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(15) "list_sql_values"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(1) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(72) "select username from user_info order by username collate utf8_general_ci"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [5]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(1923)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(34) "do_adm_bitui_user_quicksearch_form"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(2) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(0) ""<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [1]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(4) "link"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [6]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(2649)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(27) "do_adm_bitui_usersearchform"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(0) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [7]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(38) "/var/www/html/cqpweb/lib/adminhome.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(260)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(19) "do_adm_ui_useradmin"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(0) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [8]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(4) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["file"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(34) "/var/www/html/cqpweb/adm/index.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["line"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> int(1)<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["args"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> array(1) {<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> [0]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(38) "/var/www/html/cqpweb/lib/adminhome.php"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> ["function"]=><o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> string(7) "require"<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US"> }<o:p></o:p></span></pre>
<pre><span style="color:black;mso-fareast-language:EN-US">}<o:p></o:p></span></pre>
</td>
<td style="border:none;padding:.75pt .75pt .75pt .75pt"></td>
<td style="border:none;padding:.75pt .75pt .75pt .75pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</body>
</html>