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'];

CommentFileSizeAuthor
#4 user_module_missing_table_prefix.patch987 bytesjose reyero

Comments

jose reyero’s picture

Priority: Normal » Critical
Status: Active » Reviewed & tested by the community

Yes, 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.

Vahrokh’s picture

Just 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.

chx’s picture

Status: Reviewed & tested by the community » Active

There is no patch...

jose reyero’s picture

Status: Active » Reviewed & tested by the community
StatusFileSize
new987 bytes
catch’s picture

Status: Reviewed & tested by the community » Closed (duplicate)