Topic on Project:Support desk

Jump to: navigation, search

SMW Result Formats Timeline: Data range < 1900 doesn't appear

Sochin67 (talkcontribs)

I already have posted this query on the SMW Result Formats talk page, but it might be related to the general Mediawiki code - therefore here we go:

I recently have installed the latest revision of Mediawiki (1.18.1) and created my own wiki. I also installed the lates version of SMW ( and Semantic Result Formats (1.7.0) in order to create a timeline with historic data from the village where I live. It all works perfectly well - except the fact that all dates prior to 1900 are not displayed in the timeline. In the documentation of the SMW Extension it says that dates back to the beginning of time are supported. However, somewhere inside the Mediawiki forums I read a hint that Mediawiki might only support dates back to approx. 1900 and not further back. Is this true and is there any workaround? I actually can't believe that there isn't one... Furthermore, I've seen other Mediawiki timeline extensions like EasyTimeline that show up historic data back to stoneages, therefore it's hard to believe that the reason for this behavour is Mediawiki.
URL of my page is:
PHP: 5.2.12-nmm2 (apache2handler)
MySQL: 5.1.43-nmm4-log
Could anybody please give me a hint?
Many thanks!

Bawolff (talkcontribs)

Depending on how SMW is programmed, there may be issues with dates before Fri, 13 Dec 1901 20:45:54 UTC when using 32 bit php. (Some of MW's core date functions have issues [mostly because php has issues], so it depends on if SMW uses them or not).

p.s. These issues are not present if using 64-bit php. The issue is basically the reverse w:Year_2038_problem

Sochin67 (talkcontribs)

Dear Bawolff,
many thanks for your note, at least it's a first indication! That date you're mentioning in your post does correlate to the date where the issue appears in my timeline.
However, I spoke to my web hoster and he confirmed that their environment is running on 64 Bit. When checking the phpinfo I saw that the System is a 64 Bit one (Linux dd6904 2.6.32-38-server #83-Ubuntu SMP Wed Jan 4 11:26:59 UTC 2012 x86_64), but is this what you mean? Or did you mean that the php installation as such needs to be a 64 Bit version? The PHP API listed in phpinfo is "20041225" and PHP Extension is "20060613".
Many thanks for another hint =;-)

Bawolff (talkcontribs)

I believe both the OS and the php version would have to both be 64 bit, but it would be very odd to run 32 bit php on a 64bit host, so if the host is 64bit, there is a very good chance that the php version is 64 bit.

However, I'm at a loss as to how this could happen on a 64bit host...

Reply to "SMW Result Formats Timeline: Data range < 1900 doesn't appear"