Hi all,
I've been trying to install the latest version of the contribution but am receiving the following error when I go to admin>catalog>discount coupons:
I've tried to search for a solution but have come up with only ideas. The prevailing one is that I've installed old SQL tables. I installed the following:
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 ,
date_start datetime default NULL ,
date_end datetime default NULL ,
max_use int( 3 ) NOT NULL default 0,
min_order decimal( 15, 4 ) NOT NULL default '0.0000',
PRIMARY KEY ( coupons_id )
);# MySQL returned an empty result set (i.e. zero rows).
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 )
);# MySQL returned an empty result set (i.e. zero rows).
Any help would be appreciated. Thanks.