[Resolved] DB Error: mismatch

[jefainer]

Does someone know the answer to this puzzle?

The attached code snippet was developed and tested on a SUSE 9.1 install and works witout any issues. But on the production server, a sunfire 100 running Solaris 9.0, mysql 4.0.21 and PHP 5.0.2; all other code including succesful reads of the database work fine but the system issues a DB Error: mismatch when ever an attempt to write to the database via the application. If I do a direct query to the database, I can edit all day. 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());
			}

[bastien]

Check the permissions on the folder that holds the database data...it may not have write permissions

[jefainer]

No permissions are fine. If I had the wrong permissions wouldn't I have seen that when I did the direct query? I am not aware of special permissions just for PHP.

[bastien]

Change the error reporting message to

mysql_error() to give you a more meaningful error message

[jefainer]

You will like this. There is no mysql error. It returns error number 0. This is starting to look like something in either PHP or the PEAR extension.

Additional information: I believe I had the system working before with Solaris OS version 8 but the system was dog slow. We decided to upgrade to Solaris 9. The speed increase was 10 fold but this issue developed. I am almost ready to reinstall PHP with the Solaris 9 compiled bin. It just seems weird that all the rest of the application seems to work fine.

[bastien]

There might be some changes in the switch from 8 to 9. A re-install may be exactly what you need

[jefainer]

No that didn't help.

Even upgraded to PHP 5.03. All compiled well and installed well. phpinfo() show appropriate information. Further ideas?

[jefainer]

Still an issue. Anyone?

[jefainer]

Problem Resolved. This issue is a PEAR compatability issue between PHP 4 and 5. All the examples I had previously seen had the variables included in the prepare statement, and a "1" in the execute placeholder. This is no longer acceptable, the data in the prepare statement needs to be replaced with the appropriate tag, in my case "?", and the data must be inserted into an array. The array is then inserted into the placeholder of the execute command. I had to search this down with a server based debugger and then I found one sentence (not in the on line manual) that states it must be an array. And they were right , it must.