Hello,
I just recently upgraded from 4.2.3 to 4.3.0 and a script of
mine has begun behaving erratically. The code is included at the bottom
of this message. I am essentially updating a large (1.94m row) table to
include a new field...the queries needed to do this updating are
somewhat time consuming, so I have been updating all of this for about
fifteen months now. However, since my 4.3.0 upgrade, this script can
get through maybe 110 lines before halting. I get no errors posted with
regards to the script, and no HTTP errors or timeout messages, it's as
if the script thinks it's completed. If anyone could give me a clue-in
as to what's up, I would be much obliged.
Cheers,
Ben
<?php
include("functions.inc.php");
$db = mysql_connect("localhost", "user", "pw");
mysql_select_db("db", $db);
$sql = "SELECT ID,a FROM b.c WHERE d = '' LIMIT 200;";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
echo "Performing op on $numrows rows<br>";
$qstart = sn_Msecs();
while ($row = mysql_fetch_row($result)) {
$owner = getcache($row[1]);
$id = $row[0];
$sqlu = "UPDATE b.c SET d = '$owner' WHERE ID = '$id';";
$resultu = mysql_query($sqlu);
}
$qstop = sn_Msecs();
$qtime = round($qstop-$qstart,2);
echo "the update took $qtime secs";
?>
------
Ben Vaughn
Security Analyst
Blackbird Technologies
703-796-1438 W / 703-868-5258 C
[EMAIL PROTECTED]
------
BEGIN:VCARD VERSION:2.1 N:Vaughn;Ben FN:Ben Vaughn TEL;WORK;VOICE:703.796.1438 TEL;HOME;VOICE:703.205.9719 TEL;CELL;VOICE:703.868.5258 ADR;WORK:;217-C LABEL;WORK:217-C EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20020607T194757Z END:VCARD
smime.p7s
Description: application/pkcs7-signature
