when I try to add a new subscription as a node in lm_paypal I get this error message below.
However it works when I create the subscription as a role subscription, , then edit it to change it to a node subscription afterwards.

It looks the rid in lm_paypal_subscriptions is being inserted twice.

The version I am using is 4.7.4

user warning: Column 'rid' specified twice query: INSERT INTO cd01_lm_paypal_subscriptions SET status = 1,  rid = '3',rid = '',kind = '1',item_name = 'Test Advert',description = 'Test Paid Advert',a1 = null,p1 = null,t1 = 'D',a2 = null,p2 = null,t2 = 'D',a3 = '5',p3 = '1',t3 = 'W',src = null,srt = null,currency_code = 'GBP',return_url = null,uid_admin = '1',send_admin_onsub = '1',send_admin_onend = '1',send_user_onsub = '0',send_user_onsub_subject = 'Welcome to %Subscription%Node',send_user_onsub_body = 'Hello %Username and welcome to your new subscription %Subscription%Node on %Site',send_user_onnearend = '0',nearend_days = '5',send_user_onnearend_subject = 'Your subscription %Subscription ends soon',send_user_onnearend_body = 'Hello %Username your subscription to %Subscription on %Site ends in %Days days.' in /home/httpd/vhosts/my.domain.net/httpdocs/includes/database.mysql.inc on line 121.

Comments

LeeMcL’s picture

Component: User interface » Code
Assigned: Unassigned » LeeMcL
Priority: Normal » Critical
Status: Active » Fixed
StatusFileSize
new1.84 KB

Apologies for the problem. The CVS copy has been fixed and I've attached the patch I used.

LeeMcL’s picture

Status: Fixed » Closed (fixed)

Fixed so closing this issue