Recover Cart [Support Thread]

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

Quote:

---

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

Quote:

---

Originally Posted by 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 ???

Quote:

---

Originally Posted by 100asa

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

---

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

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

Quote:

---

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?

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

The version I have (downloaded from the link in Andrew's signature, above) says v 2.01 in the Tools->Recover Cart Sales, and v 2.0 in the Reports->Recover Cart Sales.

Both the tool and the report are working fine for diplaying, although I haven't tested the HTML email yet.

aha... I grabbed it from the contribs download section here. I should have known better, I grabbed it from Andrews site originally.. DOH!

If I have already installed the non-Andrew version of this which I downloaded from here, how do I properly remove it and the sql in order to install Andrews version?

Betty

Quote:

---

Originally Posted by 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!