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

Fixed Importer Breaks when importing large DB

Discussion in 'Resolved Bug Reports' started by a legacy reborn, Apr 16, 2011.

  1. a legacy reborn

    a legacy reborn Well-Known Member

    I am trying to get a clients site over to xf and not only does the importer break after importing users...but it only imports 1700 out of 300,000.

    this is what I get.

    Code:
    [B]Fatal error[/B]: Allowed memory size of 67108864 bytes exhausted (tried to allocate 82 bytes) in [B]/home/wireforu/public_html/upload/library/Zend/Db/Statement/Mysqli.php[/B] on line [B]304[/B]
     
  2. Walter

    Walter Well-Known Member

  3. a legacy reborn

    a legacy reborn Well-Known Member

  4. Brogan

    Brogan XenForo Moderator Staff Member

  5. a legacy reborn

    a legacy reborn Well-Known Member

    I think ini_set might be disabled by my client's host...they changed it from 64 to 128 and the error changed

    Code:
     [B]Fatal error[/B]: Allowed memory size of 134217728 bytes exhausted (tried to allocate 24 bytes) in [B]/home/wireforu/public_html/upload/library/Zend/Db/Statement/Mysqli.php[/B] on line [B]294
    [/B]

    Update:We got it to work, but now when it comes to the merge user screen it lists all users and so my browser crashes. It tried to load all 300 k users(thinks they are all duplicates) and no one can really handle that kind of content being loaded on their browser.
     
  6. Mike

    Mike XenForo Developer Staff Member

    Are you reimporting an existing DB? You don't want to do that with the importer -- you need to import into a fresh DB.
     
  7. a legacy reborn

    a legacy reborn Well-Known Member

    It is a fresh db.
     
  8. Mike

    Mike XenForo Developer Staff Member

    I did actually find MySQL executing a query really badly that made the user import slower than it should've been. This will be fixed in the next release.
     
  9. a legacy reborn

    a legacy reborn Well-Known Member

    At least no one will have to waste 12 hours of their life ever again :) lol.
     
    Vincent likes this.

Share This Page