Recover Cart [Support Thread]

[a_berezin]

would there be an easy way to
1. turn off plain-text mails?

Correct to create content for the text version separately, and separately for html-version. But these changes in the two lines do not fit.

would there be an easy way to
2. change the email content to remove the duplicate content

$mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
$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='. $basket->fields['products_id']) . "</a></blockquote>\n\n"; 

replace by

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

[gavwright]

Hi,
I've installed this mod with no problems (sort of...more on that in a minute). The mod works, in that it picks up abandoned carts...I've amended the PHP to show friendly URLs (from Ceon) and changed the wording to suit my shop. I can send emails OK and, from this perspective, all is well. However.....
Under Configuration>Configure RCS there are *NO* options listed - just headings, i.e. "Title Value Action"
I ran the SQL install for ZC1.5.0 (my site was a clean 1.5 install, although now heavily modified)...and I've checked three times that all six files are where they should be. I've just compared the actual content against the original files and all is as it should be. I'm at a bit of a loss...any bright ideas - about either a) what's wrong or b) what I've done wrong?

Cheers,
Gavin

[coucho]

Hi,

Just installed this mod but I get an error when trying to install the sql patch. I installed v1.5 as a clean install so I did not use the upgrade patch.

Any ideas as to why I am getting an error message.

[countrycharm]

Hi,

Just installed this mod but I get an error when trying to install the sql patch. I installed v1.5 as a clean install so I did not use the upgrade patch.

Any ideas as to why I am getting an error message.

You didn't post the error you were having so I'm assuming it's this here.
Probably the sql statement. Change the TYPE=MyISAM' to ENGINE=MyISAM and the problem may go away.

[coucho]

You didn't post the error you were having so I'm assuming it's this here.
Probably the sql statement. Change the TYPE=MyISAM' to ENGINE=MyISAM and the problem may go away.

Yep changing TYPE to ENGINE did the trick.

Thanks!

[gavwright]

Hi again,
I'd already changed 'TYPE' to 'ENGINE'...but I still see no configuration values!
:-(

[countrycharm]

Hi again,
I'd already changed 'TYPE' to 'ENGINE'...but I still see no configuration values!
:-(

Uninstall and install the sql statement again to see if that resolves your problem.

[gavwright]

Thanks for your input - sorry if I'm being thick...but how do I uninstall, as there isn't an uninstall SQL file?

Just in case this is what you meant, I renamed all six files (I don't use Russian...) and then ran the install SQL again. I then renamed the six files to what they should be. Still no configuration values...

[countrycharm]

Thanks for your input - sorry if I'm being thick...but how do I uninstall, as there isn't an uninstall SQL file?

Just in case this is what you meant, I renamed all six files (I don't use Russian...) and then ran the install SQL again. I then renamed the six files to what they should be. Still no configuration values...

Run this uninstall statement I provided for you. Before you go about renaming the file you need to make sure everything installs right first.

DROP TABLE IF EXISTS scart;
DELETE FROM admin_pages WHERE page_key='config_recover_cart_sales';
DELETE FROM admin_pages WHERE page_key='recover_cart_sales';
DELETE FROM admin_pages WHERE page_key='stats_recover_cart_sales'; 

Check your PM

[gavwright]

Works a treat - thanks :-)