From owner-freebsd-questions@FreeBSD.ORG Mon May 10 04:34:02 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id CFFDF106564A for ; Mon, 10 May 2010 04:34:02 +0000 (UTC) (envelope-from scrappy@hub.org) Received: from hub.org (hub.org [200.46.204.220]) by mx1.freebsd.org (Postfix) with ESMTP id 7AE838FC16 for ; Mon, 10 May 2010 04:34:02 +0000 (UTC) Received: from maia.hub.org (maia-1.hub.org [200.46.208.211]) by hub.org (Postfix) with ESMTP id 59CC834559C4; Mon, 10 May 2010 01:34:01 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 99574-10; Mon, 10 May 2010 04:33:51 +0000 (UTC) Received: by hub.org (Postfix, from userid 1002) id 1C0613455941; Mon, 10 May 2010 01:34:01 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by hub.org (Postfix) with ESMTP id 1A05B345593F; Mon, 10 May 2010 01:34:01 -0300 (ADT) Date: Mon, 10 May 2010 01:34:01 -0300 (ADT) From: "Marc G. Fournier" To: Bobby Walker In-Reply-To: Message-ID: References: <4BE03042.5010806@ipv6canada.com> <4BE0A341.1010207@a1poweruser.com> <4BE0E8B1.3000802@a1poweruser.com> , <4BE21B75.80308@a1poweruser.com> , <4BE758F1.1000608@comclark.com> User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-questions@freebsd.org Subject: Re: BSDstats website displaying data incorrectly X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 10 May 2010 04:34:03 -0000 Just to elaborate on the issue ... it looks like both of those pages are using different QUERIES to the database ... in the former, it is using a system view that I was able to update after we fixed the issue with country reporting, such that it doesn't show records older then that date ... the latter page is pulling the data via a different method (which Bobby is looking into) so that its actually pulling in older date (ie. a two months average vs just the past 10 days or so) ... Both are accurate, just different time periods ... On Sun, 9 May 2010, Bobby Walker wrote: > > On May 9, 2010, at 7:53 PM, Aiza wrote: > >> Bobby Walker wrote: >>>>>>> >>>>>>>>>>>> On Thu, 6 May 2010, Fbsd1 wrote: >>>>>>>>>>>>> Why does this page show PCBSD has count of 387 >>>>>>>>>>>>> http://www.bsdstats.org/bt/home.html?os= >>>>>>>>>>>>> And this page shows PCBSD has count of 1307 >>>>>>>>>>>>> http://www.bsdstats.org/bt/home.html?os=PC-BSD >>>>>>>>>>>>> Why is this? I would think both should show the same value, or you >>>>>>>>>>>>> better add explanation to the web page why the count is different. >>> This was a database setup problem, and I've updated the code to pull out of the proper database. if anyone notices any other discrepancies please let me know. >>> Thanks, >>> Bobby_______________________________________________ >>> freebsd-questions@freebsd.org mailing list >>> http://lists.freebsd.org/mailman/listinfo/freebsd-questions >>> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" >> Why does >> http://www.bsdstats.org/ >> and >> http://bsdstats.hub.org/bt/home.html?os=FreeBSD >> still show different counts if you fixed this problem? > > I made the correction on the development site and did not have any issues. In fact, I still don't have problems with it at all. On the live site, though, there's something amiss with the way the template system is interacting with the database. So, I'm trying to track down the problem. > > Here are my temporary hurdles, I'm still wading through the template system. The more familiar I get with the layout of that, the faster things seem to go. And I usually get an hour or so a day to work with it. But, I am plugging away at it. > > I'll post an update when I isolate the erroneous problems. Thanks for the heads up! > > -- Bobby > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. scrappy@hub.org http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:scrappy@hub.org