ID: 20426 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.30 New Comment:
I got the same problem on a w2k machine as well i'm using a mysql database. I got as well a smallinteger in my table. If i don't get many hits it survives. But when the hits increase (don't know at which point) PHP crashes i'm still working on it Previous Comments: ------------------------------------------------------------------------ [2003-01-03 00:03:25] [EMAIL PROTECTED] OK... here goes more detail... Just tried PHP 4.30 ISAPI mode. It still crashed, but now it would response messages like this: "PHP has encountered an Access Violation at 77FCB032" And more crashing condition: In both CGI and ISAPI mode, PHP will crash when executing "select *" from any table that contains ONE, TWO OR MORE datetime/smalldatetime format columns THAT THERE IS ANY OTHER COLUMN BEHIND these datetime columns. for example: example_table ( sn int, title varchar(40), modifytime datetime ); Executing "SELECT sn, title, modifytime FROM example_table" will be okay, but executing "SELECT sn, modifytime, title FROM example_table" will crash. ------------------------------------------------------------------------ [2003-01-02 23:11:12] [EMAIL PROTECTED] For more detailed information: 1. On Trad. Chinese version Windows 2000 with Trad. Chinese MSSQL 2000, I will get date format like '2003-01-06 10:23:00' when I execute "select *" in Quary Analyzer. But I will get response like '2003 ¤@¤ë 06 10:23 ¤W¤È' when executing the same query with PHP. 2. I've tried to change date/number format settings in Windowd Location control panel, not working. 3. I've tried to change database default encoding, not working. 4. I've tried to add mssql.datetimeconvert=0 AND mssql.datetimeconvert=Off in php.ini, not working. 5. The ONLY way to alter the date-format converting style of php_mssql is to change the default language script of Windows 2000. For detailed description of the crashing problem: 1. When executing "select *" from any table that contains ONE datetime/smalldatetime format column, PHP will execute and output text to browser. But that php.exe process will not end, neither calling mssql_close() nor not. You can see it in the Task Manager, and it can not be stopper by clicking "End Process". 2. When executing "select *" from any table that contains TWO OR MORE datetime/smalldatetime format column, PHP will crashed upon calling mssql_query. Again, that php.exe process will not quit and can not be forced quit using Task Manager. 3. By switching Windows 2000 default script to Japaness, all this problem disappears. 4. I've tried ALL other data format. None would cause crashing like this. Now I'm 100% sure this IS a date-format converting bug. And now I'm just asking for one thing: to disable this "feature". Please! I beg you! ------------------------------------------------------------------------ [2003-01-02 22:23:39] [EMAIL PROTECTED] OK... I've Just installed latest PHP 4.30, and the crashing problem is getting WORSE! Now PHP will crash whenever I just execute "select *" from any table that contains two or more datetime/smalldatetime columns. Again, this crashing situation disappears when I switch default script of Windows2000 to Japaness. But I can not tell my customers to do this. Could you nice guys just DISABLE the auto date format converting feature ? To us, this is not a feature; it's a CURSE! ------------------------------------------------------------------------ [2002-11-26 20:03:47] [EMAIL PROTECTED] No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. ------------------------------------------------------------------------ [2002-11-15 01:36:34] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip you don't need to open new reports, you can reclassify them..(and this belongs in mssql) ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/20426 -- Edit this bug report at http://bugs.php.net/?id=20426&edit=1
