[phpOpenTracker-devel] [Bug #7348] Error in num_one_time_visitors / num_returning_visitors

Bug #7348, was updated on 2006-May-01 23:36
Here is a current snapshot of the bug.

Project: phpOpenTracker
Category: None
Status: Open
Resolution: None
Bug Group: None
Priority: 5
Submitted by: netzkind
Assigned to : none
Summary: Error in num_one_time_visitors / num_returning_visitors

Details: Hi everyone,

i just checked with some of our websites, and was pretty astounished that we had "minus 416" "one-time-visitors".

Can't be a negative number though.

@developers:
please see into returning_visitors.php, function _numReturningVisitors

The SQL-statement reads like "SELECT COUNT(visitors.visitor_id) AS returning_visitors [...]", but it should read "SELECT COUNT(DISTINCT(visitors.visitor_id)) AS returning_visitors [...]".

At least this leaves me with more believable numbers, and is coherent to the call in function _numUniqueVisitors.

Best,
julian

Follow-Ups:

Date: 2006-May-01 23:51
By: netzkind

Comment:
Sorry, didn't mention it: this goes for 1.5.2
-------------------------------------------------------

For detailed info, follow this link:
http://developer.berlios.de/bugs/?func=detailbug&bug_id=7348&group_id=2025