Recover Cart [Support Thread]

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:

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

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

Ajeh:

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 :)

Probably just a simple swith in this code:

			// BEGIN OF ATTRIBUTE DB CODE
			$prodAttribs = ''; // DO NOT DELETE
			if (RCS_SHOW_ATTRIBUTES == 'true') {
				$attribrecs = $db->Execute("SELECT cba.products_id,
																					 po.products_options_name poname,
																					 pov.products_options_values_name povname
																		FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " cba,
																				 " . TABLE_PRODUCTS_OPTIONS . " po,
																				 " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov,
																				 " . TABLE_LANGUAGES . " l
																		WHERE cba.products_id ='" . (int)$basket->fields['products_id'] . "'
																			AND cba.customers_id = " . $curcus . "
																			AND po.products_options_id = cba.products_options_id
																			AND pov.products_options_values_id = cba.products_options_value_id
																			AND po.language_id =" . (int)$_SESSION['languages_id'] . "
																			AND pov.language_id =" . (int)$_SESSION['languages_id']);
				$hasAttributes = false;
				if ($attribrecs->RecordCount() > 0){
					$hasAttributes = true;
					$prodAttribs = '<br />';
					while (!$attribrecs->EOF){
						$prodAttribs .= '<small><i> - ' . $attribrecs->fields['poname'] . ' ' . $attribrecs->fields['povname'] . '</i></small><br />';
						$attribrecs->MoveNext();
					}
				}
			}
			// END OF ATTRIBUTE DB CODE

If I was any good with PHP I'm sure I'd see how to turn it off, but I amn't and I can't :)

See what happens if you change the references on $cline and $mline for:
$basket->fields['products_id']

to be:
(int)$basket->fields['products_id']

Well, I wasn't 100% sure what you meant about the $cline and $sline so I just replaced all eleven instances with the new (int)$basket->fields['products_id'] and it seems to have done the trick.... Thank you Ajeh, your genious is inspiring!

You really do not want to do that ...

Looking further at this file, I would first try a ...

Search of the file:
/your_secret_admin/recover_cart_sales.php

and search for:
$mline

and only on references to this $mline make the change ...

I am pretty sure if you do make this change in other places that you may actually break things on this program ...

Hi Ajeh,

I've taken your advice, gone back to the original file and replaced only the two instances with the $mline. It was only this line then:

			$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
			$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id'] ) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id'] ) . "</a></blockquote>\n\n";
			$basket->MoveNext();

Just need to run some tests and make sure it's still picking up on bailed carts.

OK, a quick test and it is no longer collecting data on bailed carts. So, changing that line breaks the mod.

well that is poopie ... :blink:

So you are saying the only change you made is on line 236:

            $mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. [B](int)[/B]$basket->fields['products_id']) . "</a></blockquote>\n\n";

and this broke it?

Ajeh:

well that is poopie ... :blink:

So you are saying the only change you made is on line 236:

        $mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. [B](int)[/B]$basket->fields['products_id']) . "</a></blockquote>\n\n";

> 
> and this broke it?

Not quite.  There are two instances of $basket->fields['products_id'] on line 236.  I'd changed both of them....  I'm going to re-try with just one of them changed to (int)$basket->fields['products_id']

OK, re-tested with this (just one single change):

$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id']) . "</a></blockquote>\n\n";

It definitely breaks the mod. What it does is stop it from actually collecting balied cart data.

Weird ... I may have to break down and install this to see how it is really working ...

Hang on though, I've just restored it to original and re-tested... it's not picking up the bailed cart again... maybe my test isn't right (adding something to cart, logging in and then closing browser).....

Weird alright, I've had a couple of bailed carts since we started. I'm going to make the change you suggested again and wait until tomorrow to see if any bailed carts show up. If not then it's definitely broken as we usually get about half a dozen a day from signed up customers.