ID: 28908
Comment by: webmaster at path dot org
Reported By: skissane at iips dot mq dot edu dot au
Status: Assigned
Bug Type: MSSQL related
Operating System: Linux
PHP Version: 4.3.7
Assigned To: fmk
New Comment:
PHP v 4.3.4:
I am having the same issue:
'./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql'
'--with-mssql=/usr/local'
Freetds v 0.61.2
using protocol 7.0
Connecting to MS SQL Server 2000 (on a separate box, of course)
Ran the same test as above:
$r = mssql_connect("<servername>","<username>","<password>");
mssql_query("SELECT '" . chr(183) . "'",$r);
Get the following error:
Warning: mssql_query(): message: Unclosed quotation mark before the
character string '??'. (severity 15) in
/usr/local/apache2/htdocs/apps/consucap/test.php on line 13
Warning: mssql_query(): message: Line 1: Incorrect syntax near '??'.
(severity 15) in /usr/local/apache2/htdocs/apps/consucap/test.php on
line 13
Warning: mssql_query(): Query failed in
/usr/local/apache2/htdocs/apps/consucap/test.php on line 13
Previous Comments:
------------------------------------------------------------------------
[2004-06-29 21:04:02] [EMAIL PROTECTED]
I have testet your script with PHP4 and PHP5 (latest CVS) with the
latest cvs version of FreeTDS and I'm onable to reproduce the error.
Could you try to use the CVS version of PHP ?
------------------------------------------------------------------------
[2004-06-24 08:50:10] skissane at iips dot mq dot edu dot au
Also, I tested this, it works fine on 4.3.6. So this is a regression in
4.3.7.
------------------------------------------------------------------------
[2004-06-24 08:06:45] skissane at iips dot mq dot edu dot au
Description:
------------
running freetds 0.63
./configure:
'./configure' '--with-apxs2=/usr/sbin/apxs' '--with-mssql=/usr/local'
'--with-mysql' '--with-curl' '--with-dom' '--with-zlib' '--enable-xslt'
'--with-xslt-sablot' '--with-sablot-js' '--enable-dba' '--with-cdb'
'--with-gd' '--with-socket' '--with-ldap'
Reproduce code:
---------------
<?
$r = mssql_connect("<servername>","<username>","<password>");
mssql_query("SELECT '" . chr(183) . "'",$r);
The above query works fine when run directly from Query Analyser.
(where <servername> is a SQL Server 2000; freetds protocol version used
8.0.)
Expected result:
----------------
No error.
Actual result:
--------------
Warning: mssql_query(): message: Unclosed quotation mark before the
character string '� (severity 15) in
/home/skissane/adm/freetds-0.63.dev.20040622/phptest.php on line 3
Warning: mssql_query(): message: Line 1: Incorrect syntax near '�
(severity 15) in
/home/skissane/adm/freetds-0.63.dev.20040622/phptest.php on line 3
Warning: mssql_query(): Query failed in
/home/skissane/adm/freetds-0.63.dev.20040622/phptest.php on line 3
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=28908&edit=1
