Recover Cart [Support Thread]

**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.

**Woodymon** · 12 Sep 2006, 12:14 AM

Originally Posted by camay123

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

In doing this are you not making your store/site less secure?

**BlessIsaacola** · 12 Sep 2006, 03:34 AM

Originally Posted by Woodymon

In doing this are you not making your store/site less secure?

Definitely less secure.

kelvyn · 12 Sep 2006, 07:18 AM

Originally Posted by BlessIsaacola

Definitely less secure.

Yeah, there MUST be a way-they did it with "quick updates". I just don't know how!

**a_berezin** · 12 Sep 2006, 10:39 AM

May be I can help you? ;)

**linkedla** · 5 Oct 2006, 07:39 AM

Originally Posted by camay123

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 ?

Sorry for ask, may you solve your problem? I am having the same one in my store, I got some registered users who left the site and no purchase is made, and the Recover Cart is always telling me the name and time the customer visit me, also the products cuantity, but not the price or reference of the products.

so if you could solve it and I did not see the way how in this forum I do apologize for that, but i need help on this issue.

Thanks in advance, Kind regards,

**linkedla** · 5 Oct 2006, 07:58 AM

I did install the newest contib, but now i got this error:

"1146 Table 'My-user_My-dbname.scart' doesn't exist"

the .scart is not in my DB tables so i think it is the problem, now i know it is something in the SQL database, but i am not a programmer, I just follow the steps, so may you can help me telling me whre to chang this to fit with my DB.

Thanks in advance, i do really appreciate your help.

I have MySQL 4.3 I think

i am sure it is not 5. and i run the SQL patch from the admin tool in Zen Cart.

**linkedla** · 5 Oct 2006, 08:28 AM

mmm, it seems that i am posting too much tonight,

I did install the last one adition and run the SQL file within the 1.5 version, also I did upload all the new files, but... this still not working I did log into the store as a customer put a product in the cart, and left the sesion, this is the result:

CONTACTED DATE CUSTOMER NAME E-MAIL PHONE
ITEM DESCRIPTION QTY PRICE TOTAL
Uncontacted 10/05/2006 Jose Antonio Suarez [CUSTOMER] linkedco AT gmail DOT com 571 269 6104
1 USD$0.00 USD$0.00
Cart Total: USD$0.00
Delete
Grand Total: USD$0.00

also I try to sent a mail but it do not came out,

I am using ZC 132, i will update soon

Thanks in advance for your help, i am a little sleepy right now so maybe it is the biggest problem.

Thread: Recover Cart [Support Thread]

Thread Tools

Search Thread

Display

Hybrid View

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]

Posting Permissions