PDA

View Full Version : Limits Set on Tables to Delete?


Digital Jedi
10-09-2013, 03:33 AM
When using this query, I've run into the issue of when the number of rows in the table get somewhere around 200, nothing happens. Nothing is deleted, nor can be. As long as the number of rows (in this case, definitions) is around 30-50, I don't seem to have a problem deleting anything. But with the larger table, I can't even delete one item successfully. Is there some kind of limit in my server settings that would cause this?

$delete = "";

if (!empty($oldorder))
{
$update = array();

foreach($oldorder as $key => $value)
{

if ($deleted["$key"])
{
$delete .= ($delete ? "," : "") . $key;
}
else
{

if ($value != $order["$key"])
{
$update["$key"]['displayorder'] = $order["$key"];
}
if ($oldstatus["$key"] != $status["$key"])
{
$update["$key"]['status'] = $status["$key"];
}
if ($oldcontainer["$key"] != $container["$key"])
{
$update["$key"]['container'] = $container["$key"];
}
if ($oldextract["$key"] != $extract["$key"])
{
$update["$key"]['extraction'] = $extract["$key"];
}

}
}
}

if ($delete)
{
$db->query_write("DELETE FROM " . TABLE_PREFIX . "automediaembed WHERE id in ($delete)");
}

if (sizeof($update))
{

foreach($update as $id => $columns)
{
$columninfo = "";

foreach ($columns as $column => $value)
{
$columninfo .= ($columninfo ? ", " : " SET ") . " $column = '$value'";
}

$db->query_write("UPDATE " . TABLE_PREFIX . "automediaembed $columninfo WHERE id=$id");
}

}

Digital Jedi
10-10-2013, 03:47 PM
Looking around, I see that people are having problems with deleting a large number of rows using PHP, but that's when the records are in the thousands/millions. You would think when you're only deleting one row out of a few hundred, it wouldn't be a problem.

nerbert
10-10-2013, 04:14 PM
Somewhere (and I couldn't begin to guess where now) I saw a hard coded limit to a query like that. I guess it's a security feature that prevents a hacker from doing too much too quickly.

Digital Jedi
10-12-2013, 02:32 AM
That seems odd, considering the number of deleted rows is sometimes 1, and still doesn't work. Then gain, it does look like that's what is happening. At least on my server. I haven't got any feedback that anyone else is experiencing this problem.