| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 2.5.0b5 |
| Bug #20038 | prepare statements fail w/data type array | ||
|---|---|---|---|
| Submitted: | 2013-08-14 23:01 UTC | ||
| From: | helices | Assigned: | |
| Status: | Open | Package: | MDB2 (version 2.4.1) |
| PHP Version: | 5.4.0 | OS: | centos |
| Roadmaps: | (Not assigned) | ||
[2013-08-14 23:01 UTC] helices
(helices helices)
Description:
------------
We have several servers of this configuration, some of which successfully run this code and 3 fail
All else equal, this line succeeds:
$stm = $db->prepare($query,MDB2_PREPARE_MANIP);
This line fails:
$type = array('text');
$stm = $db->prepare($query,$type,MDB2_PREPARE_MANIP);
We need to get the value, like this:
$d[$column] = $str;
$updated = $stm->execute($d);
When it fails, we get this:
MDB2 Error: unknown error
_execute: [Error message: Unable to execute statement]
[Last executed query: UPDATE filetypes
SET comments=?
WHERE filetype_id=1
]
[Native code: 0]
Please, advise. Thank you.