Quote Originally Posted by firehorse View Post
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

Code:
define('TABLE_SCART', 'scart');
to
Code:
define('TABLE_SCART', DB_PREFIX . 'scart');
define('TABLE_ORDERS', DB_PREFIX . 'orders');
and in

/admin/recover_cart_sales.php

around line 265 change

Code:
$cquery = $db->Execute("select * from orders where customers_id = '" . $cid . "'" );
to
Code:
$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!