installed version 1.0.4

[marcombv]

Everything looks fine.

When a new topic is created the counters adds 1.
But when I use the resync butten in the ACP panel, it takes for about one hour and then a white screen appears?
In the meantime the forum is inaccessible for normal users
And after that the topic counter still displays 0.

I have a large board with:
Messages: 605178
Topics: 35361
Images: 26708
Members: 6979

Cheers Marco

[marcombv]

I also mentioned another strange thing.

When you have more then 5000 postings the last two items of your profile are missing.

When you have less then 5000 postings the two missing items are there?

We have only about 20 members with 5000+ postings, so it is not a big problem.
When my uploaded pictures are approved I will show some screenshots.

[marcombv]

Can someone approve my uploaded pictures?

Anybody a suggestion?

[marcombv]

Okay I found the solution for the problem with the freezing ACP panel:
After installing the mod open: includes/acp/acp_main.php

Find:

Code: Select all

$sql = 'SELECT COUNT(p.post_id) AS num_topics, u.user_id
                     FROM ' . USERS_TABLE . ' u
                     LEFT JOIN   ' . TOPICS_TABLE . ' t ON (u.user_id = t.topic_poster)
                     LEFT JOIN   ' . POSTS_TABLE . ' p ON (p.post_id = t.topic_first_post_id AND p.post_postcount = 1)
                     GROUP BY u.user_id';
                  $result = $db->sql_query($sql);

Replace with

Code: Select all

     $sql = array(
      'SELECT'   => 'COUNT(p.post_id) AS num_topics, u.user_id',
      'FROM'      => array(TOPICS_TABLE => 't', POSTS_TABLE => 'p', USERS_TABLE => 'u'),
      'WHERE'      => 'u.user_id = t.topic_poster
      AND p.post_id = t.topic_first_post_id
      AND p.post_postcount = 1',
      'GROUP_BY'   => 'u.user_id',
   );
   $result = $db->sql_query($db->sql

The only problem now still are the users with 5000+ topics.

[nickvergessen]

For the 5000 Post stuff see includes/functions_display.php

Code: Select all

   // Do not display user activity for users having more than 5000 posts...
   if ($userdata['user_posts'] > 5000)
   {
      return;
   }

You can easily increase the value of 5000 here...

[marcombv]

Thnx Nick,

That did the trick.