NO matter what, accesslog is empty and stays that way.

By Dabitch on 31 Aug 2007 at 18:16 UTC

Anyone else have this happen to them?

Got Drupal 4.7 (6)

I've enabled watchdog and "statistics" modules

I've gone to admin/settings/statistics and enabled statistics.

At admin/logs/hits it's empty, tracking pages is empty, tracking anything (except watchdog logs which works just fine) is empty. The accesslog table in the mysql database is empty. Dropping this and then re-creating it has it still empty. The variables table in mysql correctly show that I've enabled statistics....

Arite, what am I missing here?

Comments

i have had the same problem

allen074 commented 31 August 2007 at 18:26

i have had the same problem for 1 year now - no one seems to know why :(

Yeah I've seen that other

Dabitch commented 3 September 2007 at 08:02

Yeah I've seen that other people have this issue and the replies always ask the person to turn the module on. Would be nice to figure out why this is happening, and maybe fix it, wouldn't it?

I don't have this issue in another site which is 5.1 , or even on the exact copy of this site that I use as a sandbox, same database, same modules, same content the only difference is that it does not have clean URL's. Tracking works fine there! Strange huh?

By the way, I do have comments' on so that can't be it.

(no title)

cog.rusty commented 3 September 2007 at 08:58

There was an issue for something similar happening when the comment module was not enabled. I think that was never fixed for 4.7.

----------

Edited to add: Found the issues:

http://drupal.org/node/87590
http://drupal.org/node/102353

Thanks, that was interesting

Dabitch commented 3 September 2007 at 10:02

Thanks, that was interesting to read, and reminds me to share a bit more on my issue.

Users can still be "tracked", that is you go to the users page, or your own at yourdomain.com/user/(number)/track
Here you'll find most everything that the user ever commented on just fine.

It is the nodes referers and so on that are not tracked. There is no information at yourdomain.com/node/(number)/track where Timesort icon Referrer User Operations glare back totally empty.

At yourdomain.com/admin/logs I get all the watchdog chatter like one should, but at admin/logs/referrers I get nothing, admin/logs/hits nothing, admin/logs/visitors empty as well and yeah admin/logs/pages is empty too.

I seem to have a knack for finding mystery bugs that nobody in the drupal community has tackled and fixed (though plenty have seen) so I'd be thrilled - no, really - as I'm sure allen074 will be as well if someone knows what might be causing this and can point us to the right direction. Thanks. :)

I'm now on Drupal 5.3 and

Dabitch commented 22 October 2007 at 14:28

I'm now on Drupal 5.3 and tracker still doesn't track (access_log is empty). What to do? Why does it work flawlessly on my other Drupal sites (also 5.3 originally 5.1) and not on this one? Weird.

Did you check?

Sara Adams commented 24 October 2007 at 00:50

Did you check whether logging was enabled on http://www.yoursite.com/admin/logs/settings ?

Best wishes,

-- Sara

Yes, logging is enabled and

Dabitch commented 24 October 2007 at 07:57

Yes, logging is enabled and always has been. This is why I find it rather strange. ;) I've also experimented with turning this on and off before coming here for help.

I also get plenty of information on the admin/logs/hits pages so clearly part of it (the watchdog part) it is working.

I just had a thought, there's a bit of a redirect on my site, so if people use an old link like url/12345.php they are directed to url/node/12345 instead. Could this be related? Still, it would put something in the access logs even if it was 'wrong' referers, wouldn't it?

My second comment, after

Dabitch commented 26 October 2007 at 10:17

My second comment, after explaining in the post that I had it enabled, I say "Yeah I've seen that other people have this issue and the replies always ask the person to turn the module on. Would be nice to figure out why this is happening"

So now that we've gon through the obligatory "have you turned it on?" part (YES), anyone have any idea as to why this is happening or where we might search for the problem?

If many people are experiencing it, and none of these people know why, might there be another module for example that conflicts with this one?

Hoping for some input. (Not picking Sara Adams btw, just want the thread to move forward)

acces is empty, acceslog has information - track? shows nothing

Dabitch commented 26 October 2007 at 11:19

