View Full Version : osC Affiliate

12-06-2007, 02:10 PM
For some reason myself and others in the forums seems to have installations of osc affiliate that want a affiliate_category_id field in the affiliate banners table but the sql file didn't have it so we get errors like 1054 - Unknown column 'affiliate_category_id' when we try to create a banner.

This sql file has the missing field.

This is just the sql file.

If you don't want to replace your affiliate tables then just run this instead. It will only replace the banner table:

DROP TABLE IF EXISTS affiliate_banners;
CREATE TABLE affiliate_banners (
affiliate_banners_id int(11) NOT NULL auto_increment,
affiliate_banners_title varchar(64) NOT NULL default '',
affiliate_products_id int(11) NOT NULL default '0',
affiliate_category_id` int(11) NOT NULL default '0',
affiliate_banners_image varchar(64) NOT NULL default '',
affiliate_banners_group varchar(10) NOT NULL default '',
affiliate_banners_html_text text,
affiliate_expires_impressions int(7) default '0',
affiliate_expires_date datetime default NULL,
affiliate_date_scheduled datetime default NULL,
affiliate_date_added datetime NOT NULL default '0000-00-00 00:00:00',
affiliate_date_status_change datetime default NULL,
affiliate_status int(1) NOT NULL default '1',
PRIMARY KEY (affiliate_banners_id)

I think I'm using 2.7 and I think it is needed for 2.7 but I don't know for sure.

More... (http://addons.oscommerce.com/info/158)