2009/9/3 Jani Taskinen <jani.taski...@iki.fi>:
> Errors output from MINIT can not and will not ever have any other timezone
> than what is the system's timezone.
>
> If you're reporting a bug, please do it at http://bugs.php.net/.
>
> Anyways the code in sqlsrv is pretty horrible. I'd cleanup that mess first.
> Unless of course you can reproduce same under something else than windows
> and with any other extensions.
>
> --Jani
>
> On 09/03/2009 02:10 PM, Richard Quadling wrote:
>>
>> Hi.
>>
>> I've been playing with the MS SQL Server driver
>> (https://sqlsrvphp.svn.codeplex.com/svn).
>>
>> Using this code (editing it to work with the default WinResrc.h rather
>> than the winres.h it is currently asking for) ...
>>
>> AND ...
>>
>> turning on the logging via the ini file (as I was playing I just
>> wanted to see what was logged) ...
>>
>> sqlsrv.LogSeverity                            = -1
>> sqlsrv.LogSubsystems                          = -1
>> sqlsrv.WarningsReturnAsErrors                 = On
>>
>> The log file shows entries like ...
>>
>> [03-Sep-2009 11:55:11] PHP Warning:  PHP Startup: Unable to load
>> dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating system
>> cannot run %1.
>>  in Unknown on line 0
>> [03-Sep-2009 11:55:11] PHP_MINIT_FUNCTION for php_sqlsrv: entering
>> [03-Sep-2009 10:55:11] sqlsrv: entering rinit
>> [03-Sep-2009 10:55:11] sqlsrv.WarningsReturnAsErrors = On
>> [03-Sep-2009 10:55:11] sqlsrv.LogSeverity = 255
>> [03-Sep-2009 10:55:11] sqlsrv.LogSubsystems = 255
>> [03-Sep-2009 10:55:11] sqlsrv: entering rshutdown
>>
>> In changing /* $Id: main.c 286478 2009-07-29 00:17:10Z stas $ */ ...
>>
>>                        error_time_str = php_format_date("d-M-Y H:i:s", 11,
>> error_time,
>> php_during_module_startup() TSRMLS_CC);
>>
>> to
>>
>>                        error_time_str = php_format_date("d-M-Y H:i:s e",
>> 13, error_time,
>> php_during_module_startup() TSRMLS_CC);
>>
>> the log file now looks like ...
>>
>> [03-Sep-2009 11:55:11 Europe/London] PHP Warning:  PHP Startup: Unable
>> to load dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating
>> system cannot run %1.
>>  in Unknown on line 0[03-Sep-2009 11:55:11 Europe/London]
>> PHP_MINIT_FUNCTION for php_sqlsrv: entering
>> [03-Sep-2009 10:55:11 UTC] sqlsrv: entering rinit
>> [03-Sep-2009 10:55:11 UTC] sqlsrv.WarningsReturnAsErrors = On
>> [03-Sep-2009 10:55:11 UTC] sqlsrv.LogSeverity = 255
>> [03-Sep-2009 10:55:11 UTC] sqlsrv.LogSubsystems = 255
>> [03-Sep-2009 10:55:11 UTC] sqlsrv: entering rshutdown
>>
>> I'm not too sure what's going on. I think it has something to do with
>> php_during_module_startup(), but I can't work out when the response to
>> this function will ever change as it returns a static int value.
>>
>> The above logs were created using date.timezone=Europe/London and calling
>> ...
>>
>> php -m
>>
>>
>>
>> This gets a little odder when I use ...
>>
>> php -d date.timezone=Europe/Berlin -m
>>
>> The output is now ...
>>
>> [03-Sep-2009 12:05:40 Europe/London] PHP Warning:  PHP Startup: Unable
>> to load dynamic library 'C:/PHP5/ext\php_curl.dll' - The operating
>> system cannot run %1.
>>  in Unknown on line 0
>> [03-Sep-2009 13:05:41 Europe/Berlin] PHP_MINIT_FUNCTION for php_sqlsrv:
>> entering
>> [03-Sep-2009 11:05:41 UTC] sqlsrv: entering rinit
>> [03-Sep-2009 11:05:41 UTC] sqlsrv.WarningsReturnAsErrors = On
>> [03-Sep-2009 11:05:41 UTC] sqlsrv.LogSeverity = 255
>> [03-Sep-2009 11:05:41 UTC] sqlsrv.LogSubsystems = 255
>> [03-Sep-2009 11:05:41 UTC] sqlsrv: entering rshutdown
>>
>>
>> Don't worry about the specifics of the curl error - this isn't my issue.
>>
>>
>> I would suggest that the datetime extension needs to be loaded before
>> the curl library request as I assume this will get the timezone I've
>> supplied (Europe/Berlin).
>>
>> I'm just not sure about the sqlsrv timezone though at all. Why isn't
>> this Europe/something rather than UTC?
>>
>>
>> Regards,
>>
>> Richard.
>>
>>
>>
>
>

What I was looking for was some feedback. As you say, MINIT is system
timezone only. That's fine.

-- 
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling

--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to