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

No longer applies to new site.

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)