Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

OSC Affiliate check out problem

Recommended Posts



I have OSC affiliate installed on 2.2 on the April Snapshot. I created a banner link for a test product and did a test purchase using the affiliate link - the first one went through fine and worked perfectly in all areas including tracking the click etc etc. But any others I have tried fail with the below error at checkout_process.php


1062 - Duplicate entry '0' 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) values ('1', '2003-05-12 17:00:30', 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)', 'xxx.xxx.xxx.xxx', '229.99', '23', '', '3', '10.0000')


It looks like affiliate_orders_id isn't getting passed through and sometimes the same happens to affiliate_clickthroughs_id


Any advice would be much appreciated.




Link to comment
Share on other sites

  • 9 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...