Is this problem related to the functionality of the mod or also the server load ? Especially on larger boards with 400-500K posts, it seems like all of these psots have to be searched for smilies and other stuff than just the bbcodes.marc1706 wrote:Well, the problem is that you have 409 bbcodes and therefore this MOD has to take a look through all your posts 409-times. The smiley count is also an issue, maybe I'll exclude the smilies that are not displayed on posting from the top smilies in the future.
I agree, i hope no problems rise during validating. regarding stokers test, then it might be worth knowing that he uses a dedicated server with 6gb ram and quad core for 1 site. Many boards are on a shared service, same server features but with 1000+ users per server. so it might take a bit longer. A option to turn some stuff off somehow seems like a good ideamarc1706 wrote:It took Stokerpiller's board 77.5 seconds to query through all the posts for all the 409 BBCodes, which equals looking through around 6 million posts. About 77k posts are processed per second, which means that looking for the usual 13 BBCodes will take around 84 seconds on a board with 500k posts. So, yes large boards with that many posts will chocke on the Miscellaneous Statistics of the current version of this MOD.
I already have something in mind, that will reduce the queryload for these stats, but I'll first try to get this MOD validated by the phpBB.com MOD Team.
I get this when I try to view Forum Activity. Is it because it is generating a high server load?General Error
SQL ERROR [ mysqli ]
Error writing file '/tmp/MYE5GOAf' (Errcode: 28) 
SELECT COUNT(DISTINCT p.poster_id) AS count, f.forum_id AS f_id, f.forum_name AS f_name FROM phpbb_posts p, phpbb_forums f WHERE p.forum_id = f.forum_id AND p.post_approved = 1 GROUP BY f_id ORDER BY count DESC LIMIT 10
I had exactly the same problem... I rechecked all of my edits, copied all files to their respective places and had no luck until I came here and made the same edit as the user above.kmxak wrote:(i have installed the mod
but it show only a blank white page?!
in which file is the mistake?)
Ok i fixed the stats code with your code at the top of this page
and now it works fine
but by me it gave no error only a blank page
Lostmind over at Startrekguide fixed this for me and now it is perfect for BF_Vista.Lucian_rider wrote:My only problem is that I am using BF_Vista which is a subsilver2 based style and has rotating background images. The Stats page can be very difficult to read due to the transparent background effect and the type of image being displayed at the time. If anyone knows how to create a solid background for just that page, please let me know...
it gives a newer and better version of the modAvdon wrote:Hello,
In my board there are:
- 386131 posts
- 3923 users
- 930 MB database
Is that a problem for installing and using this mod?