Opened 7 years ago

Closed 7 years ago

timestamp out of range for platform time_t error with Trac 0.12 (suggested patch is now attached)

Reported by: Owned by: eric.portelance@… Joachim Hoessler normal EstimationToolsPlugin normal scottj@… 0.12

Description

After installing Trac 0.12 we are getting a "timestamp out of range for platform time_t" error.

comment:1 Changed 7 years ago by Odd Simon Simonsen

Traceback, please. Use Trac debug logging to get the full error from the server. Anything else needed to reproduce this (like macro or macro options)?

Changed 7 years ago by Björn Harrtell

use new date format conversion method as req 0.12+

comment:2 Changed 7 years ago by bjorn

I think he is hitting a bug that I think I have fixed in attached patch. The problem is that 0.12 uses new timestamp format:

Not sure if I've messed up UTM zone consideration though.

comment:3 Changed 7 years ago by anonymous

Summary: timestamp out of range for platform time_t error with Trac 0.12 → timestamp out of range for platform time_t error with Trac 0.12 (suggested patch is now attached)

Changed 7 years ago by Odd Simon Simonsen

Updated patch that should support both 0.11 and 0.12.

comment:4 Changed 7 years ago by Odd Simon Simonsen

Thanks for the patch. I've updated it, and made it work across Trac versions to avoid branching just for this. Please try attachment:t7355-to_utimestamp_compat-r5360.diff

Untested on 0.12 by me, so please report back after testing.

comment:5 Changed 7 years ago by Joachim Hoessler

Status: new → assigned

If someone could verify that it works on 0.12, I will apply osimons patch on trunk.

comment:6 Changed 7 years ago by Björn Harrtell

Verified as working on 0.12, nice work making it compatible.

comment:7 Changed 7 years ago by Joachim Hoessler

Resolution: → fixed assigned → closed

(In [8296]) applied patch by bjorn@… and osimons to support trac 0.12. Fixes #7355.

comment:8 Changed 7 years ago by scottj@…

I'm still getting this error with BurndownChart, after pulling from trunk and building r9029. Do I need to do anything special to reconfigure the plugin after installation?

comment:10 follow-up:  11 Changed 6 years ago by anonymous

fast fix:

echo "update wiki set time= substr(time, 0, length(time)-6);" | sqlite3 /var/trac/db/trac.db

comment:11 in reply to:  10 Changed 6 years ago by Odd Simon Simonsen

fast fix:

echo "update wiki set time= substr(time, 0, length(time)-6);" | sqlite3 /var/trac/db/trac.db

This is not a fast fix for anything. It is a super-fast way of making your Trac 0.12+ wiki think it is ~42 years back in time... Don't run it!

Speaking of, how can changing timestamps in wiki table ever affect the ticket timestamps that the EstimationToolsPlugin uses to render ticket graphs and stats???

Modify Ticket

Change Properties