Recover Cart [Support Thread]

OK - only works on the last listed customer ! :D

Would it be possible for EACH customer to have the manually contacted option?

Now I understand you.
Fixed.

Perfect - thank you VERY much for that.

is there a way to remove sessions from the links that are generaled ?

mine look like this :

mydomain.com/index.php?main_page=product_info&products_id=400**:27a04ebca4fa9993bfbc8e5458803b46**

so when clicked it breaks to mydomain.com/product_info -Page Not Found

hay guys, i just installed the new version of this modual, however it dont seem to want to email the customers that i select. and it dont show anything in the report for RCS.

Does anyone know what could be the problem?

sorry for the double post, but what is the newest version, the one on a_berezin's site, or the one on the zencart downloads area, after matching the two, they do have some differnences...

what one should i use.. im looking for the version that has a working email function, that will email the customers i select, for some reason its not wanting to do it right now.

kelvyn:

Phew - wish I'd searched for this bug before spending 90 mins on it! Oh well, thanks for the note anyway.

No prob! The latest version works like a charm though.. you can delete whichever cart you want to.. very useful:)

One bug, howver this is probably a ZC bug instead of a RCS bug. When a customer has a cart, but the customer is deleted.. the cart remains in the database.. and RCS pulls the data without a customer, resulting in stuff that can't be deleted through the admin panel. You can go back into the DB and drop it though, and its removed from RCS

Note: the code for deleting customer carts is in Zen Cart code for when a customer is deleted ...

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
                      where customers_id = '" . (int)$customers_id . "'");

samad64:

One bug, howver this is probably a ZC bug instead of a RCS bug. When a customer has a cart, but the customer is deleted.. the cart remains in the database.. and RCS pulls the data without a customer, resulting in stuff that can't be deleted through the admin panel. You can go back into the DB and drop it though, and its removed from RCS
What version of zen-cart you use?
Whow you delete customer? From admin->customers?
In zen-cart 1.3.7 when you delete customer all customers basket deleted.

Hi Andrew,

I see you updated your RCS version on Feb 27, 2007. :thumbsup:

Can you confirm if the fixes employed in previous versions released by both Quentin and Brent Friar (and available in ZC Downloads area) are also implemented in your most recent RCS version available on your website?

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=100

Thanks for the upgrades!

Woody

Hi Andrew-

I forgot to ask in my last post what is best method to indentify your recovercart version installed? My file dates get messed around all the time so not a good method to use to identify anything.

the current recover_cart_sales.php shows:

 * @version $Id: recover_cart_sales.php 2.12 17.09.2006 22:25 Andrew Berezin $

The ID string appears to remain the same since September even though several updates have been released since? Are there version numbers located somewhere else or some other method used to identify your versions? Thanks.

Woody

Hm.. I use 1.3.7.. I was speaking from prior experience to the cart that was patched up to 1.3.7. I'm running on a fresh install now and I haven't had to do anything like that yet.. I'll give it a test to see if its still doing it. I checked the admin/customers.php file on my old site and its exactly the same one thats on my new site.. with this in the header comments:

 * @version $Id: customers.php 4280 2006-08-26 03:32:55Z drbyte $

So am I:

 * @version $Id: customers.php 4280 2006-08-26 03:32:55Z drbyte $

