Recover Cart [Support Thread]

**ladysaat** · 5 Jun 2006, 06:42 AM

ahh okay, I have sent my host a trouble ticket to make sure those are set to "On" I thought they'd done it already. When I searched I searched under Recover Cart errors and such. I will do the suggestion and search harder next time. Thanks for the help!!

**Mechular** · 25 Jul 2006, 02:57 AM

How do you upload the htaccess so that it doesnt default back to the original settings when you refresh the page?

**shqipo** · 26 Jul 2006, 01:34 AM

When I access RC from Tools it doesn't give me any errors, but when I try to access it from Reports, I get this:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/totaltra/public_html/store/admin/stats_recover_cart_sales.php on line 117

Any ideas?

Also, when I access RC, for some reasons the "roll-over" in adminmenues stop working and I have to click on Admin Home in order to use the other menues.

**Zapisto** · 27 Jul 2006, 07:56 PM

I notice a strange thing.
when i use recover cart (last version with 1.3.0.2) to contact a customer who left a cart , when this customer is *NOT* an actual customer every things works great and i can see a date of last time he get contacted for this left over cart.
When this customer is an actual customer , the status stay to "uncontacted" even if the mail is getting send properly.

any info to how to fix this ?

**voltage** · 28 Jul 2006, 02:22 AM

How can you contact someone who is not a customer, or are you talking about people who have placed an order at your store?

**Zapisto** · 28 Jul 2006, 04:13 AM

Originally Posted by voltage

How can you contact someone who is not a customer, or are you talking about people who have placed an order at your store?

In a store you regestered users and customers
customers is someone who already buy from you
registered is someone who did not yet buy from you.

**zforrest** · 7 Aug 2006, 03:19 PM

Originally Posted by ladysaat

I got this error after successfully installing the SQL patch and then clicking on RecoverCart in the tools area:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/hodllc/houseofdiva.com/zencart/admin/recover_cart_sales.php on line 410

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/hodllc/houseofdiva.com/zencart/admin/recover_cart_sales.php on line 410

Line 410 reads: $inrec2 = mysql_fetch_array($query2);

I am using zencart v1.3.0.1 and I just got this mod from the downloads sec. here.

So what does it mean? I looked at the file and I do not know what is "supposed" to be there versus what is.

To fix that error, replace $inrec2 = mysql_fetch_array($query2); with $inrec2 = @mysql_fetch_array($query2);

Also, someone mentioned how the javascript menu wouldn't work on those pages generated by recover carts module, so the fix for that is...

lines 103 -113 of admin > recover_cart_sales.php, replace this code <br /><br />

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET;?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

with this code

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
<script language="javascript" src="includes/menu.js"></script>
<script language="javascript" src="includes/general.js"></script>

<script type="text/javascript">

</script>
</head>
<body onLoad="init()">

**camay123** · 27 Aug 2006, 09:19 AM

Thanks Zforrest, those have done the trick.

But Im still confronted to a problem.

In admin / tools / Recovert cart

I can see there were some empty cart since I see customers but there order are filled with blank line and each item is priced 0.00$

Any help someone ?

**camay123** · 27 Aug 2006, 02:00 PM

Corrected the above problem by turning on Register in htaccess of the /admin dir.

**kelvyn** · 3 Sep 2006, 01:42 PM

Originally Posted by zforrest

To fix that error, replace $inrec2 = mysql_fetch_array($query2); with $inrec2 = @mysql_fetch_array($query2);

Also, someone mentioned how the javascript menu wouldn't work on those pages generated by recover carts module, so the fix for that is...

lines 103 -113 of admin > recover_cart_sales.php, replace this code <br /><br />

with this code

Also, apply that fix to \admin\stats_recover_cart_sales.php

Just noticed a weird problem - in recover cart sales stats, if you enter 54 days or over in the box, it gives the error

Code:

Warning: mktime() expects parameter 1 to be long, string given in /xxx/admin/stats_recover_cart_sales.php on line 55

Thread: Recover Cart [Support Thread]

Thread Tools

Search Thread

Display

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Re: Recover Cart

Similar Threads

Shipping Rates in Cart [support thread]

Shopping Cart Steps Images [Support Thread]

v151 AJAX Add to Cart [Support Thread]

Empty Cart Manager [support thread]

Bookmarks

Bookmarks

Posting Permissions