By Emilio Davis on

Yes I know, Windows pftt... But anyway, i'm kinda forced to use it since the hosting where the site is has only windows.

The problem:
Drupal use the gmdate function from php (http://www.php.net/manual/en/function.gmdate.php), and that function, under windows, does not work for negative timestaps, (any date before 1970 has a negative timestamp).

Any of you knows a fix for this? Btw, i'm not root of the server, neither know much about windows administration (i'm pretty much a linux junky), so if there is anything to change on the server i'll have to ask it to my hosting company and i would like it to be as clearest as posible.

Thx in advance and sorry for my raw english (I'm chilean so my main language is spanish).

Comments

ax’s picture

ax commented

http://google.com/search?q=ADOdb+Date+Library

marky’s picture

marky commented

This has been covered already. Welcome to the wonderful world of Windows... ;)
/marky

Emilio Davis’s picture

Emilio Davis commented

thanks, i guess i'm screwed tho, since i can't install the aoddb patch on the hosting server

bertboerland’s picture

bertboerland commented

switch to a "real" hosting provider, I have been at pair for year and they are really good and cheap. (pair.com)

--

groets


bertb

--
groets
bert boerland

marky’s picture

marky commented

You don't even need to touch the server config, so no need to bother your host. I did this a long time ago for an installation of Drupal v4.1.0 on a Windows server (hence the original bug report). From the notes at the top of the current adodb-time.inc.php:

This library replaces native functions as follows:
	getdate()  with  adodb_getdate()
	date()     with  adodb_date() 
	gmdate()   with  adodb_gmdate()
	mktime()   with  adodb_mktime()
	gmmktime() with  adodb_gmmktime()

so all you have to do is grep your installation for the above functions, and replace them with the adodb_ equivalent. Then include or require_once the adodb-time.inc.php file at the top of common.inc.

Some clues for v4.4.1:

  • function format_date() common.inc, L847 - L893
  • function _profile_user_view() profile.module L173 - L210 (this gets the birthday working before 1970)

There may be more instances depending on which modules you're using...

/marky

moshe weitzman’s picture

moshe weitzman commented

a nice way to fix your system so that others beenefit is to make a time.inc file for drupal. In that file, define a function for each of the functions listed in marky's post. here is an example

function drupal_date()
  if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') { 
    return adodb_date(...);
  }
  else {
    return date(...);
}

then grep and change all instances of these functions to drupal_x version. then just make sure you include time.inc and adodb library somewhere ... then submit a patch to core.