wolter Posted August 29, 2003 Share Posted August 29, 2003 Hi I installed the Affiliate system but when ordering a product via an affiliate link, I get the following error on checkout: 1054 - Unknown column 'affiliate_salesman' in 'field list' insert into affiliate_sales (affiliate_id, affiliate_date, affiliate_browser, affiliate_ipaddress, affiliate_value, affiliate_payment, affiliate_orders_id, affiliate_clickthroughs_id, affiliate_percent, affiliate_salesman) values ('1', '2003-08-29 12:59:23', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)', '62.194.139.251', '26.85', '2.69', '46', '12', '10.00', '1') [TEP STOP] Now I checked the database and there is no column affiliate_salesman in the sql db. It?s not included in the supplied sql installation file as well. Does this mean that this is a mistake made by the author or and if so, what do I have to do to add the column to the affiliate_sales table? Kind regards Quote Link to comment Share on other sites More sharing options...
erisen Posted August 29, 2003 Share Posted August 29, 2003 can you post the url to the contribution you have downloaded? Is it Henri's affiliate module? If it is it works fine on my site :o Quote GALATASARAY RULES! ultrAslan - ultrAslan - ultrAslan Link to comment Share on other sites More sharing options...
wolter Posted August 29, 2003 Author Share Posted August 29, 2003 I also picked out the line in catalog/includes/affiliate_checkout_process that causes the error: $sql_data_array = array('affiliate_id' => $affiliate_ref, 'affiliate_date' => $affiliate_clientdate, 'affiliate_browser' => $affiliate_clientbrowser, 'affiliate_ipaddress' => $affiliate_clientip, 'affiliate_value' => $affiliate_total, 'affiliate_payment' => $affiliate_payment, 'affiliate_orders_id' => $insert_id, 'affiliate_clickthroughs_id' => $affiliate_clickthroughs_id, 'affiliate_percent' => $affiliate_percent, 'affiliate_salesman' => $affiliate_ref); The last line of code is a non existing column in my table. In addition, I noticed that the first and last column are to be filled with the same $affiliate_ref. I haven?t tried removing the last line yet since I don?t know what it?s supposed to do. Quote Link to comment Share on other sites More sharing options...
henri Posted August 31, 2003 Share Posted August 31, 2003 Just looked at the sql file. It's in it. DROP TABLE IF EXISTS affiliate_sales; CREATE TABLE affiliate_sales ( affiliate_id int(11) NOT NULL default '0', affiliate_date datetime NOT NULL default '0000-00-00 00:00:00', affiliate_browser varchar(100) NOT NULL default '', affiliate_ipaddress varchar(20) NOT NULL default '', affiliate_orders_id int(11) NOT NULL default '0', affiliate_value decimal(15,2) NOT NULL default '0.00', affiliate_payment decimal(15,2) NOT NULL default '0.00', affiliate_clickthroughs_id int(11) NOT NULL default '0', affiliate_billing_status int(5) NOT NULL default '0', affiliate_payment_date datetime NOT NULL default '0000-00-00 00:00:00', affiliate_payment_id int(11) NOT NULL default '0', affiliate_percent DECIMAL(4,2) NOT NULL default '0.00', affiliate_salesman int(11) NOT NULL default '0', PRIMARY KEY (affiliate_orders_id,affiliate_id) ); But: ALTER TABLE `affiliate_sales` ADD `affiliate_salesman` INT( 11 ) NOT NULL ; should work to Quote Link to comment Share on other sites More sharing options...
wolter Posted September 1, 2003 Author Share Posted September 1, 2003 Hi Henri, Your?re the best, adding the line solved the problem as could be expected. however, I checked my SQl file but Im confident the affiliate_salesman int(11) NOT NULL default '0', line isn?t in it. Anywayz, that?s history now. I?ll now try to install the branding module (now known as shop). Is it wise to update to a newer edition of osAffiliate first? Kind regards and thanks for your help, again! Wolter Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.