I keep having troubles on the checkout_process with the affiliate sale not going into the database correctly...
1062 - Duplicate entry '0-1' for key 1
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-10-20 18:06:32', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MSN 8.0; MSN 8.5; MSNbMSNI; MSNmen-us; MSNcIA)', 'my ip address', '29.99', '1.2', '', '4', '4.0000', '1')
I've tried all kinds of stuff with this - reinstalls, drop and reload of database, still nothing is resolving this issue.
This is on a new install of oscommerce MS2 with osaffiliate 2.0