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

Action
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.