PM mesage wont remove on site

[jdsifw]

I got a PM message from a member and now i cant delete it. Always says i have one new message.

Jon

[csocsoka]

Hy.Open the message you have received,and you have an option there that says delete press that link, and it will delete it.Please tell me if it that worked.

[jdsifw]

I have inbox /outbox/delete but nothing happens to the message its still there.

Just got told its a script error not sure how to remove it.

[Aligroup]

I have inbox /outbox/delete but nothing happens to the message its still there.

Just got told its a script error not sure how to remove it.

loks like some code error in profile.php

[ayman20068]

post the code in this file : members/readMsg.php here

[jdsifw]

post the code in this file : members/readMsg.php here

$includes[title]="Read Message";

$id = mysql_real_escape_string(intval($_REQUEST['id']));
$sql=$Db1->query("SELECT * FROM messages WHERE ( (username='{$username}' and to_status='1') or (`from`='{$username}' and from_status='1'))  and id='{$id}'");
if($Db1->num_rows() > 0) {
   $temp = $Db1->fetch_array($sql);
   
   if($temp['from'] == $username) $own=false;
   elseif($temp['username'] == $username) $own=true;
   
   if($own == true) $Db1->query("UPDATE messages SET `read`='1' WHERE id='$id'");

   $includes[content]="
   
   <div style=\"float: right;\">
      <a href=\"index.php?view=account&ac=messages&".$url_variables."\">Inbox</a> |
         ".($own == true?"<a href=\"index.php?view=account&ac=composeMsg&reply=$id&".$url_variables."\">Reply</a> | ":
         "<a href=\"index.php?view=account&ac=sentmessages&".$url_variables."\">Outbox</a> | ")."
      <a href=\"index.php?view=account&ac=deleteMsg&id=$id&".$url_variables."\" onclick=\"return confirm('Are you sure?')\">Delete</a>
   </div>
   
   <strong>From: </strong> $temp[from]<br />
   <strong>Date: </strong> ".date('m/d/y', mktime(0,0,$temp[dsub],1,1,1970))."
   
   
   <table class=\"tableStyle3\">
      <tr>
         <td class=\"tableHead\"><img src=\"images/icons/mail.gif\">".stripslashes($temp[title])."</td>
      </tr>
      <tr>
         <td>".nl2br(stripslashes($temp[message]))."</td>
      </tr>
   </table>
   
   
   ";
   
}
else {
   $includes[content]="
   <b>Error!</b><br />
   There was an error loading the requested message!
   ";
}


?>

Hope thats what ya wanted!!

[ayman20068]

the file seems fine , the error would be in the deleteMsg.php file , find this file in members directory and change the code inside it to this code :

Code:

<?

$id = mysql_real_escape_string(intval($_REQUEST['id']));
$sql=$Db1->query("SELECT * FROM messages WHERE ( (username='{$username}' and to_status='1') or (`from`='{$username}' and from_status='1'))  and id='{$id}'");
if($Db1->num_rows() > 0) {
$temp = $Db1->fetch_array($sql);

if($temp['from'] == $username) $own=false;
elseif($temp['username'] == $username) $own=true;

if(($temp['from_status']==0 && $own == true) || ($temp['to_status']==0 && $own == false))
$Db1->query("DELETE FROM messages WHERE id='{$id}'");
else
$Db1->query("UPDATE messages SET ".($own?"to":"from")."_status=0 WHERE id='{$id}'");

}

$Db1->sql_close();
header("Location: index.php?view=account&ac=messages&".$url_variables."");
exit;

?>

[jdsifw]

 Found it, But i pasted that code in there. ( by the way it was there already word for word) And still the message wont delete.. it has a Star next to the message does that mean anything? none of my other messages have that gold star.

Jon

[jdsifw]

Well now i have 2 messages that will not Delete . Other people are having same problems. Seems it the ones that are reply's.

That code didnt work at all either.


Jon

[roamer]

I had this problem but when I moved to a new host, problem solved. Seems the old host had not updated some software at the servers.

[needmorecoffee]

Thanks everyone. Had the same issue, and thought it was just my site that had a hicup.

[jdsifw]

Thanks everyone. Had the same issue, and thought it was just my site that had a hicup.

No its alot of use having this problem. I think its in the new SDR3 script. have talked to alot of people on this and still no fix!!