Lines 252-299

      case 'deleteconfirm':
        // demo active test
        if (zen_admin_demo()) {
          $_GET['action']= '';
          $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
          zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
        }

        if (isset($_POST['delete_reviews']) && ($_POST['delete_reviews'] == 'on')) {
          $reviews = $db->Execute("select reviews_id
                                   from " . TABLE_REVIEWS . "
                                   where customers_id = '" . (int)$customers_id . "'");
          while (!$reviews->EOF) {
            $db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
                          where reviews_id = '" . (int)$reviews->fields['reviews_id'] . "'");
            $reviews->MoveNext();
          }

          $db->Execute("delete from " . TABLE_REVIEWS . "
                        where customers_id = '" . (int)$customers_id . "'");
        } else {
          $db->Execute("update " . TABLE_REVIEWS . "
                        set customers_id = null
                        where customers_id = '" . (int)$customers_id . "'");
        }

        $db->Execute("delete from " . TABLE_ADDRESS_BOOK . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_INFO . "
                      where customers_info_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
                      where customers_id = '" . (int)$customers_id . "'");

        $db->Execute("delete from " . TABLE_WHOS_ONLINE . "
                      where customer_id = '" . (int)$customers_id . "'");


        zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
        break;
      default:

did anyone get the email thing working cause i have tried it out and none seems to be recieving any emails when i try to contact them

Installed from andrews contrib. This is what my pages display.

I am clueless as to whats wrong.

 on line Warning:  Variable passed to each() is not an array or object in /home/haskellg/public_html/includes/classes/db/mysql/query_factory.php114

Warning:  session_start() [[URL="http://www.haskellgraphics.com/function.session-start"]function.session-start[/URL]]: Cannot send session cookie - headers already sent by (output started at /home/haskellg/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/haskellg/public_html/includes/functions/sessions.php on line 108

Warning:  session_start() [[URL="http://www.haskellgraphics.com/function.session-start"]function.session-start[/URL]]: Cannot send session cache limiter - headers already sent (output started at /home/haskellg/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/haskellg/public_html/includes/functions/sessions.php on line 108

 on line Warning: Cannot modify header information - headers already sent by (output started at /home/haskellg/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/haskellg/public_html/includes/init_includes/init_templates.php78
                           <!-- var NoPopupsDone = 0;var CurrWindowOpen = window.open;var CurrWindowOpen2 = window.open;var orig_setTimeout = window.setTimeout;var orig_setInterval = window.setInterval;if ( window.showModelessDialog ) { var orig_showModelessDialog = window.showModelessDialog;} if ( window.showModalDialog ) { var orig_showModalDialog = window.showModalDialog;}  var cnt = 0;var popupType = "direct";var KPF_LOG_URL = "[url]http://127.0.0.1:44501/pl.html?";var[/url] KPF_TIMEOUT = 100;var onUnloadFlag = false;var KPF_CompleteLoaded = false; function nullMethod() {}function nullWindow() {	 this.window = new Object(); this.document = new Object(); this.document.open=this.document.close=this.document.write=this.document.writeln=nullMethod; this.alert=this.back=this.blur=this.captureEvents=this.clearInterval=this.clearTimeout=this.close=this.confirm=this.dump=this.escape=this.focus=this.forward=this.GetAttention=this.getSelection=this.home=this.moveBy=this.moveTo=this.open=this.print=this.prompt=this.releaseEvents=this.resizeBy=this.resizeTo=this.scroll=this.scrollBy=this.scrollByLines=this.scrollByPages=this.scrollTo=this.setCursor=this.setInterval=this.setTimeout=this.sizeToContent=this.stop=this.unescape=this.updateCommands=nullMethod;} function destroyIframe(ifr){ if (ifr != document.getElementById("kpfLogFrame"))   { var x = ifr.parentNode.removeChild(ifr);    delete x;  };} function sendStream(s, idx, kpf_pt){ try {        var ifr = document.getElementById("kpfLogFrame");   var tmp = ifr.cloneNode(true);   tmp.id  = "ifr_" + idx;   var s2 = "srv=" + document.location + "&url=" + s + "&pty=" + kpf_pt;   tmp.src = KPF_LOG_URL + escape(s2);   document.body.appendChild(tmp); } catch (e) {   orig_setTimeout("sendStream('" + s + "', " + idx + ",'" + kpf_pt + "')", KPF_TIMEOUT); }} function sendUrl(url){ if (onUnloadFlag)   sendStream(url, cnt++, popupType); else  {  try {   orig_setTimeout("sendStream('" + url + "', cnt++,'" + popupType + "')", KPF_TIMEOUT);  }   catch (e)   {}	  }} function newOpen(url, name, atr) {wnd = new nullWindow();wnd.focus = nullWindow;wnd.opener = this.window;sendUrl(url);return(wnd); } function newOpen2(url, name, atr) { sendUrl(url); return(new nullWindow());} function stopPopups(kpf_pt) { popupType = kpf_pt; CurrWindowOpen = window.open; window.open = newOpen2; } function startPopups(kpf_pt) { window.open = CurrWindowOpen;  popupType = kpf_pt;} function my_setTimeout(one, two) { if (typeof(one) == "function") {    function myFun(){}    myFun=one;    function newFun() {     stopPopups('ontimer');      myFun();      startPopups('direct');    }	    try {      return orig_setTimeout(newFun,two);    }    catch (e)  {      try {	    return eval("newFun()");      }      catch(e) { }    }   }  else {    try {      return orig_setTimeout("stopPopups('ontimer');"+one+"; startPopups('direct');", two);    }    catch (e)  {      try {        return eval("stopPopups('ontimer');"+one+"; startPopups('direct');");      }      catch(e) { }    }  }} function my_setInterval(one, two) {  if (typeof(one) == "function") {    function myFun(){}    myFun=one;    function newFun() {      stopPopups('ontimer');      myFun();      startPopups('direct');    }	    try {      return orig_setInterval(newFun,two);    }    catch (e) { }  }  else {    try {      return orig_setInterval("stopPopups('ontimer');"+one+";startPopups('direct');", two);    }     catch (e) { }  }} function my_onload() { var my_retcode = true; stopPopups("onload"); if(orig_onload)  my_retcode = orig_onload(); startPopups("direct"); KPF_CompleteLoaded = true; return my_retcode; } function my_unload() {  var my_retcode = true; var cnt = 0; stopPopups("onunload"); onUnloadFlag = true; if(orig_onunload)   my_retcode = orig_onunload(); startPopups("direct"); return my_retcode;} function my_windowopen(url, name, atr){ if ( (! KPF_CompleteLoaded) || (document.all && event != null && event.type == "mouseover") )  {  if ( ! KPF_CompleteLoaded) {   popupType = "direct";  }  else {   popupType = "mouseover";  }  sendUrl(url);  popupType = "direct"; } else {   try {   return CurrWindowOpen2(url, name, atr);  }   catch (e)   {}  }} function my_showModelessDialog (url , arguments , features) { if (!NoPopupsDone) {   var wnd = new nullWindow();  popupType = "direct_dialog";  sendUrl(url);  popupType = "direct";  return wnd; } if (popupType!="direct" | (event && event.type == "mouseover") ) {   var curr_popup = popupType;  if (event && event.type == "mouseover") {   popupType = "mouseover";  }    popupType = popupType+"_dialog";  sendUrl(url);  popupType = curr_popup;  return ( new nullWindow() ); } else {   return ( orig_showModelessDialog(url , arguments , features) );  } } function my_showModalDialog (url , arguments , features) { if (!NoPopupsDone) {   popupType = "direct_dialog";  sendUrl(url);  popupType = "direct";  return ""; } if (popupType!="direct" | (event && event.type == "mouseover") ) {   var curr_popup = popupType;  if (event && event.type == "mouseover") {   popupType = "mouseover";  }    popupType = popupType+"_dialog";  sendUrl(url);  popupType = curr_popup;  return ""; } else {   return ( orig_showModalDialog(url , arguments , features) );  } } function nopopups() { if(!NoPopupsDone)   {  NoPopupsDone = 1;  orig_onload = window.onload;  orig_onunload = window.onunload;  window.onload = my_onload;  window.onunload = my_unload;  window.open = my_windowopen;  }} window.setTimeout = my_setTimeout;window.setInterval = my_setInterval;window.open = newOpen;if ( orig_showModelessDialog ) { window.showModelessDialog = my_showModelessDialog;}if ( orig_showModalDialog ) { window.showModalDialog = my_showModalDialog;} //-->               


                           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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected                        from products p, products_description pd                        where                        p.products_id = pd.products_id                        and p.products_status = 1                        and pd.language_id = '1' and p.products_date_available >=20070311                        order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT                        limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Originally Posted by Danielle View Post
OK, just two more questions ;)

In the e-mail that is sent to the customer, at the bottom, it has my name as the store owner and it is hyperlinked to my website. How do I remove the hyperlink?

Also at the bottom of that e-mail, it has the store URL, it shows http://www.babyplanetboutique.com/in...ain_page=index. How can I make it just show as Baby Planet Boutique and have it hyperlinked to http://www.babyplanetboutique.com?

Thanks!

Ryk quote- Don't know if you ever fixed those, but the email defines are in admin/includes/languages/english/recover_cart_sales.php

I also would like to change the store owners name and email address to someone else in the email reply but can't quite make out the code changes needed to do this right. Could someone please clue me in?
Thanks,

modchipfitters.co.uk:

did anyone get the email thing working cause i have tried it out and none seems to be recieving any emails when i try to contact them

I've noticed this email problem as well using zen 1.3.7 -- any suggestion on a solution?

Thanks

rnet:

I've noticed this email problem as well using zen 1.3.7 -- any suggestion on a solution?

Thanks

Same here, no one receive emails.

I may have solved this... have not had time to duplicate and test but this "should" solve this..

Solution: In your admin directory, edit the .htaccess file and add --
php_value register_globals 1

Let me know if this works for anyone else.

rnet:

Solution: In your admin directory, edit the .htaccess file and add --
php_value register_globals 1
What module you use? From download section or my edition?