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

really confusing numbers.

Discussion in 'XenForo Questions and Support' started by jonsidneyb, Apr 2, 2012.

  1. jonsidneyb

    jonsidneyb Well-Known Member

    How is it that I am past rebuilding 88,000 threads but my forum only shows that it has a little over 57,000
     
  2. jonsidneyb

    jonsidneyb Well-Known Member

    And it fails.
     
  3. RobParker

    RobParker Well-Known Member

    Did you find out why? Been running my import for 12 hours and finally up to this stage and it's rebuilt 80,000+ threads, despite me only having 60,000
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That's the difference between the row count and the range of thread_ids. There can be gaps in the ids. So I can have these thread_ids:

    1,2,8,9,10

    The rebuild will show up to the number 10 when it processes the batches. But I really only have 5 threads.

    If the rebuild is failing then you can try a smaller or larger batch size.
     
  5. RobParker

    RobParker Well-Known Member

    Cheers

    It completed on something like 90,000.

    Some more confusing numbers I imagine you know the answer to, any idea why when I look at the database in phpmyadmin, the number of records for some of the tables are negative (e.g. ~413,841)?
     
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  7. RobParker

    RobParker Well-Known Member

    Ah balls, I've been up all night and the font was so small it looked like a -

    Cheers
     

Share This Page