ID: 48908 Comment by: php at mike2k dot com Reported By: aaron at aarondm dot com Status: Open Bug Type: MSSQL related Operating System: ArchLinux PHP Version: 5.2.10 New Comment:
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) Previous Comments: ------------------------------------------------------------------------ [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/?id=48908&edit=1