Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#8891 closed defect (duplicate)

no result in wiki activity

Reported by: askfor@… Owned by: dagomez
Priority: normal Component: StractisticsPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12


It sames that the time this plugin use is different from the time trac use.

from stractistics.util import datetime_to_secs
from trac.util.datefmt import from_utimestamp, to_utimestamp, utc

In [8]: t =

In [9]: to_utimestamp(t)
Out[9]: 1307873775108961L

In [10]: datetime_to_secs(t)
Out[10]: 1307873775

as you can see the time stractisticsplugin got is much smaller, so this query can't got any result.

    SELECT AS author, COUNT(distinct w.version) AS modifications 
    FROM wiki w
    WHERE w.time > 1300644467 AND w.time < 1307902067 
    GROUP BY author
    ORDER BY modifications DESC
    LIMIT 7  

Attachments (0)

Change History (1)

comment:1 Changed 12 years ago by Oliver Metz

Resolution: duplicate
Status: newclosed

Duplicate of #6923.

There is also a patch attached which fixes the plugin for me.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain dagomez.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.