You are viewing the PKP Support Forum | PKP Home Wiki

Dates before 1902?

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

Dates before 1902?

Postby mvluijt » Tue Nov 29, 2011 3:45 am

Hi Guys,

I'm running into all kinds of trouble with back issues dating back to before 1902. OJS won't import those. A small hack did help, I got them imported but things like DOAJ export do not work properly. I am aware of the 32-bit UNIX date limit, which seems to affect me here, but I was hoping the OJS's use of ADODB would remove that limit.

So, the basic question is, does OJS support dates before 1902?

We're running a 32 bit PHP here, which may be the problem, and I may get an upgrade to 64 but I'll need some positive reinforcement...
OJS version of this install is 2.2.3


Best, Martin
Posts: 9
Joined: Fri Oct 19, 2007 5:29 am

Re: Dates before 1902?

Postby JasonNugent » Tue Nov 29, 2011 4:06 pm

Yes, the 32 bit limit is a problem. Unix uses a signed 32-bit integer to store the unix timestamp, which limits you to:

MAX: 2147483647 = 2038-01-19 03:14:07 +0000
MIN:-2147483648 = 1901-12-13 20:45:52 +0000

An upgrade to a 64-bit OS will probably remove this limitation.


Site Admin
Posts: 910
Joined: Tue Jan 10, 2006 6:20 am

Re: Dates before 1902?

Postby MMeijer » Thu Aug 23, 2012 8:44 am

It turns out that OJS itself - nor ADODB - do have a problem with 32-bit Unix in relation to dates before 1902.
In fact, if a ADODB dateconversion function signals a problem, it just returns the date from the database as-is.
But: Smarty's date conversion (e.g. in /templates/editor/issues/backIssues.tpl) is NOT that smart, nor is the DOAJ plugin (see DOAJExportDom::formatDate()).
So, by some small adjustments in the templates and DOAJ plugin, and may be some other spots, one can live with 32bits ...

Posts: 36
Joined: Fri Nov 10, 2006 3:25 am
Location: Utrecht

Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 1 guest