Hello.
After installing RecoverCartSales 2.30a everything seems ok, but I get no results and the scart table is empty.
I get no errors anywhere. I have verified the installing instructions a couple of times and I have made no mistakes, so I'm absolutely lost.
What I do is:
In the admin > tools > Recover Cart Sales, I press GO button. I get no erros, but the result page is the same as before pressing the button.
After, I go to admin > Reports > Recovered Sales Results and the page result is ever the same (no result):
Total Recovered: 0% €0,00
The scart table is absolutely empty.
I have paste this SQL into phpmyadmin to test:
select cb.customers_id cid,
cb.products_id pid,
cb.customers_basket_quantity qty,
cb.customers_basket_date_added bdate,
cus.customers_firstname fname,
cus.customers_lastname lname,
cus.customers_telephone phone,
cus.customers_email_address email
from customers_basket cb,
customers cus
where cb.customers_id = cus.customers_id
order by cb.customers_basket_date_added desc,
cb.customers_id
I got 1122 records from 20090510 to 20050111 (I have my oscommerce working since january 2005)
There are 4 pending baskets with 30 items in the last week.
I have installed Quick Updates, Who's Online and some shipment and payment gateways modules, but I don't know it any of them can conflict with RecoverCartSales.
My software versions.
osCommerce 2.2-MS2
MySQL 5.0.32-Debian_7etch8-log
PHP Version: 5.2.0-8+etch13 (Zend: 2.2.0)
I have disabled this PHP functions: system, system_exec, passthru, shell, shell_exec, exec, phpinfo, pcntl_exec, dl, proc_close, proc_get_status, proc_nice, proc_open, proc_terminate, popen, pclose.
Any clue?