Database query problem!?

[Fulgorke]

I get the message below when I try to have a closer look at the ip address of some of my exit links, I get it for more than half of the ip addresses, I only clicked visits from the last 4 days!
The strange thing though is that these ip addresses do not excist (or at least don't appear) in the recent page load (or any other) page...:confused:

"The ip address 137.99.88.179 is no longer present in your log of the last xxx number of pageloads."

Also the amount of unique visitors you see in the summary page (both SC3 and SC4) does not correspond with the stats when you look at the recent visitor activity (or page load activity), mostly the summary shows you more visitors there there were following the recent visitor activity/ page load ...

Thanks,
Geert

P.S.: this is for goemie.blogspot.com

[webado]

The log for exit links is the same size as the regular log and it will therefore have many exits matching entry hits which are no longer present in the regular log. That's a little bug that needs to be fixed - to harmonize the contents of the exit links log with the regular hit log to avoid this message.

[webmaster]

Hi Geert,

Thanks for the bug report.

The issue with the "The ip address 137.99.88.179 is no longer present in your log of the last xxx number of pageloads." message occurs for the following reason.

At present, you have 3 separate logs with SC4.

1. The usual pageview one that SC3 has.
2. The exit link log
3. The download log

This means your exit link and download log may have entries for a visitor that have long since been overwritten in the pageview log.

This is not intuitive, so we are not finished with the user interface for SC4 yet. This needs to be handled better.

Regarding your issue for the difference between the summary page and the rest of the stats - can I point you to the FAQ at the bottom of the summary stats page that reads:

How do the Summary Stats work?

The 'Summary Stats' determines whether a visitor has been to your website before by using a cookie. So if a user has cookies disabled we have no way of knowing if they are unique or not, and will by default be considered unique. However the majority of visitors have cookies enabled.

To make up for relying on cookies in the summary stats, the rest of the stats are based on your detailed log analysis of the last xxx number of pageloads. The uniqueness in this case is based on your visitors' IP addresses. This method works very well for the majority, but yet again there is an exception. AOL users, and visitors who use what is known as a 'dynamic web proxy' that changes each time they access a webpage. So if a single AOL user visits 7 webpages on your website it will likely come up as 7 different IP addresses!

Both cookies and IP addresses have their strengths and weaknesses for determining the uniqueness of a visitor. It is impossible to be 100% accurate the entire time, but with the Standard StatCounter Project you get the best of both worlds. Cookies for the 'Summary Stats' and IP addresses for the 'Detailed Log Analysis'!


Thanks again for posting and trying out the beta!

Aodhan

[Fulgorke]

Aodhan & Chrisooc,

Thank you very much for the explanations, they were very enlightening :-)
Though for the first part (exit links) I am pretty sure that it's not because the pageview log has been overwritten already, at least not in my case I think. My site does not get very many visitors, hence it is pretty easy for me to track irregularities for specific users or days. For example yesterday (21st) I had 10 page loads from 4 different visitors. I had 3 exit links (from 2 different visitors), one was found in the 'database' the other one not (see first post [137.99.88.179 ]). So I guess this can't be because of no longer being in the database, or can it?
The two exit links that aren't present in the database (!?) also appeared at a moment (3 am) when there weren't any pageloads recorded (first was at 7.15 am), so I think there is something more "buggy" going on over there.
Another thing I noticed already a couple of times is that the "logging" or showing of the logging sometimes happens (a lot) later in SC4 than in SC3, sometimes this is a question of minutes, sometimes hours.
These aren't crucial things, but still hope it helps, you show us incredible things, thanks for that.
Geert

[Fulgorke]

Hi again,

The first visitor came in at 2-ish am, registered and shown as such in SC3.
This same visitor wasn't showing yet at 11 am (so 9 hours later) in SC4.
Second one got in at 10 am (SC3), wasn't showing yet at 11, was at 3.30 pm (SC4)
Third one in at 1 pm (SC3), came in at SC4 at 4 pm!
The entry times displayed are the same in both, but the just show later in SC4.:roll:
Am I the only person where this happens?
G

[Fulgorke]

P.S.: The entries from 2 pm (Brussels time) are comming in at this moment (4.40 pm) in SC4 :confused::mrgreen:;-)

[webmaster]

There is a small lag with the sc4 beta stats today. We are working on it.

[Fulgorke]

There is a small lag with the sc4 beta stats today. We are working on it.

Thanks, it looks as if everything is going fine again:-D