I have a problem with renewal subscriptions using amember. The program works fine when people 1st signup and the renewal works as long as you want to renew the same subscription but if you try to signup for a different subscription you receive "Fatal Error". This is what the error looks like on my end. MYSQL ERROR: Duplicate entry '11' for key 2 in query: INSERT INTO amember_payments (member_id, product_id, begin_date, expire_date, paysys_id, amount, completed, remote_addr, data) VALUES ('11', '2', '2003-11-05', '2003-11-15', 'paypal', '45.95', 0, 'I deleted the URL for this post.', 'a:3:{s:10:"product_id";s:1:"2";s:9:"paysys_id";s:6:"paypal";s:6:"action";s:5:"renew";}') Another example is: MYSQL ERROR: Duplicate entry '10' for key 2 in query: INSERT INTO amember_payments (member_id, product_id, begin_date, expire_date, paysys_id, amount, completed, remote_addr, data) VALUES ('10', '1', '2003-11-01', '2003-11-02', 'paypal', '7.95', 0, '','I deleted the URL for this post 'a:4:{s:9:"PHPSESSID";s:32:"1850bbecb9125c229f4423660ac78e7b";s:10:"product_id";s:1:"1";s:9:"paysys_id";s:6:"paypal";s:6:"action";s:5:"renew";}') As you can see from these 2 "MYSQL ERROR" entries I have the subscriptions of 1 Day= $7.95, 10 Day=$45.95 and 30 Day=$90.95. So the problem usually occurs when someone signs up for 1 Day and then tries to renew and upgrade to 10 Day or 30 Day. I figure a quick fix to this problem is just to delete the old user info. for subscribers but I was trying to actually fix the problem instead of having people have to go back in and re-enter their info. and create new users names ect. Thanks for your help and consideration and I hope someone can help me with this problem.
Someone made "member_id" field unique index for table "payments". It has been made manually - nor aMember setup, not aMember code never do it. Please remove this index and everything will work as it should.
Member Renewal button? Hi, This shud be a pecular problem .... When a member wants to renew his membership, he is getting the drop down menu with different categories, but the submit button is missing and the renewal is not going to next step. Any help wud be appreciated.