Expire email not working

Problem

The expiration notification email is not generated correctly. The customer's name and email address is blank, as well as the order info.

Solution

This problem problem was confirmed for MDS version 2.0.x. Please edit the functions.php file to fix it. Here is how:

1. Open include/functions.php

2. find the following code:

 $sql = "SELECT *, t1.banner_id as BID, t1.user_id as UID FROM orders as t1, users as t2 where t1.user_id=t2.ID AND t1.user_id='".$user_id."' AND order_id='$order_id' ";

3. Replace the above code with this code:

 $sql = "SELECT *, t1.banner_id as BID, t1.user_id as UID FROM orders as t1, users as t2 where t1.user_id=t2.ID AND order_id='$order_id' ";

4. Save the file.

Versions above 2.0.10 have this problem fixed.

Posted in Technical Support.

Leave a Reply