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.
--
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php