[CWB] Undeletable users

Fri May 6 10:11:52 CEST 2022

I cleaned up the users on our cqpweb server (an installation with quite 
a history now) an there were a few users that I couldn't delete.

The users in question were real power users in the past, using some 
features (e.g., saved catqueries) that other users typically don't use.

I append the error message (with personal data anonymised) below. I'm 
afraid that with respect to the users in question the server might be in 
a slightly inconsistent state right now.

Jörg Knappen

CQPweb encountered an error and could not continue.

An SQL query did not run successfully!

Original query: drop table if exists /* from User: Admin | Function: 
delete_user() | 2022-May-06 10:02 */

Error # 1064: You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to 
use near '' at line 2
PHP debugging backtrace

array(7) {
   [1]=>
   array(4) {
     ["file"]=>
     string(42) "/var/www/html/cqpweb/lib/exiterror-lib.php"
     ["line"]=>
     int(367)
     ["function"]=>
     string(9) "exiterror"
     ["args"]=>
     array(3) {
       [0]=>
       array(3) {
         [0]=>
         string(38) "An SQL query did not run successfully!"
         [1]=>
         string(114) "Original query:

drop table if exists
         /* from User: Admin | Function: delete_user() | 2022-May-06 
10:02 */

"
         [2]=>
         string(161) "Error # 1064: You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near '' at line 2 "
       }
       [1]=>
       NULL
       [2]=>
       NULL
     }
   }
   [2]=>
   array(4) {
     ["file"]=>
     string(36) "/var/www/html/cqpweb/lib/sql-lib.php"
     ["line"]=>
     int(216)
     ["function"]=>
     string(18) "exiterror_sqlquery"
     ["args"]=>
     array(3) {
       [0]=>
       int(1064)
       [1]=>
       string(146) "You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right 
syntax to use near '' at line 2"
       [2]=>
       string(94) "drop table if exists
         /* from User: Admin | Function: delete_user() | 2022-May-06 
10:02 */"
     }
   }
   [3]=>
   array(4) {
     ["file"]=>
     string(41) "/var/www/html/cqpweb/lib/useracct-lib.php"
     ["line"]=>
     int(278)
     ["function"]=>
     string(12) "do_sql_query"
     ["args"]=>
     array(1) {
       [0]=>
       string(94) "drop table if exists
         /* from User: Admin | Function: delete_user() | 2022-May-06 
10:02 */"
     }
   }
   [4]=>
   array(4) {
     ["file"]=>
     string(36) "/var/www/html/cqpweb/lib/execute.php"
     ["line"]=>
     int(196)
     ["function"]=>
     string(11) "delete_user"
     ["args"]=>
     array(1) {
       [0]=>
       string(6) "abcdef"
     }
   }
   [5]=>
   array(4) {
     ["file"]=>
     string(42) "/var/www/html/cqpweb/lib/admin-execute.php"
     ["line"]=>
     int(181)
     ["args"]=>
     array(1) {
       [0]=>
       string(36) "/var/www/html/cqpweb/lib/execute.php"
     }
     ["function"]=>
     string(7) "require"
   }
   [7]=>
   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"
   }
}