</font><blockquote><font size="1" face="">quote:</font><hr /><font size="" face="">Originally posted by Brett Harris:
If not, you can search for users whose U_Approved flag is set to IS NULL
</font><hr /></blockquote><font size="" face="">To clearify some things here!

1. I haven't uppgraded my "live" forum yet so the problem is with 5.5.1 not the upgrade (Maybe I should start a new topic :-))

2. I have tried to upgrade but on a copy.

3. The strange users can't be found at all after the upgrade.

4. In 5.5.1 there is no Aproved field.

5. On the main page the total number of users that are displayed are correct but when I check under Admin -> User Stat, the number of users is aprox 1000 less.

6. At some point I did some modifications to the Index thing that was recomended a while ago. Can it be something wrong there? How can I check that the db structure is ok?

Thanks!

/Stefan