1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.1 Lost 5,000 members on import

Discussion in 'Installation, Upgrade, and Import Support' started by Razasharp, Jul 30, 2012.

  1. Razasharp

    Razasharp Well-Known Member

    I've done a test import and seem to have lost around 5,000 members - is there a known reason for this? (I've checked banned members and they seem to be there, and we rarely delete members.)

    When the importer asked about duplicate emails in user accounts I just edited the email addresses.
    I checked the box to preserve member/thread ids

    Any ideas what might have gone on?
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Are you referring to the member count on the index page? That number excludes banned users, user awaiting email confirmation, and user awaiting approval.
    Razasharp and CyclingTribe like this.
  3. Razasharp

    Razasharp Well-Known Member

    Ah right yeah, thanks Jake!

    Is there anyway to make it show all of them? We often get people asking us to ban their account for X weeks/months as they can't keep away themselves, etc. Plus it looks better showing more members lol
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    The responsible code:


    	 * Gets the count of total users.
    	 * @return integer
    	public function countTotalUsers()
    		return $this->_getDb()->fetchOne('
    			SELECT COUNT(*)
    			FROM xf_user
    			WHERE user_state = \'valid\'
    				 AND is_banned = 0
    You can modify it directly or create an addon to extend the model.
    Adam Howard and Razasharp like this.
  5. Razasharp

    Razasharp Well-Known Member

    Thanks, awesome - it works!! :)
  6. duderuud

    duderuud Active Member

    There's also a resource that does that (I believe one from Ragtek, can't find it right now)
    Razasharp likes this.
  7. ragtek

    ragtek Guest

  8. Razasharp

    Razasharp Well-Known Member

Share This Page