| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #780 | DB/common.php -> DB mismatch (DB 1.6.0RC6) | ||
|---|---|---|---|
| Submitted: | 2004-02-17 19:23 UTC | ||
| From: | jkaufman at wamnetgov dot com | Assigned: | danielc |
| Status: | Bogus | Package: | DB |
| PHP Version: | 4.3.4 | OS: | Linux - Mandrake 9.1 |
| Roadmaps: | (Not assigned) | ||
[2004-02-17 19:23 UTC] jkaufman at wamnetgov dot com
Description:
------------
v1.24 of common.php, no problem.
v1.87 of common.php gives a db mismatch error.
My query is a simple one:
select task_id, task_code, task_descr from task_master, task_wbs_element where task_id in (31)
(works fine in dbaccess)
I am using this command to execute the query:
$res = $dbh->query($sql, DB_FETCHMODE_ASSOC);
The new code contains this in executeEmulateQuery:
if (count($this->prepare_types[$stmt]) != count($data)) {
$this->last_query = $this->prepared_queries[$stmt];
return $this->raiseError(DB_ERROR_MISMATCH);
}
And that is where it fails. I don't understand why a simple query needs to go through prepare/execute, nor what I need to do to fix this.
Reproduce code:
---------------
All is shown above.
Expected result:
----------------
Values from db, not 'db mismatch error'.
Actual result:
--------------
db_error Object
(
[error_message_prefix] =>
[mode] => 16
[level] => 1024
[code] => -7
[message] => DB Error: mismatch
[userinfo] => select task_id, task_code, task_descr, task_wbs_element from task_master where task_id in (31)
[backtrace] => Array
(
[0] => Array
(
[file] => /usr/share/pear/DB.php
[line] => 739
[function] => pear_error
[class] => db_error
[type] => ->
[args] => Array
(
[0] => DB Error: mismatch
[1] => -7
[2] => 16
[3] => handle_Error
[4] => select task_id, task_code, task_descr, task_wbs_element from task_master where task_id in (31)
)
)
[1] => Array
(
[file] => /usr/share/pear/PEAR.php
[line] => 525
[function] => db_error
[class] => db_error
[type] => ->
[args] => Array
(
[0] => -7
[1] => 16
[2] => handle_Error
[3] => select task_id, task_code, task_descr, task_wbs_element from task_master where task_id in (31)
)
)
[2] => Array
(
[file] => /usr/share/pear/DB/common.php
[line] => 495
[function] => raiseerror
[class] => pear
[type] => ::
[args] => Array
(
[0] =>
[1] => -7
[2] =>
[3] =>
[4] => select task_id, task_code, task_descr, task_wbs_element from task_master where task_id in (31)
[5] => DB_Error
[6] => 1
)
)
[3] => Array
(
[file] => /usr/share/pear/DB/common.php
[line] => 980
[function] => raiseerror
[class] => db_ifx
[type] => ->
[args] => Array
(
[0] => -7
)
)
[4] => Array
(
[file] => /usr/share/pear/DB/common.php
[line] => 940
[function] => executeemulatequery
[class] => db_ifx
[type] => ->
[args] => Array
(
[0] => 0
[1] => 2
)
)
[5] => Array
(
[file] => /usr/share/pear/DB/common.php
[line] => 1130
[function] => execute
[class] => db_ifx
[type] => ->
[args] => Array
(
[0] => 0
[1] => 2
)
)
[6] => Array
(
[file] => /var/www/html/tsg_2.20/enter_service_request3.php
[line] => 74
[function] => query
[class] => db_ifx
[type] => ->
[args] => Array
(
[0] => select task_id, task_code, task_descr, task_wbs_element from task_master where task_id in (31)
[1] => 2
)
)
)
[callback] => handle_Error
)
Comments
[2004-02-17 20:55 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!