Recover Cart [Support Thread]

[torvista]

I have it working with 1.5...I am still making minor changes but if anyone wishes to test it before I upload it as compatible please PM me for a copy.

[testuser]

Any progress on making this 1.5 compatible???

I'll offer up $50 to whoever can get this working with 1.5.0, without compromising on 1.5.0's security. It's super important to us here at canemasters.com! Stupid me should have checked to see if this mod was compatible. I never would have upgraded if I knew it wasn't.

i have a client who needs this aswell so ill chip £20 in

Updated module to work with Zen Cart v1.5.

Should be up in download section soon. Please PM for donation details if necessary.

Here's the link: http://www.zen-cart.com/downloads.php?do=file&id=25

[testuser]

Here's the zip file until it's updated in the downloads section. Works with Zen Cart v1.5 as requested in thread.

recover_cart_sales_v4-00-00a.zip

PM for donation details per thread.

[Stuff4Toys]

Sure would be nice to see some automation in this module, via cron to run every xx minutes. also a shorter wait time, instead of waiting for customer to time out, set it for 8 - 10 minutes of inactivity.

Thanks for all your hard work.
JOhn ><>

[smcelligott]

Having a problem with the install. Just installed 1.50 and when I attempted to run the sql install file it identified an error in the syntax at: TYPE=MyISAM. Per another post, I changed Type to Engine, and it errored out at: SQL query:

SELECT (

@configuration_group_id := configuration_group_id
)
FROM configuration_group
WHERE configuration_group_title = 'Recover Cart Sales'
LIMIT 1 ;

MySQL said:

#1146 - Table 'sql_file_name.configuration_group' doesn't exist

I'm in over my head, any insights?

[DrByte]

Um, "sql_file_name" would clearly be incorrect. It should say your database name there instead.

Sounds like your database is using table-prefixes and the script you're trying to run needs you to manually add those prefixes before running it. Or if you don't understand the concept of tablename prefixes, then run the SQL script using the supplied SQL Patch tool in your ZC admin so that it can add them for you.

[smcelligott]

Um, "sql_file_name" would clearly be incorrect. It should say your database name there instead.

Dr B,

;) When I originally posted, it showed my sql file name (the REAL ONE), and I figured, I probably shouldn't name my database on a forum, as a security precaution so I changed it for this post to "sql_file_name" - but you may have hit upon the problem.

So if my real database name were talijewe_tj09 and my prefix is spm, my individual tables are:

spm_categories
spm_categories_description
spm_configuration
spm_configuration_group
spm_counter

The error I am getting is then: Table 'talijewe_tj09.configuration_group' doesn't exist.

As I've mentioned I am no SQL genius (apologies for stating the obvious, LOL), but now that you mention it, I'm curious where the 'spm' is in the error message? Do I need to edit the install-ZC-v-1-5.sql file somehow in order to add the prefix?

So if the table did exist what would its full 'name' be? Am I making any sense at all? ;)

Any help is appreciated!

[independenteasel]

Dr B,

;) When I originally posted, it showed my sql file name (the REAL ONE), and I figured, I probably shouldn't name my database on a forum, as a security precaution so I changed it for this post to "sql_file_name" - but you may have hit upon the problem.

So if my real database name were talijewe_tj09 and my prefix is spm, my individual tables are:

spm_categories
spm_categories_description
spm_configuration
spm_configuration_group
spm_counter

The error I am getting is then: Table 'talijewe_tj09.configuration_group' doesn't exist.

As I've mentioned I am no SQL genius (apologies for stating the obvious, LOL), but now that you mention it, I'm curious where the 'spm' is in the error message? Do I need to edit the install-ZC-v-1-5.sql file somehow in order to add the prefix?

So if the table did exist what would its full 'name' be? Am I making any sense at all? ;)

Any help is appreciated!

I have the exact same problem! Anybody know if we should add the prefix (mine is zen_)

[yapliren]

I am using ultimate seo and the email sent to customer does not reflect seo url

I want to modify this line but I do not know how to do it, anyone here familiar with this?

$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";

The link it generated will be site.com/index.php?main_page=product_info&products_id=281:ece5b925171ef7577e4923a0a71b685 e

where I got no idea where to remove ece5b925171ef7577e4923a0a71b685e

I am using this on zen cart v1.5.0

[ak6000]

I just installed and configured this module without any problem or error message.

When I go to either tool->Recover cart sales or Report->Recover cart sales results I see the following warring with no listing even though I have personally created few abandoned cart!

WARNING: An Error occurred, please refresh the page and try again.

Thanks for your help.