Jump to content

xtreme109

Members
  • Content count

    6
  • Joined

  • Last visited

  1. xtreme109

    Recover Cart Sales

    new problem on the reports/stats page!! Working... 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_stat' at line 1 select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where (o.customers_id = 39 OR o.customers_email_address like "evan@xxx.com" OR o.customers_name like "Evan xxx") and o.orders_status > a:3:{i:0;s:1:"0";i:1;s:1:"1";i:2;s:1:"2";} and s.orders_status_id = o.orders_status and o.date_purchased >= "20100223" and ot.class = "ot_total" Ideas?
  2. xtreme109

    Recover Cart Sales

    OK GOT IT! on or around line 157 of the /admin/recover_cart_Sales.php <?php $custid = $_POST['custid']; //<---ADD THIS // Are we doing an e-mail to some customers if (count($custid) > 0 ) { ?>
  3. xtreme109

    Recover Cart Sales

    check the rendered code...is this correct? <input type="checkbox" name="custid[]" value="39" CHECKED>
  4. xtreme109

    Recover Cart Sales

    It appears as though the code does not recognize that there are selected users to send emails to. PLEASE HELP! ANY HELP OUT THERE!
  5. xtreme109

    Recover Cart Sales

    I just installed the plugin, and it shows the recovered carts. Everything looks great to far! I created a fake account with a "lost" cart. The test user shows up under "tools-->recover cart sales" along with many others and when i click "Send E-mail" email never gets sent and status remain "uncontacted" Please help! The email function works for all other parts of the site. using OSCommerce 2.2 RC2
×