Mail error in item shipping notification

dmack · January 26, 2009

Sorry for the poser newbie desperate plea for help, but I am desperate so...

My friend has a web site that has started getting mail errors when he processes or ships an order. The system is supposed to send out an email update to the customer instead he is getting this error message:

Warning: mail(): SMTP server response: 553 5.3.0 <[email protected]>...DISCARD Spam Relay in d:\Customers\user1143876\www\backoffice\backoffice.php on line 58

This is line 58:

mail($To, $Subject, $Message, $headers);

It was fine for years then starting having this error six months or so ago. The Entire page script follows. Any help would be most appreciated as I have no idea how to fix this.

<?

require ("../main.js.php");

$PageTitle = "$domainname BackOffice Menu";

include "../includes/header.php";

include "../includes/admin.menu.php";

//-----------------

// Update Tracking Numbers

$query = "

SELECT T_InvoiceNumber,T_TrackingNumber,T_UPSCost,T_Weight

FROM js_temptracking

";

$sth = $dbh -> do_query($query);

$rows = $dbh -> total_rows($sth);

for ($i=1;$i<=$rows;$i++) {

list ($Invoice,$Tracking,$Cost,$Weight) = $dbh -> fetch_array($sth);

if (($Invoice != '') && ($Invoice > 10000000) && ($Invoice < 99999999)) {

$query = "

UPDATE js_invoices

SET I_TrackingNumber = '$Tracking',

I_UPSCost = '$Cost',

I_Weight = '$Weight'

WHERE I_InvoiceNumber = '$Invoice'

";

$dbh -> do_query($query);

$query = "

DELETE FROM js_temptracking

WHERE T_InvoiceNumber = '$Invoice'

";

$dbh -> do_query($query);

// send confirmation email of sale

$query = "

SELECT I_FirstName,I_Email,I_TrackingNumber,I_OrderNumber

FROM js_invoices

WHERE I_InvoiceNumber = '$Invoice'

";

$sth = $dbh -> do_query($query);

list ($FirstName1,$Email,$TrackingNumber,$Order) = $dbh -> fetch_array($sth);

$To = $Email;

$Subject = "JigStop.com Order Number $Order";

$Message = "Dear $FirstName1,\n\nThis email is to inform you that invoice $Invoice has been shipped and is on the way!\n\nIt is being shipped via UPS and your tracking number is $TrackingNumber.\n\n You may check the current status anytime at http://www.ups.com \n\nThank You for shopping at JigStop.com!.";

$headers = 'From: [email protected]' . "\r\n" .

'Bcc: ' . '[email protected]' . "\r\n" .

'X-Mailer: PHP/' . phpversion();

$Message = wordwrap($Message, 70);

mail($To, $Subject, $Message, $headers);

} else {

$query = "

DELETE FROM js_temptracking

WHERE T_TrackingNumber = '$Tracking'

";

$dbh -> do_query($query);

}

//------------

// Delete old incomplete orders after 30 days

$ExpireDate = $NOW - 2592000;

$ListOrders = array();

$query = "

SELECT O_Number

FROM js_orders

WHERE O_Date < '$ExpireDate'

";

$sth = $dbh -> do_query($query);

$rows = $dbh -> total_rows($sth);

for ($i=1;$i<=$rows;$i++) {

list ($OldOrder) = $dbh -> fetch_array($sth);

array_push($ListOrders, "$OldOrder");

}

for ($i=0;$i<$rows;$i++) {

$query = "

DELETE FROM js_orders

WHERE O_Number = '$ListOrders[$i]'

";

$dbh -> do_query($query);

$query = "

DELETE FROM js_orderitems

WHERE O_OrderNumber = '$ListOrders[$i]'

";

$dbh -> do_query($query);

}

echo "

<td class=\"tableheader\" align=\"left\"><font class=\"tabletextheader\">BackOffice Menu</font></td></tr>

";

if (strstr($Groups, '4') != FALSE) {

echo "

<fieldset><legend><font class=\"tabletextheader\">Online Store</font></legend>

<tr><td><p><font class=\"tabletextheader\">Categories</font> - <a href=\"listcategories.php\">LIST</a>";

if (strstr($Groups, '9') != FALSE) {

echo " | <a href=\"editcategories.php\">ADD</a> | <a href=\"editcategories.php\">EDIT</a>";

}

echo "

</p></td></tr>

<tr><td><p><font class=\"tabletextheader\">Manufacturers</font> - <a href=\"listmanufacturers.php\">LIST</a>";

if (strstr($Groups, '7') != FALSE) {

echo " | <a href=\"addmanufacturer.php\">ADD</a> | <a href=\"editmanufacturers.php\">EDIT</a>";

}

echo "</p></td></tr>

<tr><td><p><font class=\"tabletextheader\">Product Lines</font> - <a href=\"listlines.php\">LIST</a>";

if (strstr($Groups, '7') != FALSE) {

echo " | <a href=\"addline.php\">ADD</a> | <a href=\"chooseline.php\">EDIT</a>";

}

echo "

</p></td></tr>

<tr><td><p><font class=\"tabletextheader\">Products</font> - <a href=\"listproducts.php\">LIST</a>";

if (strstr($Groups, '7') != FALSE) {

echo " | <a href=\"addproduct.php\">ADD</a> | <a href=\"chooseproduct.php\">EDIT</a>";

}

echo "

</p><br /></td></tr>

<tr><td><font class=\"tabletextheader\">Reports</font></td></tr>

<tr><td><a href=\"listitemcatalog.php\">Item Catalog</a></td></tr>

<tr><td><a href=\"mostpopular.php?SortBy=Quantity\">Most Popular Items</a></td></tr>

<tr><td><a href=\"listallitems.php\">List ALL Items</a></td></tr>

<tr><td><a href=\"listallactiveitemsbymanufacturer.php\">List ACTIVE Items by Manufacturer</a></td></tr>

<tr><td><a href=\"listallactiveitems.php\">List All ACTIVE Items</a></td></tr>

<tr><td><a href=\"listinvalidupc.php\">List Items with invalid UPC codes</a></td></tr>

<tr><td><a href=\"salesbydate.php\">Total Sales by Date</a></td></tr>

<tr><td><a href=\"totalsales.php\">Total Sales</a></td></tr>

<tr><td><a href=\"salesbymonth.php\">Total Sales by Month</a></td></tr>

<tr><td><a href=\"salesbyyear.php\">Monthly Sales by Year</a></td></tr>

<tr><td><a href=\"listreferers.php\">HTTP Referers</a></td></tr>

<tr><td><a href=\"/stats/jigstats.php\">Website Statistics</a></td></tr>

<tr><td><a href=\"shippingcosts.php\">Total Shipping Costs</a></td></tr>

<tr><td><a href=\"compareshipping.php\">Shipping Cost Comparison</a></td></tr>

</table></td>

";

if (strstr($Groups, '5') != FALSE) {

echo "

<font class=\"tabletextheader\">Order Processing</font></td></tr>

<tr><td><a href=\"ordermenu.php\">Order Menu</a></td></tr>

<tr><td><a href=\"neworder.php\">New Order</a></td></tr>

<tr><td><a href=\"findorder.php\">Find Order</a></td></tr>

<tr><td><a href=\"copyorder.php\">Copy Order</a></td></tr>

<tr><td><a href=\"listopenorders.php\">List Open Orders</a></td></tr>

<tr><td><a href=\"listpickingorders.php\">List Orders in Picking</a></td></tr>

<tr><td><a href=\"listbackorders.php\">List Backorders</a></td></tr>

<tr><td><a href=\"listallbackordereditems.php\">List Backordered Items</a></td></tr>

<tr><td><a href=\"openorderitems.php\">List Open Order Items</a></td></tr>

<tr><td><a href=\"backordereditemsbymanufacturer.php\">Backordered Items by Manufacturer</a></td></tr>

<tr><td><a href=\"listunfinishedorders.php\">List Unfinished Orders</a></td></tr>

<tr><td><font class=\"tabletextheader\">Manufacturers</font></td></tr>

<tr><td><a href=\"manufacturerinfo.php\">Manufacturer Info</a></td>

<tr><td><a href=\"manufacturernotes.php\">Manufacturer Notes</a>

";

}

echo "</td></tr>

</table></td></tr></table></fieldset>";

if (strstr($Groups, '4') != FALSE) {

echo "

</td></tr><tr><td class=\"tablebody\" height=\"10\"></td></tr><tr><td class=\"tablebody\">

<fieldset><legend><font class=\"tabletextheader\">Messages</font></legend>

<tr><td><a href=\"addmessage.php\">New Message</a></td></tr>

<tr><td><a href=\"mymessages.php\">My Messages</a></td></tr>

<tr><td><a href=\"listmessages.php\">List Open Messages</a></td></tr>

<tr><td><a href=\"listallmessages.php\">List All Messages</a></td></tr>

</table></fieldset>

";

}

if (strstr($Groups, '6') != FALSE) {

echo "

</td></tr><tr><td class=\"tablebody\" height=\"10\"></td></tr><tr><td class=\"tablebody\">

<fieldset><legend><font class=\"tabletextheader\">Travel Department</font></legend>

<tr><td><a href=\"findcustomer.php\">Find Customer</a></td></tr>

<tr><td><a href=\"addcustomer.php\">Add New Customer</a></td></tr>

<tr><td><a href=\"createquote.php\">Create New Quote</a></td></tr>

<tr><td><a href=\"viewquote.php\">View Quote</a></td></tr>

</td></tr></table><td width=\"50%\" valign=\"top\"><table cellspacing=\"5\">

<tr><td><a href=\"listbookings.php\">List Active Bookings</a></td></tr>

<tr><td><a href=\"listcancelledbookings.php\">List Cancelled Bookings</a></td></tr>

<tr><td><a href=\"listcompletedbookings.php\">List Completed Bookings</a></td></tr>

<tr><td><a href=\"addbooking.php\">Add New Booking</a></td></tr>

<tr><td><a href=\"../erikschedule.php\">'The Erik' Schedule</a></td>

<tr><td><a href=\"listandrealynn.php\">Edit 'Andrea Lynn' Info</a></td></tr>

<tr><td><a href=\"../andrealynnschedule.php\">'Andrea Lynn' Schedule</a></td></tr>

";

if (strstr($Groups, '9') != FALSE) {

echo "

<tr><td><a href=\"listhotels.php\">Edit Hotels</a></td></tr>

<tr><td><a href=\"listfleets.php\">Edit Fleets</a></td></tr>

<tr><td><a href=\"editlocation.php\">Edit Locations</a></td></tr>

<tr><td><a href=\"editevents.php\">Edit Events</a></td></tr>

";

}

echo "</table></td></tr></table></fieldset>";

}

if (strstr($Groups, '7') != FALSE) {

echo "

</td></tr><tr><td class=\"tablebody\" height=\"10\"></td></tr><tr><td class=\"tablebody\">

<tr><td><a href=\"addfaq.php\">Add FAQ Question</a></td></tr>

</table></fieldset>

";

}

if (strstr($Groups, 'E') != FALSE) {

echo "

</td></tr><tr><td class=\"tablebody\" height=\"10\"></td></tr><tr><td class=\"tablebody\">

<fieldset><legend><font class=\"tabletextheader\">Send Emails</font></legend>

<tr><td><a href=\"addcustomeremails.php\">Add Customer Emails</a></td></tr>

<tr><td><a href=\"sendemail.php\">Send Email</a></td></tr>

</table></fieldset>

";

}

if (strstr($Groups, 'F') != FALSE) {

echo "

</td></tr><tr><td class=\"tablebody\" height=\"10\"></td></tr><tr><td class=\"tablebody\">

<fieldset><legend><font class=\"tabletextheader\">Fishing Reports</font></legend>

<tr><td><a href=\"listfishreport.php\">List Fishing Reports</a></td></tr>

<tr><td><a href=\"addfishreport.php\">Add Fishing Report</a></td></tr>

</table></fieldset>

";

}

$PHPVersion = phpversion();

$ServerSoftware = $_SERVER['SERVER_SOFTWARE'];

if ((strstr($Groups, '7') != FALSE) || (strstr($Groups, '9') != FALSE)) {

echo "

</td></tr><tr><td class=\"tablebody\" height=\"10\"></td></tr><tr><td class=\"tablebody\">

<fieldset><legend><font class=\"tabletextheader\">System Administration</font></legend>

<table cellspacing=\"5\">";

if (strstr($Groups, '7') != FALSE) {

echo "

<tr><td><a href=\"listoutofstock.php\">List Out of Stock Items</a></td></tr>

<tr><td><a href=\"showcc.php\">Show Credit Card Info</a></td></tr>

";

}

if (strstr($Groups, '9') != FALSE) {

echo "

<tr><td><a href=\"givecredit.php\">Credit Invoice</a></td></tr>

<tr><td><a href=\"fixorder.php\">Fix Order</a></td></tr>

<tr><td><a href=\"albumqueue.php\">Photo Album Queue</a></td></tr>

<tr><td><a href=\"editshipping.php\">Edit Shipping Charges</a></td></tr>

<tr><td><a href=\"listcoupons.php\">Edit Online Coupons</a></td></tr>

<tr><td><a href=\"listusers.php\">Edit Users</a></td></tr>

<tr><td><a href=\"editgroups.php\">Edit Groups</a></td></tr>

<tr><td><a href=\"/phpAdsNew/index.php\">Banner Administration</a></td></tr>

<tr><td><a href=\"listproductsnopictures.php\">List Active Products With No Pictures</a></td></tr>

<tr><td><a href=\"listincompleteorders.php\">Incomplete Orders</a></td></tr>

";

}

echo "

<tr><td>PHP Version = $PHPVersion</td></tr>

<tr><td>Server Software = $ServerSoftware</td></tr>

</table></fieldset>

";

}

} else {

echo "<p><font class=\"tabletext\">You are not an employee!!</font></p><br />";

}

echo "</td></tr></table></td></tr></table>";

include "../includes/footer.php";

?>

PFMaBiSmAd · January 26, 2009

Is [email protected] a mail box at the sending mail server? If it is not, than you need to use a From: address that is hosted at the sending mail server. If it is hosted at the sending mail server, it is likely that the host switched to using SMTP authentication (though the error message is usually a different one.) You should probably ask your host why you are receiving this error and what mail requirement was changed six months ago.

Sign In

Mail error in item shipping notification

Recommended Posts

dmack

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information