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
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.
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
- Posts: 9
- Joined: Fri Oct 19, 2007 5:29 am
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
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