TABLE_DISCOUNT_COUPONS doesn't exist

[Potent Rob]

I would have thought I did everything correctly but obviously not, as I'm getting the same error msg.

 

Module version installed is: Discount Coupon Codes 2.1 - 18 Sep 2006

 

 

Error msg.

1146 - Table 'xxxxxxx_osc22.TABLE_DISCOUNT_COUPONS' doesn't exist

 

SELECT coupons_discount_percent, coupons_description, coupons_max_use, coupons_min_order, coupons_max_order, coupons_number_available FROM TABLE_DISCOUNT_COUPONS WHERE coupons_id = '189' AND ( coupons_date_start <= CURDATE() OR coupons_date_start IS NULL ) AND ( coupons_date_end >= CURDATE() OR coupons_date_end IS NULL )

 

[TEP STOP]

 

 

Both these files:

includes/database_tables.php

admin/includes/database_tables.php

 

have this code:

//kgt - discount coupons

define('TABLE_DISCOUNT_COUPONS', 'discount_coupons');

define('TABLE_DISCOUNT_COUPONS_TO_ORDERS', 'discount_coupons_to_orders');

//end kgt - discount coupons

 

 

Run these statements via the SQL tab in phpMyAdmin.

 

CREATE TABLE discount_coupons (

coupons_id VARCHAR(32) NOT NULL DEFAULT '',

coupons_description VARCHAR(64) NOT NULL DEFAULT '',

coupons_discount_percent DECIMAL(7,4) DEFAULT NULL,

coupons_date_start DATETIME DEFAULT NULL,

coupons_date_end DATETIME DEFAULT NULL,

coupons_max_use INT(3) NOT NULL DEFAULT 0,

coupons_min_order DECIMAL(15,4) NOT NULL DEFAULT '0.0000',

coupons_max_order DECIMAL(15,4) NOT NULL DEFAULT '0.0000',

coupons_number_available INT(3) DEFAULT 0 NOT NULL,

PRIMARY KEY (coupons_id)

);

 

CREATE TABLE discount_coupons_to_orders (

discount_coupons_to_orders_id INT(11) NOT NULL AUTO_INCREMENT,

coupons_id VARCHAR(32) DEFAULT NULL,

orders_id INT(11) DEFAULT '0',

PRIMARY KEY (discount_coupons_to_orders_id),

KEY coupons_id (coupons_id)

);

 

Did the above and phpMyAdmin shows the correct mySQL tables:

discount_coupons

discount_coupons_to_orders

 

 

As part of testing, I also tried just installing the Module, no coupons created, to see if an error msg. would show when any coupon code was entered. Stll get same error msg.

 

Any advice on where to look next would be appreciated.