[CWB] [CQPweb] Manage users now throwing an error

[Scott Sadowsky]

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.

When I choose *Manage Users* now, I get the error below.

Mea culpa aside, and idea how I can fix this?

Best,
Scott

Search for user account details


An SQL query did not run successfully!

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 */

Error # 1253: COLLATION 'utf8_general_ci' is not valid for CHARACTER SET
'ascii'
PHP debugging backtrace

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"
  }
}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://liste.sslmit.unibo.it/pipermail/cwb/attachments/20190611/e72e357f/attachment.html>