Recover Cart [Support Thread]

[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

[Matt Noiseux]

I downloaded the Recover Cart mod and tried to upload the mysql patch. However the patch does not get uploaded, rather the browser opens it. I have no problem uploading other patches. That is not the problem. It seems to be between the patch and my database wanting to accept it. Is this anything that anyone else has experienced or knows how to fix?

Many thanks,

Matt

[Matt Noiseux]

I looked closer and saw this warning in the text:

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

I am as new to mysql as you can get, any pointers would be appreciated.

[Danielle]

Where do I get the latest version of this? I don't see the link in Andrew's sig anymore

[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!!!