Message:
Table "db.users" doesn't exist query: SELECT COUNT(DISTINCT u.uid) FROM users u LEFT JOIN users_roles ur ON u.uid = ur.uid WHERE u.uid != 0 in /homepages/htdocs/includes/database.mysqli.inc on line 151
Patch:
File: user.module
2030c2030
< $query_count = 'SELECT COUNT(DISTINCT u.uid) FROM users u LEFT JOIN users_roles ur ON u.uid = ur.uid '. $filter['join'] .' WHERE u.uid != 0 '. $filter['where'];
---
> $query_count = 'SELECT COUNT(DISTINCT u.uid) FROM {users} u LEFT JOIN {users_roles} ur ON u.uid = ur.uid '. $filter['join'] .' WHERE u.uid != 0 '. $filter['where'];
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | user_module_missing_table_prefix.patch | 987 bytes | jose reyero |
Comments
Comment #1
jose reyero commentedYes, bug confirmed, patch works.
This may break the user administration page, as the pager wont work, so I think it should be fixed right away.
Comment #2
Vahrokh commentedJust confirming the issue, I have table prefix in settings.php and it generates an error calling
"Administer=>User Management=>Users
due to the lack of braces around the table name.
Comment #3
chx commentedThere is no patch...
Comment #4
jose reyero commentedComment #5
catchhttp://drupal.org/node/194859