There is no problem with the post count, it changes as old topics get pruned etc but I resynced it a while ago and it's close to correct.

For example you're showing 811 posts, I click your profile and search your posts (I have access to all forums remember, so may see some posts you can't), I get 'Search found 780 matches'. It means the post sync is out by 31 posts. Which would generally be caused by pruning over the last few months.

 

Mhh but ive had quite a lot more before... and i remember the number of posts of Guy or LH.
Guy lost about some thousands... so i dont think its "close to correct".

My only intention is to understand the "technical" background of this issue and the way how to deal with it, im also running a board (mybb).

As the forum is pruned, you lose posts. This however does not affect your post counter until I resync the forum again. When I resynced the forum it actually counted how many posts were on the board which each user had made. Due to a whole lot being pruned, everyone's number went down.

So i understand.. i didnt know that you pruned the forum.
Is there any reason to prune a forum except to keep it (and the db) cleaner?
i think your servers are capable enough arent they?

Because our database size is huge, and posts which are irrelevant, such as filled requests are pruned when they've been sitting there for a long time.

The last time I resynchronized was when I changed the structure of the database, but this has only happened once in 3 years.

Well I wanted to double check. Every other site I have been on works fine with no problems. So I am guessing its a Gendub issue. I just wanted to make sure I wasnt jumping the gun in blaming the Gendub server.

I get the following error when trying to open ppcwarez.info (status site):

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

Hmmm, what did you do to it?!

Fixed...

Me? Nothing.

But obviously, there has been a DNS problem yesterday during 1 or 2 hours? Neither the forum nor the info site could be reached (no DNS resolving at all). After it was obviously fixed after some time I recovered the problem with the ppcwarez.info site.

Thanks.

I just registered a few days ago and since the beginning I noticed that when I log on in the afternoon or evening CET browsing the site is really really slow and often I hit timeouts; it might be related to the number of users logged in at the same time; also it takes forever to load a page and the pictures are missing.In the morning, like right now, everything works really well and I can browse the forum smoothly. ciao, Pietro

as stated in the previous email thsi si one of the error messages i get in the evening CET

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

If you refresh and this error is still here, we may be working on the site. You can check the status page here: http://www.ppcwarez.info/


refreshing didn't help so I just reopened the home page and started browsing from there.
probably limiting the access to registered users only might help. ciao

Hmm, I have to login every time when I come back to the site (doesn't log me on automatically although the option was checked).

And another strange thing with the user statistics:


Is it true?

I upgraded PHP, and that always seems to happen when I do a live upgrade (while users are still using the site). When the sessions table settles down I will fix the login problem.

Ok, the logout issue for search and coming back to the site have both been fixed.

Thank you SD, running OK.