Recover Cart [Support Thread]

a_berezin:

recover_cart_sales.php on line 265
change

$outEmailAddr = '"' . $custname . '" <' . $inrec['email'] . '>';

> to
> ```
$outEmailAddr = '"' . $custname . '" <' . $inrec->fields['email'] . '>';

This fix worked for me. Thanks!

I grabbed the latest. Made the change above, but I still get my html email with just

Inquiry from izadra
$EMAIL_MESSAGE_HTML

inside my html email template.

Other than that, everything looks great. What am I overlooking?

Hi,

I am getting this error when using recover cart sales when I go Reports-recover carts

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.katsumi/michelle_rvc/michellesgaragesale.com/newcatalog/admin/stats_recover_cart_sales.php on line 134

Line 134 is- $rc_cnt = mysql_num_rows($conquery);

And then when I go to Tools- Recover carts I get this-

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.katsumi/michelle_rvc/michellesgaragesale.com/newcatalog/admin/recover_cart_sales.php on line 390

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.katsumi/michelle_rvc/michellesgaragesale.com/newcatalog/admin/recover_cart_sales.php on line 390

Line 390 says- if (mysql_num_rows($donequery) > 0) {

Any help would be appreciated- Thanks!
michelle

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. :cry:

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. :blush:
Thanks in advance, Kind regards,

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. :yes:

I have MySQL 4.3 I think :blink: i am sure it is not 5. and i run the SQL patch from the admin tool in Zen Cart.

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

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] [email protected] 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 :blush:

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

thanks a_berezin and everyone else. My webhost just recently disabled Register Globals and as soon as that happened I noticed RecoverCarts also gave me all the same problems you guys have.

I got the latest fix from a_berezin's site and its working perfectly. One thing tho, the "GO" button by the "# of days" filter points to a directory, but not an actual image. And the directory it points to doesn't exist either. Does anyone have a go button?

please update this fixed version in the downloads section too :)

qhome:

One thing tho, the "GO" button by the "# of days" filter points to a directory, but not an actual image. And the directory it points to doesn't exist either. Does anyone have a go button?
If you draw this button I will add it to rcs mod.

Although this mod works fine it's generating an error as well:

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

Line 30 = ```php
return date(DATE_FORMAT, mktime('', '', '', $month, $day, $year));

I also get this error if the attribute is set to true under the configurations for Recover Cart:
**[error] PHP Fatal error:  Cannot use object of type queryFactoryResult as array in /admin/recover_cart_sales.php on line 481**

Line 481 = ```php
$prodAttribs .= '<small><i> - ' . $attribrecs->fields['poname'] . ' ' .

Any help with this is appreciated.

Thanks!

Hi BlessIsaacola,

BlessIsaacola:

Although this mod works fine it's generating an error as well:

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

Line 30 = ```php
return date(DATE_FORMAT, mktime('', '', '', $month, $day, $year));

```php
return date(DATE_FORMAT, mktime(0, 0, 0, $month, $day, $year));

BlessIsaacola:

I also get this error if the attribute is set to true under the configurations for Recover Cart:
[error] PHP Fatal error: Cannot use object of type queryFactoryResult as array in /admin/recover_cart_sales.php on line 481

Line 481 = ```php
$prodAttribs .= '<small><i> - ' . $attribrecs->fields['poname'] . ' ' .

Replace it by
```php
$prodAttribs .= '<small><i> - ' . $attribrecs->fields['poname'] . ' ' . $attribrecs->fields['povname'] . '</i></small><br />';

Thanks Andrew, that fixed the error messages. However, the mod is still generating this error: client denied by server configuration: /admin/includes/languages/english/images/buttons/index.php

I suspect it has something to do with the button issue (where the go is just x'd).

Ok! Replace

zen_image_submit('', DAYS_FIELD_BUTTON) .

by

'<input type="submit" title="' . DAYS_FIELD_BUTTON . '" value="' . DAYS_FIELD_BUTTON . '" />' .

Does the download have all the latest tweaks?

Many thanks :-)

For some reason the Recover Carts contribution with the Global register Off does not work for me (on my Demo or Live stores 2 different DB, Keep getting SQL errors).
How do I set global to ON (To use the download version) and what the security issues when it is ON? Can someone enlight me?

Well my register global is ON and still have not been able touse the download version (Does not show detail of attribute and does not show delivery address. The tweked version just shows errors as I described in:

http://www.zen-cart.com/forum/showpost.php?p=278143&postcount=5

gmoyle:

I grabbed the latest. Made the change above, but I still get my html email with just

Inquiry from izadra
$EMAIL_MESSAGE_HTML

inside my html email template.

Other than that, everything looks great. What am I overlooking?

Any luck with this yet? It would be so wonderful if the e-mails could be sent as HTML, much prettier :D

Also, what is the latest version number? I have recover_cart_sales_1.5.

Thanks!

Hi Andrew

Thanks for this great mod. I have a small issue however.

Site stats

zen - v1.3.5
globals off - (prefer not to put on)
Mysql - 4.0.27
php - 4.3.11
Server - linux 2.4.21-32.0.1.EL

Problem

When clicking on an item description to view specifics within tools>recover cart sales I get the following error and nothing else shows up

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 ':b878d4bd907e33e159bba2e31a633e55' at line 1
in:
[select * from products_to_categories where products_id=298:b878d4bd907e33e159bba2e31a633e55]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I did install the sql file, several times!!

I haven't checked any of the other functionality of mod yet such as email etc

TIA for any thoughts!!

a_berezin has the latest version of this in his sig. which has html capabilities

Danielle:

Any luck with this yet? It would be so wonderful if the e-mails could be sent as HTML, much prettier :D

Also, what is the latest version number? I have recover_cart_sales_1.5.

Thanks!

How can we solve the customers email in html format?
$EMAIL_MESSAGE_HTML ???

100asa:

How can we solve the customers email in html format?
$EMAIL_MESSAGE_HTML ???

you can read the post above yours :) Solved :p