From: iam_simon at hotmail dot com
Operating system: Windows 2000 with Apache 1.3.33
PHP version: 5.0.3
PHP Bug Type: MSSQL related
Bug description: Bug on Insert and Update with PHP 5.0.3
Description:
------------
I have been using ADODB (a pouplar PHP database wrapper) for several years
and recently I upgraded to PHP 5.0.3 on Apache 1.3.33 with MSSQL. I got
tons error messages from log generated by adodb-errorhandler.inc.php
whenever my app uses "INSERT" or "UPDATE" to the database. There is no
problem with "SELECT" statement.
This is a problem with PHP 5.0.3 only, 5.0.2, 4.0.x or below doesn't have
this problem.
I contacted author of ADODB, Mr. John Lim said it is a MSSQL/PHP bug, so I
am trying to report this bug here.
Although there is an error, but the row has successfully inserted into the
database. I am using latest version of Adodb.
Simon
Reproduce code:
---------------
$conn = &ADONewConnection('mssql');
$conn->Connect("hostname", "user", "pass", "dbname");
$conn->Execute("INSERT INTO visitor_log(date_stamp, ip, host, agent)
Values('2004-12-29 07:10:52PM', '192.168.0.2', '', 'Mozilla/4.0
(compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)')");
$conn->Close();
Expected result:
----------------
mssql error: [0: ] in EXECUTE("INSERT INTO visitor_log(date_stamp, ip,
host, agent) Values('2004-12-29 06:59:18PM', '192.168.0.2', '',
'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)')")
Actual result:
--------------
no error should be seen
--
Edit bug report at http://bugs.php.net/?id=31343&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31343&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31343&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31343&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31343&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31343&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31343&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31343&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31343&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31343&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31343&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31343&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31343&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31343&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31343&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31343&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31343&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31343&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31343&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31343&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31343&r=mysqlcfg
