#952 closed defect (bug) (fixed)
SQL error when deleting user "Unknown column 'user_id' in 'where clause'"
| Reported by: |
|
Owned by: | |
|---|---|---|---|
| Milestone: | 1.0 | Priority: | low |
| Severity: | minor | Version: | 1.0-alpha-1 |
| Component: | General - Administration | Keywords: | sql, delete, user |
| Cc: |
Description
When deleting a user, the following error is shown:
DB Error in WP_Users::delete_user: Unknown column 'user_id' in 'where clause'
DELETE FROM bbpress_users WHERE user_id = 4
(There is no "user_id" field in the bbpress_users table - it's called "ID")
The user existed and was displayed in the User section of the admin panel. And when I refreshed the admin panel > Users, the user was gone. It appeared that the deletion actually occurred, but there was an error displayed indicating that it didn't.
I was able to recreate this with 2 different users and took a 20 second video of the 2nd time here showing the error and the fact that the user is actually gone afterward:
Fixed in [BP122]
Thanks!