Modify

Opened 6 years ago

Closed 6 years ago

Last modified 6 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

Description

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 = datetime.now(utc)

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 w.author 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 6 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
Action
as closed The owner will remain dagomez.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.