Edit report at http://bugs.php.net/bug.php?id=48908&edit=1
ID: 48908
Comment by: tom dot lawton at kondor dot co dot uk
Reported by: aaron at aarondm dot com
Summary: Cannot query smalldatetime type columns
Status: Open
Type: Bug
Package: MSSQL related
Operating System: ArchLinux
PHP Version: 5.2.10
New Comment:
PHP 5.2.4 / ubuntu 8.10LTS has this bug and is reproducable.
Suhosin patch reports canary mismatch if a query returns smalldatetime.
Apache does not trigger 500, nor does PHP report any error to the page -
it dies silently.
Previous Comments:
------------------------------------------------------------------------
[2010-01-07 12:36:21] undicizeri at gmail dot com
Same bug here.
I'm using Ubuntu with php 5.2.6 and debian with php 5.2.12.
------------------------------------------------------------------------
[2009-12-21 11:22:41] php at mike2k dot com
Sample query/workaround:
old: SELECT acct_itm.cre_dtm AS cre_dtm
new: SELECT CONVERT(varchar(10),acct_itm.cre_dtm,120) AS cre_dtm
Not the most ideal. Might be a bug in the FreeTDS driver and not
something PHP can handle but has to pass upstream.
------------------------------------------------------------------------
[2009-12-21 10:13:22] php at mike2k dot com
Always repeatable.
This is an issue for us as well. The previous comment is from a Windows
user so they're probably able to leverage more native Windows MSSQL
libraries...
PHP 5.2.11, on Linux, using FreeTDS on CentOS 5.3 (or 5.4, not sure)
x86_64
The workaround is having to cast the column inside of the query. I will
try to post an example workaround query when I grab one from the dev
team.
Related Packages/versions of the driver, just in case:
freetds-devel-0.64-11.el5.centos
freetds-devel-0.64-6.el5
freetds-0.64-11.el5.centos
freetds-0.64-6.el5
unixODBC-2.2.11-7.1 (32 bit)
unixODBC-2.2.11-7.1 (64 bit)
unixODBC-devel-2.2.11-7.1 (32 bit)
unixODBC-devel-2.2.11-7.1 (64 bit)
------------------------------------------------------------------------
[2009-07-16 16:14:14] aaron at aarondm dot com
I have run the same query on Windows Server 2003 (Enterprise Edition)
and this does not seem to be an issue. On windows it is able to fetch
the column data with no problems.
------------------------------------------------------------------------
[2009-07-13 19:54:44] aaron at aarondm dot com
Description:
------------
When trying to query a table, with a column whos type is
'smalldatetime', the code will result in a 500 Internal Error
Reproduce code:
---------------
Create table with the following columns
----------------------------------------
MY_TABLE
----------------------------------------
|(int) ID | (smalldatetime) MY_EXAMPLE |
----------------------------------------
Run:
$result = mssql_query("SELECT MY_EXAMPLE FROM MY_TABLE");
When you run that, you will get a:
500 Internal Server Error
On ArchLinux/Windows
Expected result:
----------------
No 500 Internal Server Error.
Should be able to query the database with no problems
Actual result:
--------------
500 Internal Server Error
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=48908&edit=1
