Recover Cart [Support Thread]

[Elemi]

Hi! Please:

1054 Unknown column 's.datemodified' in 'field list'
in:
[SELECT s.scartid, s.customers_id, s.dateadded, s.datemodified, c.customers_firstname, c.customers_lastname, c.customers_email_address FROM scart s LEFT JOIN customers c ON (s.customers_id = c.customers_id) WHERE dateadded >= '19700101' ORDER BY dateadded 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.

What's it?

I have this message as well, installed this mod last night on v1.3.9h. I couldn't find a reply to this query back in 2009.
What does it mean?
Does it change if there is an abandoned order?
???

[sensualpalace]

The only thing that shows up is in Configuration -> Recover Cart Sales

When I installed the SQL file, I get this error.

15 statements processed.
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

I am assuming this is because the table names have custom prefixes. How do I go about changing these and fixing these errors?

[boomup]

when I install sql, there is an error:

PHP Fatal error: 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 'TYPE=MyISAM' at line 1 :: CREATE TABLE zen_scart ( scartid int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', dateadded varchar(8) NOT NULL default '', datemodified varchar(8) NOT NULL default '', PRIMARY KEY (scartid), UNIQUE KEY customers_id (customers_id), UNIQUE KEY scartid (scartid) ) TYPE=MyISAM; in /public_html/includes/classes/db/mysql/query_factory.php on line 120

how to fix it?

[boomup]

changed

TYPE=MyISAM

to

ENGINE=MyISAM

then it works well

[roeghar]

I've been upgrading my cart from 1.3.8a to 1.5.1 and well as most of the addons I've installed over the years. I'm working on my home copy at this point. For the most part its gone well, but I've run into a small problem with recover cart sales for zen cart 1.5. I've checked the location of the uploaded files several times and all seems to be correct, and I got no error messages when running the sql patch. Since I had an earlier copy installed before my general upgrade the scart table still existed in my sql data base (I checked it in phpMyAdmin) I ran the update version. The tools menu and the report menu looked fine and old abandoned carts were listed as usual, BUT the configuration menu is blank except for "title, value, and action. Tried running the full sql install and nothing changed. Didn't even wipe out the names of customers who had abandoned carts.

I've looked though this forum and couldn't find any answers. Anybody have any ideas of what might be wrong?

[limelites]

Is there a way to remove the session ID's from the URL attached to the message this mod sends customers? For example, we'd much prefer if the link was clickable so instead of this:

We would like to thank you for having shopped at SILK BLOOMS LTD in the past. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction.

Shopping Cart Contents:
1 x Stunning Vintage Ivory Rose & Hydrangea Flowergirls Pomander
http://www.silkblooms.co.uk/index.php?main_page=product_info&products_id=5505:fb9fab1a6f0d49978602e19f71abc707

Is there a way to make it do this:

We would like to thank you for having shopped at SILK BLOOMS LTD in the past. We noticed that during a visit to our store you placed the following item(s) in your shopping cart, but did not complete the transaction.

Shopping Cart Contents:
1 x Stunning Vintage Ivory Rose & Hydrangea Flowergirls Pomander
http://www.silkblooms.co.uk/index.php?main_page=product_info&products_id=5505

[Ajeh]

That is not a session id that is a Product with the products_id plus the Attributes selected ...

[limelites]

I always wondered what that gobblydeegook was at the end of some of the URL's we get sent.... Is there a way to switch them off at all?

[Ajeh]

Probably, but I do not use this add on so I cannot speculate on the customization that you would need ...

[limelites]

Probably, but I do not use this add on so I cannot speculate on the customization that you would need ...

If you have ecommerce stores then I'd recommend this mod. It's definitely a good sale clincher as it gets you back in contact with any bailed cart customers. I find that nine times out of ten they'll get back in touch because of this mod. Definitely a good add-on to use...... If you do decide to download it, maybe you can have a look at the weird URL with attributes selected issue :)