Date: Mon, 10 May 2010 01:34:01 -0300 (ADT) From: "Marc G. Fournier" <scrappy@hub.org> To: Bobby Walker <bobbyjwalker@live.com> Cc: freebsd-questions@freebsd.org Subject: Re: BSDstats website displaying data incorrectly Message-ID: <alpine.BSF.2.00.1005100132110.85296@hub.org> In-Reply-To: <BLU0-SMTP90DC84292B7B022774FF24BBF90@phx.gbl> References: <4BE03042.5010806@ipv6canada.com> <4BE0A341.1010207@a1poweruser.com> <alpine.BSF.2.00.1005042107170.85296@hub.org> <alpine.BSF.2.00.1005042135120.85296@hub.org> <4BE0E8B1.3000802@a1poweruser.com> <alpine.BSF.2.00.1005050138530.85296@hub.org>, <4BE21B75.80308@a1poweruser.com> <alpine.BSF.2.00.1005060137380.85296@hub.org> <BLU0-SMTP91EDD238061EFDFFCFE278BBF50@phx.gbl> <alpine.BSF.2.00.1005061323510.85296@hub.org> <BLU0-SMTP84B9215F3CF70390245AFBBBF50@phx.gbl>, <alpine.BSF.2.00.1005061447120.85296@hub.org> <SNT140-w49860A105514F3B57052A4BBF50@phx.gbl> <alpine.BSF.2.00.1005062358360.85296@hub.org> <BLU0-SMTP8644C44E249424087F4AC4BBF60@phx.gbl> <alpine.BSF.2.00.1005070105510.85296@hub.org> <BLU0-SMTP75E16A4297155549C4361CBBF80@phx.gbl> <4BE758F1.1000608@comclark.com> <BLU0-SMTP90DC84292B7B022774FF24BBF90@phx.gbl>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?alpine.BSF.2.00.1005100132110.85296>