WordPress.org

Ready to get started?Download WordPress

Forums

Timestamping prior to 1969? (13 posts)

  1. pezastic
    Member
    Posted 8 years ago #

    Is this at all possible?

  2. Possibly. Posts in the database are stored in a MySQL date/time format, but that may rely on a Unix timestamp internally and for that, 0 = mightnight on Jan. 1st, 1970, so...

    Why would you want to fake such old posts anyway though?

  3. Kafkaesqui

    Posted 8 years ago #

    http://trac.wordpress.org/ticket/2149

    You may want to search the forums for "adodb date" on a possible way of hacking this in WordPress.

    http://wordpress.org/search/adodb+date?forums=1

  4. pezastic
    Member
    Posted 8 years ago #

    That first link presented there, the one to the job ticket, had a reference in the description to PHP 5.1. As I read it, if my host has that version of PHP installed, I timestamp posts prior to the 1969 limitation. Is that correct? (I'm in the process of looking for another host provider.)

  5. Kafkaesqui

    Posted 8 years ago #

    The documentation on date() states the ("typically," whatever that means) valid range for it is December 13, 1901 20:45:54 GMT to January 19, 2038 03:14:07 GMT, but that before PHP 5.1 some systems (specifically Windows) were limited to Jaunuary 1, 1970 for the early part of the range. So you'd be better off looking for a host running Unix/Linux or some such, rather than worrying over the PHP ver.

    Although a host providing the latest of both PHP4 and PHP5 can't be bad for you. :)

  6. pezastic
    Member
    Posted 8 years ago #

    I did read that bit about "specifically windows" but am restricted from timestamping anything prior to Dec. 31, 1969 under a Unix operating system with my current webhost provider. I'm not looking to archive anything prior to 1901, so that wouldn't be an issue. As I am on the hunt for a new webhost provider anyhow, I thought finding one with PHP 5.1 installed, regardless of the operating system, might take away the 1969 date restriction. Would I be correct in this assumption?

  7. Kafkaesqui

    Posted 8 years ago #

    It's a good assumption, but then I can't guarantee anything for what any one host might actually do.

    I'll note that the host I'm with runs Redhat Linux and PHP 4.4.3 (though they also offer 5.1), and I can set pre-1970 dates on my posts. Not that I've ever had a reason to do that...

  8. pezastic
    Member
    Posted 8 years ago #

    Interesting. My host runs Apache Web Server Software, Unix Operating System, and PHP 4.3.11 and I'm unable to timestamp anything prior to Dec. 31, 1969.

    It's nice to see I have other options to get the date restriction removed (which I do need), other than going with a webhost provider that has PHP v5.1 installed.

  9. pezastic
    Member
    Posted 8 years ago #

    According to their webhost provider OpenSourceCMS.com is running the following:

    # RedHat
    # Apache 1.3.3x
    # PHP 4.4.x
    # MySQL 4.1.x

    NONE of their demo CMS or blogging apps will allow pre-1970 dates on posts. So, I'm still confused as to which version of PHP will allow this for date(), if any.

  10. pezastic
    Member
    Posted 8 years ago #

    Could WordPress be changed to use mySQL time and date functions?

    http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#IDX1384

  11. Kafkaesqui

    Posted 8 years ago #

    The issue is not MySQL. For WordPress to make use of relatively unrestricted dates, it would take the use of something like PHP's adodb library. You'll find several threads discussing how one might go about modifying WordPress to it (if you're up to that). Here's one such (and hey, look who started it!):

    http://wordpress.org/support/topic/27367

    And to show that a pristine version of WordPress (2.0.2) can be used to post before 1970, here's a little something on my test blog:

    http://szub.net/vea/1965/01/

  12. pezastic
    Member
    Posted 8 years ago #

    I went looking for a webhost with PHP5, for this very reason. I am now on a server that has:

    Apache1.3
    Kernel2.4.21-4.0.1 elsmp
    MySQL4.0.24
    PHP4.3.11
    PHP55.1.2
    PHPMyAdmin2.7.0-pl1
    Python2.2.3-5

    Because I tried to timestamp a post for a pre-1969 date and it didn't work (it changed to Dec. 31 1969), I assume that WordPress is using PHP4.3.11 on this dual-PHP server. Is there any way to force it to use PHP55.1.2?

  13. pezastic
    Member
    Posted 8 years ago #

    I answered my own question! For anyone else running under dual-PHP versions and wanting php files to run under PHP5, while having php4 files running under PHP4, use this in your .htaccess file:

    AddHandler x-httpd-php5 .php
    AddHandler x-httpd-php .php4

    Finally, I am able to timestamp posts for pre-1969 dates. In the end, it was all about the PHP version on my webhost server. Anything PHP4.4 and above will allow pre-1969 posts. Anything below it won't, without the aforementioned modification.

Topic Closed

This topic has been closed to new replies.

About this Topic