Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSC Affiliate check out problem


Recommended Posts

Hi

 

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.

 

Thanks

Del

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.

Guest
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...