ID: 24718
User updated by: psychosos at gmx dot at
Reported By: psychosos at gmx dot at
-Status: No Feedback
+Status: Open
Bug Type: ODBC related
Operating System: Windows 2000 Professional
PHP Version: 4.3.2
New Comment:
Sorry about the delay.
The database I am experiencing the problem with is an Microsoft Access
Database I created with MS Access XP.
The problematic table has the following schema:
Table Kommentare
ID long integer DEFAULT 0 NOT NULL
Kommentar Memo NOT NULL
Kommentator Text (50)
Datum Date/Time (standard date)
IP Text(15)
(sorry about non-SQL conformity; I tried to transcribe the MS Access
information)
"SELECT * FROM Kommentare" crashes PHP.
"SELECT ID, Kommentator, Datum, IP FROM Kommentare" works fine.
"SELECT Kommentar FROM Kommentare" crashes PHP.
"SELECT TOP 200 Kommentar FROM Kommentare" works fine as well.
But "SELECT Kommentar FROM Kommentare" crashes PHP.
If needed/helpful I might try to determine the exact number of records
(bytes) which crashes PHP.
Unfortunately I am not experienced debugging applications.
If I can be of any further help I'd be glad to follow your instructions
:-)
Cheers,
johannes
Previous Comments:
------------------------------------------------------------------------
[2003-07-24 15:08:39] [EMAIL PROTECTED]
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
------------------------------------------------------------------------
[2003-07-19 17:30:10] [EMAIL PROTECTED]
A sample schema would help tremendiously. Also what database?
------------------------------------------------------------------------
[2003-07-19 13:35:58] psychosos at gmx dot at
Description:
------------
If I use odbc_result_all() with a result which has around 75 rows or
more it crashes with an Application Error (The instruction at
"0x1000ede5" referenced memory at "0x000000ae". The memory could not be
"read".
Unfortunately this only happens to me with one table and only if I
retrieve longer fields (for example it only crashes when trying to
retrieve a longer character field, not with my ID or a short string
field)
(I am sorry about this unexact bug report. If you can give me any hints
how to be more helpful - please do so!)
Reproduce code:
---------------
<?php
$connection = odbc_connect("Albumsliste","","");
$result = odbc_exec($connection, "SELECT * FROM Kommentare;");
$count = odbc_result_all($result);
echo "\nResult count: $count\n";
odbc_free_result($result);
odbc_close($connection);
?>
Expected result:
----------------
The code should output all the fields from the table named
"Kommentare".
Actual result:
--------------
PHP crashes with an Application Error (The instruction at "0x1000ede5"
referenced memory at "0x000000ae". The memory could not be "read".)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24718&edit=1
