Page MenuHomePhabricator

Revision 1 on a wiki always shows the current time as its timestamp when rev_timestamp is blank
Open, LowestPublic

Description

/w/index.php?title=Home&diff=2&oldid=1

Marking as a MediaWiki core issue, as it doesn't make sense for a revision to have a "dynamic" timestamp like that. Presumably the database field got nulled or something, but this is the wrong way to handle it.

Event Timeline

TTO created this task.Jan 11 2015, 12:59 PM
TTO raised the priority of this task from to Needs Triage.
TTO updated the task description. (Show Details)
TTO added a project: MediaWiki-Page-Diffs.
TTO added a subscriber: TTO.
TTO triaged this task as Lowest priority.EditedJan 11 2015, 1:02 PM

Yeah, timestamp is blank:

MariaDB [foundationwiki_p]> select * from revision where rev_id = 1\G
*************************** 1. row ***************************
            rev_id: 1
          rev_page: 3
       rev_text_id: 0
       rev_comment:
          rev_user: 0
     rev_user_text:
     rev_timestamp:
    rev_minor_edit: 0
       rev_deleted: 0
           rev_len: 37
     rev_parent_id: 0
          rev_sha1: 52bg87vryq4ill63osp3cv3edb9mezj
 rev_content_model: NULL
rev_content_format: NULL
1 row in set (0.00 sec)

Also has no user name, which is interesting.

Don't know whether this is really worth fixing, unless a lot of wikis have empty revision timestamps...

Varnent closed this task as Declined.Jul 31 2018, 6:21 PM
Varnent added a subscriber: Varnent.

No longer applies to new site.

TTO reopened this task as Open.Jul 31 2018, 9:18 PM

This is marked as a MediaWiki software issue. I said in the description:

Marking as a MediaWiki core issue, as it doesn't make sense for a revision to have a "dynamic" timestamp like that. Presumably the database field got nulled or something, but this is the wrong way to handle it.

Varnent renamed this task from Revision 1 at wikimediafoundation.org always shows the current time as its timestamp to Revision 1 at on a wiki always shows the current time as its timestamp.Jul 31 2018, 9:19 PM
Varnent updated the task description. (Show Details)

Updated to reflect this is not specific to WikimediaFoundation.org

Aklapper renamed this task from Revision 1 at on a wiki always shows the current time as its timestamp to Revision 1 on a wiki always shows the current time as its timestamp when rev_timestamp is blank.Aug 11 2019, 10:30 PM
Aklapper updated the task description. (Show Details)