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