FAQ
Edit report at https://pear.php.net/bugs/bug.php?id=19237&edit=1

ID: 19237
Updated by: pear@isc-ltd.co.uk
Reported By: pear at isc-ltd dot co dot uk
Summary: MDB2 fails to see data in mysql table
Status: Open
Type: Bug
Package: MDB2
Operating System: Windows 7
Package Version: 2.4.1
PHP Version: 5.3.9
Roadmap Versions:
New Comment:

Apologies: a newbie error confusing patches with attachments.

Example code and output is at http://www.isc-ltd.co.uk/pear_19237.


Previous Comments:
------------------------------------------------------------------------

[2012-01-22 07:40:17] johnk_uk

Added #patch bug:19237;patch:example-code;revision:1327218017;.

------------------------------------------------------------------------

[2012-01-22 07:34:14] johnk_uk

Description:
------------
Test script uses MDB2 to create database, create table and insert data
into table. Table is then queried and no results returned. Native
connection is then established and retrieves data as expected. MDB2
succesfully deletes database.

Identical behaviour on OS X 10.7.2/PHP 5.3.6.

Test script:
---------------
Attached

Expected result:
----------------
$mdb2->queryAll("SHOW TABLES"); should return "beatles"

$mdb2->queryAll("SELECT * FROM beatles"); should return (1, "John"), (2,
"Paul", (3, "George"), (4, "Ringo")

Actual result:
--------------
Both queries return zero rows and do not report an error. Actual output
is attached.

------------------------------------------------------------------------

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
grouppear-bugs @
categoriesphp
postedJan 22, '12 at 6:59a
activeJan 22, '12 at 6:59a
posts1
users1
websitepear.php.net

1 user in discussion

Pear: 1 post

People

Translate

site design / logo © 2021 Grokbase