Re: PEAR DB error
| From: | Tomas V.V.Cox | Date: | Thu, 09 May 2002 21:35:50 +0000 |
| Subject: | Re: PEAR DB error | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-6025@lists.php.net to get a copy of this message | ||
Roko Roic wrote:
>
> hi.
>
> I am connected to an Oracle 8.1.6
> PEAR version is the one distributed with PHP 4.06
>
> This piece of code makes me cry:
>
> $query = 'SELECT * FROM ota_categories';
> $all = $this->db->getAll($query,null,DB_FETCHMODE_ASSOC);
> return $all;
>
> getAll returns (var_dump follows):
> ---------------
> object(db_error)(10) { ["error_message_prefix"]=> string(0) ""
> ["error_prepend"]=> string(0) "" ["error_append"]=>
> string(0) ""
> ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=>
> int(-7)
> ["message"]=> string(18) "DB Error: mismatch"
> ["debuginfo"]=> string(0)
> "" ["userinfo"]=> string(28) "SELECT * FROM ota_categories"
> ["callback"]=> NULL }
> ---------------
>
Umm... try $this->db->getAll($query, DB_FETCHMODE_ASSOC); If doesn't
work, try updating your PEAR DB copy.
Tomas V.V.Cox