Still no good

 

 

user warning: Unknown column 'allow_roles' in 'field list' query: INSERT INTO paypal_subscriptions (item_name, description, business, return_url, cancel_return, notify_url, currency_code, a1, p1, t1, a2, p2, t2, a3, p3, t3, src, sra, srt, rid, signup_mail_subject, signup_mail_body, eot_mail_subject, eot_mail_body, cancel_mail_subject, cancel_mail_body, modify_mail_subject, modify_mail_body, page_style, allow_roles, block_when, remove_when, user_types_url) VALUES ('Membership','$30 - for membership','sales@mydomain.com','','','','USD','','','','','','','30.00','2','D',1,0,0,3,'Thank you for Signing Up, [firstName]!','<p>Dear [firstName] [lastName], You have purchased the [subscriptionName] subscription for [amount] on [date], and have been granted the [roleName] role. Thank you! Sincerely, Site Admin</p>','[firstName], your Subscription has ended','<p>Dear [firstName] [lastName], Your [subscriptionName] subscription has expired or been cancelled. The [roleName] role has been removed. Sincerely, Site Admin</p>','Subscription Cancelled','<p>Dear [firstName] [lastName], Your [subscriptionName] subscription has been cancelled and will not automatically renew anymore. The [roleName] role will be removed at the end of the term. Sincerely, Site Admin</p>', 'Subscription Modified','<p>Dear [firstName] [lastName], Your subscription has been successfully modified. Sincerely, Site Admin</p>','','a:3:{i:2;i:2;i:1;i:0;i:3;i:0;}','','subscr_eot','') in /home/doma79/public_html/thenxtclassroom.com/modules/paypal/paypal_subscriptions/paypal_subscriptions.module on line 2404.

These are the subscriptions:

No Subscription Plans - Use the 'Add Subscription' Link to Add Plans

 

 The update wasn't successful for version 6406

 

 user warning: Duplicate column name 'start_date' query: ALTER TABLE paypal_user_subscriptions ADD `start_date` INT NOT NULL DEFAULT 0 in /home/..................../includes/database.mysql-common.inc on line 298.user warning: Duplicate column name 'current_payments' query: ALTER TABLE paypal_user_subscriptions ADD `current_payments` INT DEFAULT NULL in /home/......................./includes/database.mysql-common.inc on line 298.user warning: Duplicate column name 'max_payments' query: ALTER TABLE paypal_user_subscriptions ADD `max_payments` INT DEFAULT NULL in /home/................../includes/database.mysql-common.inc on line 298.

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

Main page

Administration pages

The following queries were executed paypal_subscriptions module Update #6406

Failed: ALTER TABLE {paypal_user_subscriptions} ADD `start_date` INT NOT NULL DEFAULT 0

ALTER TABLE {paypal_subscriptions} ADD `allow_roles` VARCHAR(2048) DEFAULT 'a:0:{}'

ALTER TABLE {paypal_subscriptions} ADD `user_types_url` VARCHAR(128) DEFAULT ''

ALTER TABLE {paypal_subscriptions} ADD `block_when` VARCHAR(32) DEFAULT ''

ALTER TABLE {paypal_subscriptions} ADD `remove_when` VARCHAR(32) DEFAULT 'subscr_eot'

Failed: ALTER TABLE {paypal_user_subscriptions} ADD `current_payments` INT DEFAULT NULL

ALTER TABLE {paypal_user_subscriptions} CHANGE `current_payments` `current_payments` INT NOT NULL

Failed: ALTER TABLE {paypal_user_subscriptions} ADD `max_payments` INT DEFAULT NULL

ALTER TABLE {paypal_user_subscriptions} CHANGE `max_payments` `max_payments` INT NOT NULL

 

 It's always a ')' or a ';' isn't it :)

 

Seems to be working now, only I still can't get it to automatically log in after you 'return to merchant' :(

 

Can you give me a dummies guide to what I need to setup?