I have just installed this addon http://addons.oscommerce.com/info/4269
I have gone through all the files several times and it must be something that is missing in the package
kieran_mullen
Thanks but it did not help with your sql dump
This sql tables i have installed
CREATE TABLE `discount_coupons` (
`coupons_id` varchar(32) NOT NULL default '',
`coupons_description` varchar(64) NOT NULL default '',
`coupons_discount_amount` decimal(15,2) default NULL,
`coupons_discount_type` varchar(35) 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_min_order_type` varchar(50) default NULL,
`coupons_number_available` int(3) NOT NULL default '0',
PRIMARY KEY (`coupons_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Structure for the `discount_coupons_to_categories` table :
#
CREATE TABLE `discount_coupons_to_categories` (
`coupons_id` varchar(32) default NULL,
`categories_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `discount_coupons_to_customers` table :
#
CREATE TABLE `discount_coupons_to_customers` (
`coupons_id` varchar(32) default NULL,
`customers_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `discount_coupons_to_manufacturers` table :
#
CREATE TABLE `discount_coupons_to_manufacturers` (
`coupons_id` varchar(32) default NULL,
`manufacturers_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `discount_coupons_to_orders` table :
#
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Structure for the `discount_coupons_to_products` table :
#
CREATE TABLE `discount_coupons_to_products` (
`coupons_id` varchar(32) default NULL,
`products_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Structure for the `discount_coupons_to_zones` table :
#
CREATE TABLE `discount_coupons_to_zones` (
`discount_coupons_to_zones_id` int(11) NOT NULL auto_increment,
`coupons_id` varchar(32) default NULL,
`geo_zone_id` int(11) default NULL,
PRIMARY KEY (`discount_coupons_to_zones_id`),
UNIQUE KEY `discount_coupons_to_zones_id` (`discount_coupons_to_zones_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#
# Data for the `discount_coupons` table (LIMIT 0,500)
#
INSERT INTO `discount_coupons` (`coupons_id`, `coupons_description`, `coupons_discount_amount`, `coupons_discount_type`, `coupons_date_start`, `coupons_date_end`, `coupons_max_use`, `coupons_min_order`, `coupons_min_order_type`, `coupons_number_available`) VALUES
('testing001','testing',2,'percent',NULL,NULL,2,1,'price',1);
COMMIT;
#
# Data for the `discount_coupons_to_categories` table (LIMIT 0,500)
#
INSERT INTO `discount_coupons_to_categories` (`coupons_id`, `categories_id`) VALUES
('testing001',22);
COMMIT;
#
# Data for the `discount_coupons_to_customers` table (LIMIT 0,500)
#
INSERT INTO `discount_coupons_to_customers` (`coupons_id`, `customers_id`) VALUES
('testing001',4);
COMMIT;