Recover Cart [Support Thread]

[DrByte]

/admin/includes/extra_datafiles/recover_cart_database_tables.php (or maybe recover_cart_filenames.php ):

define('TABLE_SCART', 'scart');

vs

define('TABLE_SCART', DB_PREFIX . 'scart');

[firehorse]

Hi,

/admin/includes/extra_datafiles/recover_cart_database_tables.php (or maybe recover_cart_filenames.php ):

define('TABLE_SCART', 'scart');

vs

define('TABLE_SCART', DB_PREFIX . 'scart');

It was /admin/includes/extra_datafiles/recover_cart_filenames.php

Worked a treat

Best regards
Alan

[firehorse]

Hi,

I'm now trying out the email function. I click on send email and I get

1146 Table 'alanlam_zencart.orders' doesn't exist
in:
[select * from orders where customers_id = '2']

I assume it's a similar problem. I'm off to lunch and will have a look at after I get back if someone else hasn't solved it in the meantime!

Alan

[firehorse]

Hi,

For everyone using prefixes, this is all the changes I made to get it to work

/admin/includes/extra_datafiles/recover_cart_filenames.php
Change

define('TABLE_SCART', 'scart');

to

define('TABLE_SCART', DB_PREFIX . 'scart');
define('TABLE_ORDERS', DB_PREFIX . 'orders');

and in

/admin/recover_cart_sales.php

around line 265 change

$cquery = $db->Execute("select * from orders where customers_id = '" . $cid . "'" );

to

$cquery = $db->Execute("select * from " . TABLE_ORDERS . " where customers_id = '" . $cid . "'" );

It now works for me.

Best regards
Alan

[samad64]

i haven't installed this mod yet on my live site.. still testing it out on my test site. Lets say i decided to add this to my live site.. and then decided i no longer wanted to use it after a while. How would I go about uninstalling it?

Edit: Talking about the DB stuff, I know I can just delete the files and I won't have to worry about that. Mainly worried about DB stuff

[samad64]

also a quick note.. i just downloaded the file from andrew's site (a_berezin) and it already has the previously posted database prefix fixes

edit: i swear this is the last edit! is anyone having problems deleting past orders that are stuck? For example.. i have a few orders back from August that I'd like deleted.. but the delete button doesn't work. Thanks!

[heavenlynights]

also a quick note.. i just downloaded the file from andrew's site (a_berezin) and it already has the previously posted database prefix fixes

edit: i swear this is the last edit! is anyone having problems deleting past orders that are stuck? For example.. i have a few orders back from August that I'd like deleted.. but the delete button doesn't work. Thanks!

I too am having problems deleting past orders but I am sorry, I don't know how to fix. Just thought that I would let you know that you're not the only one.

Any suggestions by other users would be great. Thx

[Danielle]

Hi,

For everyone using prefixes, this is all the changes I made to get it to work

/admin/includes/extra_datafiles/recover_cart_filenames.php
Change

define('TABLE_SCART', 'scart');

to

define('TABLE_SCART', DB_PREFIX . 'scart');
define('TABLE_ORDERS', DB_PREFIX . 'orders');

and in

/admin/recover_cart_sales.php

around line 265 change

$cquery = $db->Execute("select * from orders where customers_id = '" . $cid . "'" );

to

$cquery = $db->Execute("select * from " . TABLE_ORDERS . " where customers_id = '" . $cid . "'" );

It now works for me.

Best regards
Alan

I deleted all files and database changes, reuploaded the mod, made the changes above, then uploaded the SQL, and it's still not working When I uploaded the SQL, it said this:

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 '; CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id' at line 1

And then, in Tools-Recover Cart Sales, it says this:

1146 Table 'baby_newzen.zen_scart' doesn't exist
in:
[select cb.customers_id, cb.products_id, cb.customers_basket_quantity, cb.customers_basket_date_added, cus.customers_firstname, cus.customers_lastname, cus.customers_telephone, cus.customers_email_address, sc.datemodified from zen_customers_basket cb left join zen_customers cus on (cb.customers_id = cus.customers_id) left join zen_scart sc on (cb.customers_id = sc.customers_id) where cb.customers_basket_date_added >= '20061126' and cb.customers_id not in ('') order by cb.customers_id asc, cb.customers_basket_date_added 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.

I am stumped!

[Danielle]

OK, when I was uploading the SQL patch I was doing it in my zen admin by uploading the file from my desktop. I just tried opening the sql file on my desktop using notepad, copying it all, and pasting it into the query box in my zen admin and it worked perfectly Yay!!!

[Danielle]

OK, just two more questions ;)

In the e-mail that is sent to the customer, at the bottom, it has my name as the store owner and it is hyperlinked to my website. How do I remove the hyperlink?

Also at the bottom of that e-mail, it has the store URL, it shows http://www.babyplanetboutique.com/in...ain_page=index. How can I make it just show as Baby Planet Boutique and have it hyperlinked to http://www.babyplanetboutique.com?

Thanks!