[ 273 posts ]  Go to page Previous  1 ... 8, 9, 10, 11, 12, 13, 14 ... 19  Next
Author Message
 Post: #151 | Post subject: Re: Re:
PostPosted: Sun Sep 13, 2009 1:14 am 
Site Technician
User avatar

Posts: 2774
Location: localhost
WRZ$: 16156.73

Device: It broke
cyclo wrote:
sdawson wrote:
I did synchronize which is what caused the post count to drop for a lot of users.


I dont know the phpbb at all (familiar with mybb) but i think most of the board scripts are close to each other.
i heard that the admin cp of phpbb is quite a small chaos :)

so back to the problem... all of the posts are in the database right?
so phpbb isnt able to get the correct post count by synchronizing?

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.




Top
 Offline Profile  
 
 Post: Advertisement
PostPosted: Sun Sep 13, 2009 1:14 am 
The Advertiser

Posts:
Location: Mobilism

 
Top
  
 
 Post: #152 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sun Sep 13, 2009 11:32 am 
Ultra Releaser
Emeritus Moderator
User avatar

Posts: 2915
WRZ$: 9737.90

Device: HTC Desire S
OS: Android
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).




Top
 Offline Profile  
 
 Post: #153 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sun Sep 13, 2009 6:57 pm 
Site Technician
User avatar

Posts: 2774
Location: localhost
WRZ$: 16156.73

Device: It broke
cyclo wrote:
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.




Top
 Offline Profile  
 
 Post: #154 | Post subject:
PostPosted: Sun Sep 13, 2009 9:15 pm 
Ultra Releaser
Emeritus Moderator
User avatar

Posts: 2915
WRZ$: 9737.90

Device: HTC Desire S
OS: Android
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?




Top
 Offline Profile  
 
 Post: #155 | Post subject: Re:
PostPosted: Mon Sep 14, 2009 1:04 am 
Site Technician
User avatar

Posts: 2774
Location: localhost
WRZ$: 16156.73

Device: It broke
cyclo wrote:
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.




Top
 Offline Profile  
 
 Post: #156 | Post subject: Do you have an error or is the site crawling
PostPosted: Wed Sep 30, 2009 12:30 pm 
User avatar

Posts: 1
Location: CA
WRZ$: 50.10

Device: Not Specified
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.




Top
 Offline Profile  
 
 Post: #157 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sat Oct 10, 2009 1:40 pm 
VIP
User avatar

Posts: 659
Location: Europe
WRZ$: 718.61
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

_________________
monkey12




Top
 Offline Profile  
 
 Post: #158 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sat Oct 10, 2009 11:41 pm 
Site Technician
User avatar

Posts: 2774
Location: localhost
WRZ$: 16156.73

Device: It broke
monkey12 wrote:
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...




Top
 Offline Profile  
 
 Post: #159 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sun Oct 11, 2009 7:14 am 
VIP
User avatar

Posts: 659
Location: Europe
WRZ$: 718.61
sdawson wrote:
monkey12 wrote:
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?!

Me? Nothing. :lol:

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.

_________________
monkey12




Top
 Offline Profile  
 
 Post: #160 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sun Oct 11, 2009 7:20 am 

Posts: 5
Location: Milan, Italy
WRZ$: 50.60

Device: Iphone 3G
OS: iPhone OS
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




Top
 Offline Profile  
 
 Post: #161 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sun Oct 11, 2009 4:48 pm 

Posts: 5
Location: Milan, Italy
WRZ$: 50.60

Device: Iphone 3G
OS: iPhone OS
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




Top
 Offline Profile  
 
 Post: #162 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Fri Oct 16, 2009 9:42 pm 
VIP
User avatar

Posts: 659
Location: Europe
WRZ$: 718.61
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:

Code:
In total there are 20223 users online :: 176 registered, 19 hidden and 20028 guests (based on users active over the past 15 minutes)
Most users ever online was 20227 on Fri Oct 16, 2009 9:40 pm

Is it true? :lol:

_________________
monkey12




Top
 Offline Profile  
 
 Post: #163 | Post subject:
PostPosted: Fri Oct 16, 2009 11:28 pm 
Site Technician
User avatar

Posts: 2774
Location: localhost
WRZ$: 16156.73

Device: It broke
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.




Top
 Offline Profile  
 
 Post: #164 | Post subject:
PostPosted: Sat Oct 17, 2009 2:00 am 
Site Technician
User avatar

Posts: 2774
Location: localhost
WRZ$: 16156.73

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




Top
 Offline Profile  
 
 Post: #165 | Post subject: Re: Do you have an error, or is the site crawling?
PostPosted: Sat Oct 17, 2009 6:45 am 
VIP
User avatar

Posts: 659
Location: Europe
WRZ$: 718.61
Thank you SD, running OK.

_________________
monkey12




Top
 Offline Profile  
 
 [ 273 posts ]  Go to page Previous  1 ... 8, 9, 10, 11, 12, 13, 14 ... 19  Next

All times are UTC





All content © 2006-2011 Mobilism. Contact us | Privacy policy | Terms & conditions | Copyright policy
Powered by ServerBlast and phpBB © 2000, 2002, 2005, 2007 phpBB Group