Wrong Age and Author in Source Browser after upgrade to trac 0.12

[anonymous]

By some reason for some environments there is wrong Age and Author in Source Browser after upgrade to trac 0.12. Sometimes the issue is fixed by re-doing upgrade (trac-admin <env> upgrade. But sometimes it does not work. Bad Age is usually 43 years. Wrong Author is Anonymous.

Looking into database (trac.db) I have found that there is revision value without leading zeros in "bad" rows of revision and node_change tables.

sqlite> select * from revision;
repos|rev|time|author|message
1|0|1167263763000000||
1|1|1167263833000000|greg|
1|0000000002|1167271165308028|alex|Initial Update

Here the rev value '1' results in Age 43 years and Author Anonymous in Source Browser.

The issue can be fixed by changing rev from '1' to '0000000001'

update revision set rev='0000000001' where rev='1';
update node_change set rev='0000000001' where rev='1';

[Remy Blank]

A trac-admin $ENV repository resync should fix this issue. Can you please try?

[Christian Boos]

Most likely due to a mix of Trac versions. Maybe you have a commit hook which was still running Trac 0.11 or earlier?

Anyway, assuming this has been fixed.