From: ceesios at gmail dot com
Operating system: Windows XP/2003
PHP version: 4.4.8
PHP Bug Type: MSSQL related
Bug description: Application error using MSSQL
Description:
------------
I am trying to connect to a MSSQL database. Often the first few times this
failes giving an error on the server;
"The instruction at "0x0068d6ff" referenced
memory at 0xffffffff. The memory could not be "read"."
The memory adresses always change. I've tried different PHP versions,
different Apache versions and different computers but the problem always
comes back. It seems to be connected to the ammount of code/size of the
query. The more code or the larger the query the more errors I get.
Sometimes it works after a couple of refreshes but the problem always
comes back.
Reproduce code:
---------------
<?php
include '..\dbcon.php'; // connect to database
$todays_date = date("Y-m-d");
$todays_date = $todays_date.' ';
$today = strtotime($todays_date);
$query = " SELECT * FROM AddonScheduleCheck ORDER BY starttijd";
$result = mssql_query($query);
$numRows = mssql_num_rows($result);
echo "<table>\n"
. "<TR HEIGHT='20'></TR>\n"
. "<TR class='toprow'><TD>\n"
. "<H2>" . $numRows . " verkeerd" . ($numRows == 1 ? "" : "e") . "
roosteritem" . ($numRows == 1 ? "" : "s") . " gevonden " . "</H2>\n"
. "</TD></TR>\n"
. "<TR HEIGHT='20'></TR></table>\n";
echo
"<table border=4>".
"<TR class='sub'>\n".
"<TD width = 120><B>Cursus<BR>Zoeknaam</B></TD>\n".
"<TD width = 400><B>Cursus Omschrijving</B></TD>\n".
"<TD width = 500><B>Foutmelding</B></TD>\n".
"<TD width = 70></TD>\n".
"</TR>\n";
while($row = mssql_fetch_array($result))
{
$roostererror=NULL;
$startdatum = strtotime($row["Startdatum"]);
$Hoofddocent = $row["HoofdDocentVnaam"].' '.$row["HoofdDocentAnaam"];
$cursusid = $row["CursusID"];
include 'schedule_error_descriptions.php';
// tekst ipv bits laten zien
IF ($row["MoederCursus"] == NULL) {$moedercursus='Ja';}
ELSE $moedercursus='Nee';
IF ($row["DatumAnnulering"] == NULL) {$geannuleerd='Nee';}
ELSE $geannuleerd='Ja';
echo
"<TR class='data'>\n".
"<TD>". $row["Zoeknaam"] . "</TD>\n".
"<TD>". $row["CursusOmschrijving"] . "</TD>\n".
"<TD>". $roostererror . "</TD>\n".
"<TD ALIGN=center>".
"<BR><FORM NAME=\"roostercontrole\"
ACTION=schedule_error_details.php?id=$cursusid METHOD=post>" .
'<input type="submit" value="Details">' .
'</FORM>' .
"</TD>\n".
"</TR>\n";
}
//echo "</table>\n\n";
?>
Expected result:
----------------
a table with the rows from the database and a detail button on the end.
Actual result:
--------------
error on the server;
"The instruction at "0x0068d6ff" referenced
memory at 0xffffffff. The memory could not be "read"."
--
Edit bug report at http://bugs.php.net/?id=44918&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=44918&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=44918&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=44918&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=44918&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=44918&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=44918&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=44918&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=44918&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=44918&r=support
Expected behavior: http://bugs.php.net/fix.php?id=44918&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=44918&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=44918&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=44918&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=44918&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=44918&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=44918&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=44918&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=44918&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=44918&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=44918&r=mysqlcfg