Wait, let me explain exactly what's going on my in my freshly upgraded drupal 5.3 since things have changed for the better (but it seems not yet perfect) since I upgraded.

in mysql -
table access still clean as a whistle - remove this and everything breaks however.
table accesslog now contains stuff. Arite, so we're halfway there then?

turned on OK? Yes.
admin/logs/settings - enabled
admin/logs/visitors - has stuff
admin/logs/search - has stuff
admin/logs/hits - has stuff
admin/logs/referrers - has stuff!

empty pages (this is my problem right here)
mysite.com/node/random-node-number/track
mysite.com/node/random-node-number/track?sort=asc&order=User
mysite.com/node/random-node-number/track?sort=asc&order=Referer
(etc and so on)

all completely empty. These tabs on individual nodes work on all my other Drupal sites (which were 5.1 from the start). What could be breaking this? Another module perhaps?

I'm seeing the same problem

dougm commented 26 October 2007 at 21:08

I upgraded two web sites. One has this problem and the other doesn't. In both cases, the settings were enabled. Hints on clearing the problem on the site where they disappeared would be most welcome.

Yeah... Something just isn't

Dabitch commented 27 October 2007 at 07:21

Yeah... Something just isn't getting saved somehow.

As while page admin/logs/referrers has stuff now, it's only one single referer and it has been the exact same one for days. Meanwhile both awstats and webalizer and google analyzer show quite a lot more traffic.

So, somehow, records aren't sticking. I have no idea as to why. My other sites work fine, and have the same modules (as I test them there first).

Anyone? Bueller? Is this a bug?

Still nothing. Turned on and off.

Dabitch commented 2 November 2007 at 11:40

I've tried rebuilding my tables, by turning off this module and using the uninstall feature. It removes the variables regarding statistics and drops tables "accesslog". I've rebuilt my tables. Flushed my tables. Emptied my tables. Dropped the tables and rebuilt them again.

CREATE TABLE `accesslog` (
`aid` int(11) NOT NULL auto_increment,
`sid` varchar(64) NOT NULL default '',
`title` varchar(255) default NULL,
`path` varchar(255) default NULL,
`url` varchar(255) default NULL,
`hostname` varchar(128) default NULL,
`uid` int(10) unsigned default '0',
`timer` int(10) unsigned NOT NULL default '0',
`timestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`aid`),
KEY `accesslog_timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

and the mystery table "access" which is always empty.
CREATE TABLE `access` (
`aid` int(11) NOT NULL auto_increment,
`mask` varchar(255) NOT NULL default '',
`TYPE` varchar(255) NOT NULL default '',
`STATUS` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

I've re-checked my variables;

statistics_count_content_views s:1:"1";
statistics_day_timestamp i:1193999591;:1:"1";
statistics_enable_access_log s:1:"1";
statistics_flush_accesslog_timer s:7:"9676800";

I've cleared my table called cache.

I've enabled, disabled, and enabled the module again.

access and access_log are still clean as whistles.

Kinda puts a damper on other fun modules, such as Xstatistics - http://drupal.org/project/xstatistics - which relies on "statistics" working properly in the first place.

Any suggestions to other voodoo I can do? Anyone experience this bug and fix it? Short of creating an entire new site (this is my only drupal site to have this issue and it has had it from day 1), what can I do?

Found a possible solution

dougm commented 12 November 2007 at 03:35

I just got all my logs back :-) I found that I had errors the mysql error log in the log tables.
I used the repair option of mysqlcheck and my logs reappeared.

bizarrly so did I - they

Dabitch commented 12 November 2007 at 18:51

bizarrly so did I - they suddenly appeared today, but I haven't done anthing to remedy this issue since my last post here. *shrug* Either it's voodoo or the search engine spiders and other things I am tinkering with have suddenly had an impact on this. Oh, and I had the mysql server restarted the other day, if that did anything? Hmmm.....

I'm kicking myself for

Dabitch commented 15 November 2007 at 22:08

I'm kicking myself for jinxing my logs by saying they worked the 12th. They did, the 12th of November - but haven't recorded any new hits/referers since. Voodoo, I'm telling ya!
Clearly something else that I'm using is interfering, the question is what.