Recover Cart [Support Thread]

[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?

[michelle_rvc]

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

[Danielle]

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

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

Thanks!

[heavenlynights]

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!!

[heavenlynights]

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

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

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

Thanks!

[100asa]

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

[qhome]

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

you can read the post above yours :) Solved

[Danielle]

I've installed the newest version, but when I go to Tools-Recover Carts, it says

1146 Table 'baby_newzen.scart' doesn't exist
in:
[select cb.customers_id, cb.products_id, cb.customers_basket_quantity, cb.customers_basket_date_added, cus.customers_firstname, cus.customers_lastname, cus.customers_telephone, cus.customers_email_address, sc.datemodified from zen_customers_basket cb left join zen_customers cus on (cb.customers_id = cus.customers_id) left join scart sc on (cb.customers_id = sc.customers_id) where cb.customers_basket_date_added >= '20061021' and cb.customers_id not in ('') order by cb.customers_id asc, cb.customers_basket_date_added desc]
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've tried installing the sql through my zen admin and through phpmyadmin. My db has the prefix zen_. When I installed the SQL through phpmyadmin, the above error was no longer there, but a similar error appeared on the page when I tried to click send to send an e-mail to a customer, this time saying the orders table does not exist. It looks like it's trying to pull the info from the table without the prefix. How do I get the db prefix in there?

[gmoyle]

Well, I removed all the old files, downloaded the new 1.5 and installed it to my server and now I am seeing two issues.

1) $EMAIL_MESSAGE_HTML is still all I see in the body copy of emails I send when HTML is turned on in the admin.

2) It appears that there is no defines in the module for the headers? In the report section, all variables are showing, instead of correct titles.

i.e.HEADING_TITLE
DAYS_FIELD_PREFIXDAYS_FIELD_POSTFIX
TOTAL_RECORDS 4
TOTAL_SALES 0TOTAL_SALES_EXPLANATION
TABLE_HEADING_SCART_ID TABLE_HEADING_SCART_DATE TABLE_HEADING_CUSTOMER TABLE_HEADING_ORDER_DATE TABLE_HEADING_ORDER_STATUS TABLE_HEADING_ORDER_AMOUNT

Greg

[Danielle]

I've installed the newest version, but when I go to Tools-Recover Carts, it says


I've tried installing the sql through my zen admin and through phpmyadmin. My db has the prefix zen_. When I installed the SQL through phpmyadmin, the above error was no longer there, but a similar error appeared on the page when I tried to click send to send an e-mail to a customer, this time saying the orders table does not exist. It looks like it's trying to pull the info from the table without the prefix. How do I get the db prefix in there?

So noone else is having this problem? I am using the latest version of Recover Carts and my Zen is v.1.3.5. Does anyone who uses a db prefix have this working???

Thank you!