installed version 1.0.4

current version: 1.0.4.1
released: 11.07.2011

latest tested phpBB-Version: 3.0.10

installed version 1.0.4

Postby marcombv » Thu Mar 03, 2011 12:49 pm

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
Posts 40 - 50
Posts 40 - 50
 
Posts: 43
Topics: 7
Images: 2
Joined: Sun Apr 06, 2008 10:41 am
Location: Amsterdam

Re: installed version 1.0.4

Postby marcombv » Fri Mar 04, 2011 11:25 pm

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. :shock:
When my uploaded pictures are approved I will show some screenshots.
marcombv
Posts 40 - 50
Posts 40 - 50
 
Posts: 43
Topics: 7
Images: 2
Joined: Sun Apr 06, 2008 10:41 am
Location: Amsterdam

Re: installed version 1.0.4

Postby marcombv » Wed Mar 09, 2011 9:52 pm

Can someone approve my uploaded pictures?

Anybody a suggestion? :o
marcombv
Posts 40 - 50
Posts 40 - 50
 
Posts: 43
Topics: 7
Images: 2
Joined: Sun Apr 06, 2008 10:41 am
Location: Amsterdam

Re: installed version 1.0.4

Postby marcombv » Sat Mar 19, 2011 7:17 pm

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.
marcombv
Posts 40 - 50
Posts 40 - 50
 
Posts: 43
Topics: 7
Images: 2
Joined: Sun Apr 06, 2008 10:41 am
Location: Amsterdam

Re: installed version 1.0.4

Postby nickvergessen » Thu Mar 24, 2011 3:11 pm

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...
cheers nickvergessen :geek:

Member of phpBB Development-Team
No Support via PM
User avatar
nickvergessen
Administrator
Administrator
 
Posts: 5748
Topics: 217
Images: 139
Joined: Mon Oct 15, 2007 4:15 pm
phpBB.de: nickvergessen
phpBB.com: nickvergessen

Re: installed version 1.0.4

Postby marcombv » Thu Mar 24, 2011 3:37 pm

Thnx Nick,

That did the trick. :mrgreen:
marcombv
Posts 40 - 50
Posts 40 - 50
 
Posts: 43
Topics: 7
Images: 2
Joined: Sun Apr 06, 2008 10:41 am
Location: Amsterdam


Return to NV usertopics

Who is online

Users browsing this forum: No registered users and 1 guest