Announcement

Collapse
No announcement yet.

user lookup bug?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • user lookup bug?

    I have created a new user group and when I am trying to add users to the new group, however I can't seem to find any of my users.

    For example, I enter 'c' (of course without the '') in the "User Name contains" area and I only get back 21 entries.

    I click on the "list all" link above and it only displays 39 users.

    My board was recently converted from ubb 6, could this be the problem?

    Does anyone know what the select statement is this is using to obtain a list of my users?

  • #2
    In the Admin CP under Import and Maintenance, have you Updated Counters?
    Rob

    Comment


    • #3
      I sure did

      Comment


      • #4
        I think this problem may be related to groups.

        Take a look at the attached gif of when I browse the groups, then view all members of a group . . .
        Last edited by sifuhall; Wed 30 May '01, 6:29am.

        Comment


        • #5
          You need to make sure that there is a record for every user in the userfield table as well.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud demonstration site.
          vBulletin 5 API - Full / Mobile
          Vote for your favorite feature requests and the bugs you want to see fixed.

          Comment


          • #6
            The count is only counting the user table but the list of users is pulling data from the user & userfield table so it will only contain users that have valid records in both tables. As to why you would have so many records in the user table but not in the userfield table I can't really say.

            Comment


            • #7
              thanks.

              Freddie (or anyone else), do you know the specific SQL statement that is used to gather these records? I could probably find the problem with my database with this.

              Comment


              • #8
                I just tried this query through MySQL . . .

                mysql> select count(userfield.userid) from userfield,user where userfield.userid=user.userid;
                +-------------------------+
                | count(userfield.userid) |
                +-------------------------+
                | 3787 |
                +-------------------------+
                so it would appear every user has a valid entry in the userfield table.

                Any ideas where the problem may be?

                Comment


                • #9
                  Odd what do these queries return:

                  count (*) as count from user;
                  count(*) as count from userfield;

                  Comment


                  • #10
                    mysql> select count(*) from user;
                    +----------+
                    | count(*) |
                    +----------+
                    | 3787 |
                    +----------+
                    1 row in set (0.00 sec)

                    mysql> select count(*) from userfield;
                    +----------+
                    | count(*) |
                    +----------+
                    | 3787 |
                    +----------+
                    1 row in set (0.00 sec)
                    btw - I *REALLY* appreciate the help here.

                    Comment


                    • #11
                      since this problem appears as if it my take some thought is there any problem with me adding users to user groups using MySQL?

                      I'm assuming I just update the groupid in the user table, correct?

                      Comment


                      • #12
                        You should be able to do that.

                        You might try running myisamchk on the user and userfield tables to make sure the indexes are intact.
                        Translations provided by Google.

                        Wayne Luke
                        The Rabid Badger - a vBulletin Cloud demonstration site.
                        vBulletin 5 API - Full / Mobile
                        Vote for your favorite feature requests and the bugs you want to see fixed.

                        Comment

                        Loading...
                        Working...
                        X