Re: DB Error: mismatch

Did you check if ALL variables for its content? Angelo ----- Original Message ----- From: "Justin Patrin" <papercrane@gmail.com> To: <j.fainer@neu.edu> Cc: <pear-general@lists.php.net> Sent: Friday, April 01, 2005 2:23 PM Subject: Re: [PEAR]DB Error: mismatch

On Apr 1, 2005 6:01 AM, j.fainer@neu.edu <j.fainer@neu.edu> wrote:

On March 28 I issued the attached email. Question: Is there a more appropriate list serve to issue this question? So far I have put it to three different lists without a single reply and I am really falling short on new ideas. -----Original Message----- From: James Fainer Sent: Monday, March 28, 2005 10:29 AM To: pear-general@lists.php.net Subject: [PEAR]DB Error: mismatch Does someone know the answer to this puzzle? The attached code snippet was developed and tested on a SUSE 9.1 install and works without any issues. But on the production server, a Sunfire V100 running Solaris 9.0, apache2, mysql 4.0.24 and PHP 5.0.3; all other code including successful queries of the database work fine, but when the program attempts to update or create new data the system issues a DB Error: mismatch. If I do a direct query to the database, I can edit all day. I also changed the error reporting to use mysql_error() and mysql_errnum() and it returns "0". I have since reinstalled mysql and recompiled PHP without any luck. Because I get a DB:error and no mysql error is there a chance there is a PEAR issue? Any ideas? snippet: _______________________________________ $sql = $db->prepare("UPDATE cutsheet SET cutsheet.StationQuad = '$StationQuad', cutsheet.StationPort = '$StationPort', cutsheet.SSSystemName = '$SSSystemName', cutsheet.SSIPAddress = '$SSIPAddress', cutsheet.SStackSwitch = '$SStackSwitch', cutsheet.SSSwitchPort = '$SSSwitchPort', cutsheet.PortSpeed = '$PortSpeed', cutsheet.PortDuplex = '$PortDuplex', cutsheet.VlanNumber = '$VlanNumber', cutsheet.Network = '$Network', cutsheet.ConnType = '$ConnType', cutsheet.Notes = '$Notes', cutsheet.LastUpdate = '$Cdate', cutsheet.PortDisable = '$PortDisable', cutsheet.DatePortDisable = '$DatePortDisable', cutsheet.TTPortDisable = '$TTPortDisable' WHERE cutsheet.id = '$id'"); if (DB::isError($sql)) { die($sth->getMessage()); } $res =& $db->execute($sql, 1); if (DB::isError($res)) { die($res->getMessage()); }

You should also be using quoteSmart for those values. -- Justin Patrin -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php