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.Quote:
Originally Posted by ma.r.a
What does it mean?
Does it change if there is an abandoned order?
???
Printable View
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.Quote:
Originally Posted by ma.r.a
What does it mean?
Does it change if there is an abandoned order?
???
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?
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?
changed
TYPE=MyISAM
to
ENGINE=MyISAM
then it works well
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?
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:
Is there a way to make it do this:Code: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
Code: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
That is not a session id that is a Product with the products_id plus the Attributes selected ...
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?
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 :)Quote:
Originally Posted by Ajeh