Can't seem to figure this one out when delete a member

Started by Biology Forums, September 11, 2017, 06:46:24 PM

Previous topic - Next topic

Biology Forums

Hi there

Everytime I try to delete a single member, I get this error:

Database Error: MySQL server has gone away
File: /home/***/public_html/Sources/PersonalMessage.php
Line: 2121

This code leads to:

// If sender and recipients all have deleted their message, it can be removed.
$request = db_query("
SELECT pm.ID_PM, pmr.ID_PM AS recipient
FROM {$db_prefix}personal_messages AS pm
LEFT JOIN {$db_prefix}pm_recipients AS pmr ON (pmr.ID_PM = pm.ID_PM AND deleted = 0)
WHERE pm.deletedBySender = 1
" . str_replace('ID_PM', 'pm.ID_PM', $where) . "
HAVING recipient IS null", __FILE__, __LINE__);
$remove_pms = array();
while ($row = mysql_fetch_assoc($request))
$remove_pms[] = $row['ID_PM'];
mysql_free_result($request);

if (!empty($remove_pms))
{
db_query("
DELETE FROM {$db_prefix}personal_messages
WHERE ID_PM IN (" . implode(', ', $remove_pms) . ")
LIMIT " . count($remove_pms), __FILE__, __LINE__);

db_query("
DELETE FROM {$db_prefix}pm_recipients
WHERE ID_PM IN (" . implode(', ', $remove_pms) . ')', __FILE__, __LINE__);
}


Could someone tell me what I can do to fix this? This error does not arise when I delete two or more members though.

Advertisement: