"List All Users" shows nothing

[irogers]

I have a user reporting: "There is a problem , i can't register on forums as my email address is said false." I tried to create an account with their username, and I'm told one already exists.

When I try to look up this user using Users->Find->List All Users from the control panel, I see "Only one user found matching that criteria..." for an instant and then it shows me my profile (as if I'm the only user in the DB).

When I go User Groups->Modify, I see 13 registered users, and 2 users awaiting email conf. However, when I choose "List All Users" for either, I see "No Users Matching That Criteria" (see attached image).

I upgraded from 2.2.5 to 2.2.6, but this didn't solve the problem. I'm running PHP 4.2.0, MySQL 3.23.49-log (whatever that means on FreeBSD 4.5-RELEASE.

Thanks in advance,
ian

[Michael König]

Have you compared your user table with your userfield table? Both have to contain the same amount of users.

If an userid is not also stored in the Table userfield, you can't find him in your Admin CP, or with "List all Users"

You can fix this manually by inserting an entry in the table userfield for each userid or check my Posting here (2nd one)

Mystics

[irogers]

Nope, that's not the problem:

mysql> select count(*) from user;
+----------+
| count(*) |
+----------+
| 16 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from userfield;
+----------+
| count(*) |
+----------+
| 16 |
+----------+
1 row in set (0.00 sec)

ian

[Michael König]

OK, but have you compared the contents of the tables? All userids in the user table have also to exist in the userfield table.

user userfield
1 -> 1
5 -> 5
6 -> 6
and so on.

Mystics

[irogers]

Looks all good, no?

mysql> select userid from user;
+--------+
| userid |
+--------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
+--------+
16 rows in set (0.00 sec)

mysql> select userid from userfield;
+--------+
| userid |
+--------+
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 10 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
+--------+
16 rows in set (0.00 sec)

ian