#21772 [Opn]: mssql speed when using remote server
ID: 21772
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating System: windows 2000/sp3
PHP Version: 4.2.3
New Comment:
Thank you Joey!
Good work!
Previous Comments:
[2003-01-21 03:49:56] [EMAIL PROTECTED]
We've been using PHP hosted on a win32 machine to connect
to SQL Server 2000. When the PHP host and the MSSQL host
are the same machine, everything is fine. But when we try
to use seperate hosts for PHP and MSSQL, query times become
unbearably slow.
The odd thing is that I can run the same scripts on the
same network connecting to the same MSSQL server from a Linux box, and
see acceptable response times.
As an example, I did a script that does 1000 iterations
of 'sp_sproc_columns @procudure_name = "some_proc"' in three
different setups.
Setup 1:
MSSQL and PHP on the Win2k host, call it machine 'A'
Average Response time over 5 iterations of script: 18s
Setup 2:
MSSQL on host 'A', PHP on Linux host ('B')
Average Response time over 5 iterations of script: 41s
(Given the size of the result set, this is an acceptable
response time.)
Setup 3:
MSSQL on host 'A', PHP on seperate Win2k host ('C')
Average Response time over 5 iterations: 3 minutes, 20s
Clearly, there is something wrong here. I had a different admin set up
a similar network without looking at my php.ini, etc., and he had
similar results.
[2003-01-21 03:47:22] [EMAIL PROTECTED]
Actually, we have done extensive testing on this bug.
If I write a C++ program to run the same query results, it operates as
expected.
If I run the query in 'Query Analyzer', a Microsoft tool, it operates
as expected.
If I run the query via PHP from a LINUX box (compiled with MSSQL
support via the FreeTDS drivers), it operates as expected.
If I run the query via PHP from a Windows box, LO AND BEHOLD, 500-600%
longer to run the query!
This is most definitely something wrong between PHP and the MSSQL
libraries on Win32 machines. I'll add my post from php-db that has
better details in a moment.
[2003-01-20 13:52:49] [EMAIL PROTECTED]
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions.
Thank you for your interest in PHP.
When dealing with i-net connections even if they are local there is a
lot more additional work that needs to be done. I wouldn't think this
would amount to 3.5 times speed difference, but with Win32 you never
know.
PHP does not initiate the connection to the SQL server itself, it does
it by using the appropriate libraries. So, I do not believe that PHP
could be at fault here.
[2003-01-20 08:01:06] [EMAIL PROTECTED]
I forgot one detail:
I test both MSSQL 7 and MSSQL 2K with latest services packs,
supplied from MS.
[2003-01-20 07:51:09] [EMAIL PROTECTED]
Hello!
I made small script for determine difference between remote and local
MSSQL server use.
I don't put this script (it is very simple: 1000 loops of db_connect,
1000 loops of mssql_select_db, 1000 loops of mssql_query with load 1000
records rowset, 1000 loops of call stored procedure)
Results of my research:
1. Local DB Server - Local Apache Web server - working about 1000
secounds
2. Remote DB Server - Local Apache Web server - working about 3500
secounds
Remote server connected over TCP/IP network via one 100Mb switch (3com
office connect) -network utilization is low when I made test.
Ping to DB server less than 10ms and no packets lost detected when I
ping 100 times with block size 65500
Same tests, using MSSQL Query Analyser got same results for remote and
local server. So, as far as I understand, there is PHP problem, occurs
with remote DB server using.
I want hear any opinion, exept use snap version of php (I tested also
in SNAP version two days ago)
Your,
vladimir,
Novosibirsk,
Russia.
--
Edit this bug report at http://bugs.php.net/?id=21772&edit=1
#21772 [Opn]: mssql speed when using remote server
ID: 21772 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4.2.3 New Comment: I forgot one detail: I test both MSSQL 7 and MSSQL 2K with latest services packs, supplied from MS. Previous Comments: [2003-01-20 07:51:09] [EMAIL PROTECTED] Hello! I made small script for determine difference between remote and local MSSQL server use. I don't put this script (it is very simple: 1000 loops of db_connect, 1000 loops of mssql_select_db, 1000 loops of mssql_query with load 1000 records rowset, 1000 loops of call stored procedure) Results of my research: 1. Local DB Server - Local Apache Web server - working about 1000 secounds 2. Remote DB Server - Local Apache Web server - working about 3500 secounds Remote server connected over TCP/IP network via one 100Mb switch (3com office connect) -network utilization is low when I made test. Ping to DB server less than 10ms and no packets lost detected when I ping 100 times with block size 65500 Same tests, using MSSQL Query Analyser got same results for remote and local server. So, as far as I understand, there is PHP problem, occurs with remote DB server using. I want hear any opinion, exept use snap version of php (I tested also in SNAP version two days ago) Your, vladimir, Novosibirsk, Russia. -- Edit this bug report at http://bugs.php.net/?id=21772&edit=1
#21772 [NEW]: mssql speed when using remote server
From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4.2.3 PHP Bug Type: MSSQL related Bug description: mssql speed when using remote server Hello! I made small script for determine difference between remote and local MSSQL server use. I don't put this script (it is very simple: 1000 loops of db_connect, 1000 loops of mssql_select_db, 1000 loops of mssql_query with load 1000 records rowset, 1000 loops of call stored procedure) Results of my research: 1. Local DB Server - Local Apache Web server - working about 1000 secounds 2. Remote DB Server - Local Apache Web server - working about 3500 secounds Remote server connected over TCP/IP network via one 100Mb switch (3com office connect) -network utilization is low when I made test. Ping to DB server less than 10ms and no packets lost detected when I ping 100 times with block size 65500 Same tests, using MSSQL Query Analyser got same results for remote and local server. So, as far as I understand, there is PHP problem, occurs with remote DB server using. I want hear any opinion, exept use snap version of php (I tested also in SNAP version two days ago) Your, vladimir, Novosibirsk, Russia. -- Edit bug report at http://bugs.php.net/?id=21772&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21772&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21772&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21772&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21772&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21772&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=21772&r=support Expected behavior: http://bugs.php.net/fix.php?id=21772&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=21772&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=21772&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21772&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21772&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21772&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21772&r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=21772&r=gnused
#21481 [Com]: mssql_close function don't close connection
ID: 21481 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4CVS-2003-01-07 (stable) New Comment: Please, tell me, where in function mssql_close is dbclose call for really close connection to database? vladimir. Previous Comments: [2003-01-08 03:20:04] [EMAIL PROTECTED] Sorry, this is my mistype. in my test script all was fine. and, also, I reopen this bug report. When 25 connections was reached, no new connection will open. Then I change option "allow persistant" to Off in php.ini. All working fine. I assume this is not a bogus, this is a bug. [2003-01-07 05:48:56] [EMAIL PROTECTED] A little comment to let [EMAIL PROTECTED] knows that his script is bogus: should be Thank you for your report. [2003-01-07 05:43:01] [EMAIL PROTECTED] In the db extensions connections will be closed via destructor functions, which will be called when zend_list_delete is executed: see: PHP_MINIT_FUNCTION and _close_[extname]_link [2003-01-07 04:07:18] [EMAIL PROTECTED] And also: If I create file like this: and run it a lot of times, after 25 times I got message "unable connect to server" from mssql_connect when I go to mssql entreprise manager I will see 25 connections from PHP. If I restart apache all connections will be closed. PS: I use apache 1.3.27/w32 Same behavior with all databases, as I understand, there is another childs logic instead unix. Waiting for comments [2003-01-07 02:06:41] [EMAIL PROTECTED] Hello! I call mssql_close function for close connection but, as I see in php_mssql.c file this function do nothing (ie don't really closes connection) see code: ZEND_FETCH_RESOURCE2(mssql_ptr, mssql_link *, mssql_link_index, id, "MS SQL-Link", le_link, le_plink); if (mssql_link_index) zend_list_delete(Z_LVAL_PP(mssql_link_index)); else zend_list_delete(id); RETURN_TRUE; where is dbclose and dbfreelogin staments? vladimir Novosibirsk, Russia -- Edit this bug report at http://bugs.php.net/?id=21481&edit=1
#21481 [Bgs->Opn]: mssql_close function don't close connection
ID: 21481 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Bogus +Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4CVS-2003-01-07 (stable) New Comment: Sorry, this is my mistype. in my test script all was fine. and, also, I reopen this bug report. When 25 connections was reached, no new connection will open. Then I change option "allow persistant" to Off in php.ini. All working fine. I assume this is not a bogus, this is a bug. Previous Comments: [2003-01-07 05:48:56] [EMAIL PROTECTED] A little comment to let [EMAIL PROTECTED] knows that his script is bogus: should be Thank you for your report. [2003-01-07 05:43:01] [EMAIL PROTECTED] In the db extensions connections will be closed via destructor functions, which will be called when zend_list_delete is executed: see: PHP_MINIT_FUNCTION and _close_[extname]_link [2003-01-07 04:07:18] [EMAIL PROTECTED] And also: If I create file like this: and run it a lot of times, after 25 times I got message "unable connect to server" from mssql_connect when I go to mssql entreprise manager I will see 25 connections from PHP. If I restart apache all connections will be closed. PS: I use apache 1.3.27/w32 Same behavior with all databases, as I understand, there is another childs logic instead unix. Waiting for comments [2003-01-07 02:06:41] [EMAIL PROTECTED] Hello! I call mssql_close function for close connection but, as I see in php_mssql.c file this function do nothing (ie don't really closes connection) see code: ZEND_FETCH_RESOURCE2(mssql_ptr, mssql_link *, mssql_link_index, id, "MS SQL-Link", le_link, le_plink); if (mssql_link_index) zend_list_delete(Z_LVAL_PP(mssql_link_index)); else zend_list_delete(id); RETURN_TRUE; where is dbclose and dbfreelogin staments? vladimir Novosibirsk, Russia -- Edit this bug report at http://bugs.php.net/?id=21481&edit=1
#21481 [Com]: mssql_close function don't close connection
ID: 21481 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4CVS-2003-01-07 (stable) New Comment: And also: If I create file like this: and run it a lot of times, after 25 times I got message "unable connect to server" from mssql_connect when I go to mssql entreprise manager I will see 25 connections from PHP. If I restart apache all connections will be closed. PS: I use apache 1.3.27/w32 Same behavior with all databases, as I understand, there is another childs logic instead unix. Waiting for comments Previous Comments: [2003-01-07 02:06:41] [EMAIL PROTECTED] Hello! I call mssql_close function for close connection but, as I see in php_mssql.c file this function do nothing (ie don't really closes connection) see code: ZEND_FETCH_RESOURCE2(mssql_ptr, mssql_link *, mssql_link_index, id, "MS SQL-Link", le_link, le_plink); if (mssql_link_index) zend_list_delete(Z_LVAL_PP(mssql_link_index)); else zend_list_delete(id); RETURN_TRUE; where is dbclose and dbfreelogin staments? vladimir Novosibirsk, Russia -- Edit this bug report at http://bugs.php.net/?id=21481&edit=1
#21481 [NEW]: mssql_close function don't close connection
From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4CVS-2003-01-07 (stable) PHP Bug Type: MSSQL related Bug description: mssql_close function don't close connection Hello! I call mssql_close function for close connection but, as I see in php_mssql.c file this function do nothing (ie don't really closes connection) see code: ZEND_FETCH_RESOURCE2(mssql_ptr, mssql_link *, mssql_link_index, id, "MS SQL-Link", le_link, le_plink); if (mssql_link_index) zend_list_delete(Z_LVAL_PP(mssql_link_index)); else zend_list_delete(id); RETURN_TRUE; where is dbclose and dbfreelogin staments? vladimir Novosibirsk, Russia -- Edit bug report at http://bugs.php.net/?id=21481&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21481&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21481&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21481&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21481&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21481&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=21481&r=support Expected behavior: http://bugs.php.net/fix.php?id=21481&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=21481&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=21481&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21481&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21481&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21481&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21481&r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=21481&r=gnused
#19653 [Com]: sql 2000
ID: 19653 Comment by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: MSSQL related Operating System: windowx xp professional PHP Version: 4.2.3 New Comment: I got some error. in php*.zip included dll for MSSQL7.0. Don't copy it to C:\winnt\system23; use dll from your MSSQL server. Previous Comments: [2002-09-29 12:54:07] [EMAIL PROTECTED] I' have php 4.2.3 installed in microsoft Windows Xp professional, with SQL 2000 from the same company, when i programmed the php dll to access a Ms SQL 2000 (mssql.dll) the php page send me the follow message: Warning: MS SQL: Unable to connect to server: Batman in c:\inetpub\wwwroot\php\sql.php on line 7 Base de datos fallo a conectarse. the server it's already in use, the login and pasword it's in the system and the database exist... the system it's properly installed. thanks. [2002-09-28 23:03:42] [EMAIL PROTECTED] Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. [2002-09-28 16:56:10] [EMAIL PROTECTED] microsoft sql 2000 will not work in php 4.2.3, the driver mssql.dll can't open the database -- Edit this bug report at http://bugs.php.net/?id=19653&edit=1
#21328 [Opn]: return values from stored procedures
ID: 21328 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4.3.0 New Comment: Of course, I use win32 version. Previous Comments: [2003-01-02 00:41:02] [EMAIL PROTECTED] Anyway, with CVS version of PHP I got 10 instead 12345 [2003-01-02 00:32:00] [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 [2003-01-02 00:23:20] [EMAIL PROTECTED] Hello! Happy new year! I have next MSSQL procedure: create procedure test1 as begin return 12345 end and have next test script: in PHP-4.2.3 I got 12345 as output in $a in PHP-4.3.0 I got 10 as output in $a Congratulations, MSSSQL working with Stored procedures is fully broken. or documentation missmath with 4.3.0? Regards, vladimir, Novosibirsk, Russia. -- Edit this bug report at http://bugs.php.net/?id=21328&edit=1
#21328 [Fbk->Opn]: return values from stored procedures
ID: 21328 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: windows 2000/sp3 PHP Version: 4.3.0 New Comment: Anyway, with CVS version of PHP I got 10 instead 12345 Previous Comments: [2003-01-02 00:32:00] [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 [2003-01-02 00:23:20] [EMAIL PROTECTED] Hello! Happy new year! I have next MSSQL procedure: create procedure test1 as begin return 12345 end and have next test script: in PHP-4.2.3 I got 12345 as output in $a in PHP-4.3.0 I got 10 as output in $a Congratulations, MSSSQL working with Stored procedures is fully broken. or documentation missmath with 4.3.0? Regards, vladimir, Novosibirsk, Russia. -- Edit this bug report at http://bugs.php.net/?id=21328&edit=1
#21328 [NEW]: return values from stored procedures
From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4.3.0 PHP Bug Type: MSSQL related Bug description: return values from stored procedures Hello! Happy new year! I have next MSSQL procedure: create procedure test1 as begin return 12345 end and have next test script: in PHP-4.2.3 I got 12345 as output in $a in PHP-4.3.0 I got 10 as output in $a Congratulations, MSSSQL working with Stored procedures is fully broken. or documentation missmath with 4.3.0? Regards, vladimir, Novosibirsk, Russia. -- Edit bug report at http://bugs.php.net/?id=21328&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21328&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21328&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21328&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21328&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21328&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=21328&r=support Expected behavior: http://bugs.php.net/fix.php?id=21328&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=21328&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=21328&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21328&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21328&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21328&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21328&r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=21328&r=gnused
#21189 [NEW]: TTF output function frose Apache
From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4.3.0RC4 PHP Bug Type: GD related Bug description: TTF output function frose Apache Hello! I made crash tests using WebRoller software. I set to 10 requests my PHP code from 50 virtual clients simultaneously, and run 40 iterations. I test php with php_gd.dll and php_gd2.dll. in second case apache generates error on windows console (GPF) I use next code: after crash test my system was frosen,apache haves 99% CPU and a lot of memory. As next, I comment string with ImageTTFText function and test it again. Apache lives! Below I will provide output from WebRollers test results: Results from WebRoller with TTF function: --- Start statistics --- --- Basic statistics --- Min:50.00 20.00 30.00 50.00 70.00 60.00 30.00 30.00 Avg:514.82 602.53 785.38 827.82 378.96 238.82 200.40 199.07 Max:3270.00 4990.00 6350.00 7550.00 3410.00 2680.00 510.00 560.00 --- Network traffic details --- Total bytes sent :124242 Total bytes received :347208 Average input speed : 1152 bytes/sec --- Summary times --- Virtual Clients statistics: Count TimeAR/SAT/R 100 1322442 0.0813224.42 110 1290436 0.0911731.24 101 1320349 0.0813072.76 101 1320809 0.0813077.32 114 1260793 0.0911059.59 110 1262395 0.0911476.32 99 1234395 0.0812468.64 101 1293280 0.0812804.75 101 1320759 0.0813076.82 111 1263257 0.0911380.69 Total work time:1337293 Total requests made:1048 Total average time per request: 1198.4126 Total average requests per second: 0.8344 --- Errors report --- Total 425 errors!!! Net :6 T/O :419 --- HTTP response codes details --- CodeCount 200 629 --- End statistics --- Results from WebRoller without TTF function: --- Start statistics --- --- Basic statistics --- Min:60.00 110.00 90.00 100.00 100.00 100.00 50.00 40.00 Avg:188.26 189.40 189.84 189.44 190.40 188.78 187.64 187.96 Max:240.00 280.00 310.00 330.00 290.00 260.00 270.00 280.00 --- Network traffic details --- Total bytes sent :475530 Average output speed : 47553 bytes/sec Total bytes received : 1844000 Average input speed : 2382 bytes/sec --- Summary times --- Virtual Clients statistics: Count TimeAR/SAT/R 400 78002 5.13195.01 400 78052 5.12195.13 400 77862 5.14194.66 400 78162 5.12195.41 400 78262 5.11195.66 400 78202 5.11195.51 400 78122 5.12195.31 400 78202 5.11195.51 400 78232 5.11195.58 400 77942 5.13194.85 Total work time:78342 Total requests made:4000 Total average time per request: 19.5948 Total average requests per second: 51.0341 --- HTTP response codes details --- CodeCount 200 4000 --- End statistics --- -- Edit bug report at http://bugs.php.net/?id=21189&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=21189&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=21189&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=21189&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=21189&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=21189&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=21189&r=support Expected behavior: http://bugs.php.net/fix.php?id=21189&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=21189&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=21189&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=21189&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21189&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=21189&r=dst IIS Stability: http://bugs.php.net/fix.php?id=21189&r=isapi
#21179 [NEW]: default paramthers for call function
From: [EMAIL PROTECTED]
Operating system: Any
PHP version: 4.2.3
PHP Bug Type: *General Issues
Bug description: default paramthers for call function
Hello!
What do you think about 'formal' (default) params for functions?
for sample:
function q($id,$a=10,$b='aaa',$c=false) {
}
what I can call this function and pass $id, and $b and leave
$a and $c as default.
in case $q(18,,15); PHP says about syntax error.
vladimir,
Novosibirsk,
Siberia
Russia
--
Edit bug report at http://bugs.php.net/?id=21179&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=21179&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=21179&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=21179&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=21179&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=21179&r=oldversion
Not developer issue:http://bugs.php.net/fix.php?id=21179&r=support
Expected behavior: http://bugs.php.net/fix.php?id=21179&r=notwrong
Not enough info:http://bugs.php.net/fix.php?id=21179&r=notenoughinfo
Submitted twice:http://bugs.php.net/fix.php?id=21179&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=21179&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21179&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=21179&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=21179&r=isapi
#21178 [NEW]: Empty string converted to null using bind function
From: [EMAIL PROTECTED]
Operating system: windows 2000/sp3
PHP version: 4.2.3
PHP Bug Type: MSSQL related
Bug description: Empty string converted to null using bind function
Hello!
I use next way for call sp:
$sp=mssql_init("sp");
mssql_bind($sp,"stringdata",'',SQL_VARCHAR);
mssql_execute...
when param 'stringdata' passed to stored procedure, we
got null instead empty string.
I don't specify is_null paramether for mssql_bind function.
by default this paramether is false.
vladimir
Novosibirsk
--
Edit bug report at http://bugs.php.net/?id=21178&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=21178&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=21178&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=21178&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=21178&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=21178&r=oldversion
Not developer issue:http://bugs.php.net/fix.php?id=21178&r=support
Expected behavior: http://bugs.php.net/fix.php?id=21178&r=notwrong
Not enough info:http://bugs.php.net/fix.php?id=21178&r=notenoughinfo
Submitted twice:http://bugs.php.net/fix.php?id=21178&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=21178&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21178&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=21178&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=21178&r=isapi
#20538 [Bgs->Opn]: Cc: in mail won't work in some cases
ID: 20538
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Bogus
+Status: Open
Bug Type: *Mail Related
Operating System: windows 2000/sp3
PHP Version: 4.2.3
New Comment:
Why not a bug? why bogus?
Please look at sendmail.c in win32 directory:
if (headers && (pos1 = strstr(headers, "Cc:"))) {
if (NULL == (pos2 = strstr(pos1, "\r\n"))) {
tempMailTo = estrndup(pos1, strlen(pos1));
} else {
tempMailTo = estrndup(pos1, pos2-pos1);
}
token = strtok(tempMailTo, ",");
while(token != NULL)
{
sprintf(Buffer, "RCPT TO:<%s>\r\n", token);
if ((res = Post(Buffer)) != SUCCESS)
return (res);
if ((res = Ack()) != SUCCESS)
return (res);
token = strtok(NULL, ",");
}
efree(tempMailTo);
}
in this code, we can see, what in Buffer posts line like:
RCPT TO: for first Cc: address and right string
for (RCPT TO: <[EMAIL PROTECTED]>)
it is really strange?
Right code:
if (headers && (pos1 = strstr(headers, "Cc:"))) {
pos1+=3;
if (NULL == (pos2 = strstr(pos1, "\r\n")))
..
after this procedure add:
pos1-=3;
Previous Comments:
[2002-11-21 03:56:29] [EMAIL PROTECTED]
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions.
Thank you for your interest in PHP.
[2002-11-21 03:52:59] [EMAIL PROTECTED]
Hello!
I wrote small php script:
When my SMTP server points to unix machine (sendmail/linux) all working
fine.
When I set SMTP server pointed to IIS5 SMTP server (localhost) I got
'Server Error message'.
any idea?
vladimir
--
Edit this bug report at http://bugs.php.net/?id=20538&edit=1
#20538 [NEW]: Cc: in mail won't work in some cases
From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4.2.3 PHP Bug Type: *Mail Related Bug description: Cc: in mail won't work in some cases Hello! I wrote small php script: When my SMTP server points to unix machine (sendmail/linux) all working fine. When I set SMTP server pointed to IIS5 SMTP server (localhost) I got 'Server Error message'. any idea? vladimir -- Edit bug report at http://bugs.php.net/?id=20538&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=20538&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=20538&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=20538&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=20538&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=20538&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=20538&r=support Expected behavior: http://bugs.php.net/fix.php?id=20538&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=20538&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=20538&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=20538&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=20538&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=20538&r=dst IIS Stability: http://bugs.php.net/fix.php?id=20538&r=isapi
#19977 [NEW]: Formatting when output result HTML after xslt_process
From: [EMAIL PROTECTED] Operating system: windows 2000/sp3 PHP version: 4.2.3 PHP Bug Type: XSLT related Bug description: Formatting when output result HTML after xslt_process Hello! I have two working configurations: 1. Linux with php-4.0.6/sablot-0.70 2. W2k with php-4.2.3/sablot-0.96 in first configuration after xslt_process I got html content in one string and in second html content was formatted. in second case i got design bugs such as: bla-bla-bla instead of bla-bla-bla I cannot use development version of php (there is real working servers with strong load) how i can get some result from php4.2.3 as from 4.0.6? may be some options string or what? -- Edit bug report at http://bugs.php.net/?id=19977&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19977&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19977&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19977&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19977&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19977&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=19977&r=support Expected behavior: http://bugs.php.net/fix.php?id=19977&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=19977&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=19977&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19977&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=19977&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=19977&r=dst IIS Stability: http://bugs.php.net/fix.php?id=19977&r=isapi
