<div dir="ltr">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.<div><br></div><div>When I choose <i>Manage Users</i> now, I get the error below. </div><div><br></div><div>Mea culpa aside, and idea how I can fix this?</div><div><br></div><div>Best,</div><div>Scott</div><div><br></div><div><table class="gmail-concordtable gmail-fullwidth" style="width:1510px;border-style:solid;border-color:rgb(255,255,255);border-width:5px;color:rgb(0,0,0);font-family:"Times New Roman";font-size:medium"><tbody><tr><th colspan="3" class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">Search for user account details</th></tr><tr><td class="gmail-concordgeneral" colspan="3" style="padding:3px 7px;background-color:rgb(255,207,221);font-size:10pt;border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif"> </td></tr><tr><td class="gmail-concorderror" style="padding:3px 7px;background-color:rgb(221,221,255);font-size:10pt;border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif"><p class="errormessage" style="font-size:large">An SQL query did not run successfully!</p><p class="errormessage" style="font-size:large">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 */</p><p class="errormessage" style="font-size:large">Error # 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'ascii'</p></td></tr><tr><th class="gmail-concordtable" style="padding:7px 3px;background-color:rgb(255,136,153);border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif">PHP debugging backtrace</th></tr><tr><td class="gmail-concorderror" style="padding:3px 7px;background-color:rgb(221,221,255);font-size:10pt;border-style:solid;border-color:rgb(255,255,255);border-width:2px;font-family:"Open Sans",Arial,Helvetica,Verdana,sans-serif"><pre>array(8) {
[1]=>
array(4) {
["file"]=>
string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
["line"]=>
int(300)
["function"]=>
string(9) "exiterror"
["args"]=>
array(3) {
[0]=>
array(3) {
[0]=>
string(38) "An SQL query did not run successfully!"
[1]=>
string(167) "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 */
"
[2]=>
string(81) "Error # 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'ascii' "
}
[1]=>
NULL
[2]=>
NULL
}
}
[2]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(198)
["function"]=>
string(20) "exiterror_mysqlquery"
["args"]=>
array(3) {
[0]=>
int(1253)
[1]=>
string(66) "COLLATION 'utf8_general_ci' is not valid for CHARACTER SET 'ascii'"
[2]=>
string(147) "select username from user_info order by username collate utf8_general_ci
        /* from User: scott | Function: list_sql_values() | 2019-Jun-11 14:40 */"
}
}
[3]=>
array(4) {
["file"]=>
string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
["line"]=>
int(537)
["function"]=>
string(12) "do_sql_query"
["args"]=>
array(1) {
[0]=>
string(147) "select username from user_info order by username collate utf8_general_ci
        /* from User: scott | Function: list_sql_values() | 2019-Jun-11 14:40 */"
}
}
[4]=>
array(4) {
["file"]=>
string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"
["line"]=>
int(1955)
["function"]=>
string(15) "list_sql_values"
["args"]=>
array(1) {
[0]=>
string(72) "select username from user_info order by username collate utf8_general_ci"
}
}
[5]=>
array(4) {
["file"]=>
string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"
["line"]=>
int(1923)
["function"]=>
string(34) "do_adm_bitui_user_quicksearch_form"
["args"]=>
array(2) {
[0]=>
string(0) ""
[1]=>
string(4) "link"
}
}
[6]=>
array(4) {
["file"]=>
string(45) "/var/www/html/cqpweb/lib/admin-home-forms.php"
["line"]=>
int(2649)
["function"]=>
string(27) "do_adm_bitui_usersearchform"
["args"]=>
array(0) {
}
}
[7]=>
array(4) {
["file"]=>
string(38) "/var/www/html/cqpweb/lib/adminhome.php"
["line"]=>
int(260)
["function"]=>
string(19) "do_adm_ui_useradmin"
["args"]=>
array(0) {
}
}
[8]=>
array(4) {
["file"]=>
string(34) "/var/www/html/cqpweb/adm/index.php"
["line"]=>
int(1)
["args"]=>
array(1) {
[0]=>
string(38) "/var/www/html/cqpweb/lib/adminhome.php"
}
["function"]=>
string(7) "require"
}
}</pre></td></tr></tbody></table></div></div>