ID: 47877 Comment by: nick at ihighteam dot com Reported By: leif at neland dot dk Status: No Feedback Bug Type: MSSQL related Operating System: Debian 5 PHP Version: 5.2.9 New Comment:
I found a solution here and it works for me! http://www.nabble.com/-Bug-41297--NEW:-PHP-Suhosin-Patch-creates-a-problem-with-mssql_query%28%29-when-selecting-a-smalldatetime-field-td17693263.html Steps to Reproduce: 1. Use the default configuration of PHP with the mssql-extension. 2. create a sql-statement that selects a smalldatetimevalue from a MSSQL-Database or use the Script at the end of this report. 3. the Script dies in the mssql_query()-function Solution: I found the following solution that works for me: 1. Open /etc/php.ini 2. "Decomment" the line "mssql.datetimeconvert = On" and change it to "mssql.datetimeconvert = Off" 3. Restart Apache 4. The Problem dissappears Previous Comments: ------------------------------------------------------------------------ [2009-07-10 03:11:23] synec dot net at gmail dot com I checked extension.ini and remove some lines. #extension=oci8.so #extension=recode.so #extension=pdo_oci.so and then works fine. ------------------------------------------------------------------------ [2009-07-10 02:30:53] synec dot net at gmail dot com run 'php -v' on CLI. ALERT - canary mismatch on efree() - heap overflow detected (attacker 'REMOTE_ADDR not set', file 'unknown') Install php v5.2.10 by FreeBSD ports. Using options are 'CLI, CGI, APACHE, SUHOSIN, MULTIBYTE, IPV6, MAILHEAD, REDIRECT, DISCARD, FASTCGI, PATHINFO' ------------------------------------------------------------------------ [2009-04-11 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2009-04-03 03:00:29] [email protected] Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. Aswell as a backtrace would help give some insight on the matter for the maintainer ------------------------------------------------------------------------ [2009-04-02 12:22:02] leif at neland dot dk Description: ------------ Basically the same bug as 43861, it seems. Some mssql-queries triggers ALERT - canary mismatch on efree() - heap overflow detected I'm willing to patch, submit traces etc :-) Reproduce code: --------------- Code probably irrellevant. Expected result: ---------------- No errors in the log ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=47877&edit=1
