When I have the EC Sale module installed and I run cron.php I get the following error:

user warning: Table 'woodswa8_drpl1.sale_product' doesn't exist query: DELETE FROM ec_cart WHERE nid IN(SELECT nid FROM sale_product WHERE sale_closes = 1 AND sale_closing_date < 1185374077) in /home/. . . /public_html/testing/includes/database.mysql.inc on line 172.

Also, the module is not closing sales on the specified dates. I am using the latest version.

Comments

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Status: Active » Closed (fixed)

This has been fixed in the development version.

Dewi Morgan’s picture

Dewi Morgan commented

Since this bug's been open for half a year, and I imagine people are interested in a workaround:

In the file:
modules/sale/sale.module:

Change the line:
db_query("DELETE FROM {ec_cart} WHERE nid IN(SELECT nid FROM {sale_product} WHERE sale_closes = 1 AND sale_closing_date < %d)", time());

To (for 5.x-1.0):
db_query("DELETE FROM {ec_cart} WHERE nid IN(SELECT nid FROM {sale_products} WHERE sale_closes = 1 AND sale_closing_date < %d)", time());

Or to (for 5.x-1.1):
db_query("DELETE FROM {ec_cart} WHERE nid IN(SELECT nid FROM {sale_items} WHERE sale_closes = 1 AND sale_closing_date < %d)", time());