Announcement

Collapse
No announcement yet.

user Vs. userfield

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

  • #16
    Originally posted by freddie
    There are no adverse effects to having this if state if everyone can login. I would think this could only happen if you pruned your user table directly via the database.
    Freddie, there are adverse affects. The posts of the missing 2500 show up as 'Guest' and the attachments in their posts do not show up. The problem is that the backup db was made with a very old version of MySQL(he didn't know the exact version) and he's importing it into MySQL 4.0.12.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #17
      Sure they show up as guest, but he said 'everyone' can login so I take that to indicate that the missing 2500 are not wanted.

      Comment


      • #18
        And their attachments don't show up, even though the attachments are in the database.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #19
          Originally posted by snakes1100
          Ok the script works for missing users in the "userfield table", BUT what if you have 6000 members in the userfield and only 3500 members in the "user table"?

          But all of them can still log in and post with no issues.
          Sure, there will be no problem if you have more users in userfield than in the user table...it's only a problem, if you have a less amount of users in the userfield table or if an userid is missing from userfield.

          This script will also remove all unnecessary entries in your userfield table.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X