Thanks Leighton.

Rod

Ok, figured out that since I bought this module it has changed and now comes with a 'core' module that needs to be uploaded and enabled.

However, still got the following error page when running the upgrade

Drupal database update
user warning: Table 'ms_membership_plans_old' already exists query: RENAME TABLE ms_membership_plans TO ms_membership_plans_old in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 365.
user warning: Table 'ms_memberships_old' already exists query: RENAME TABLE ms_memberships TO ms_memberships_old in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 368.
user warning: Table 'ms_membership_plans' already exists query: CREATE TABLE ms_membership_plans ( `mpid` INT NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL, `description` TEXT DEFAULT NULL, `main_amount` DECIMAL(10, 2) NOT NULL, `main_length` INT NOT NULL, `main_unit` VARCHAR(128) DEFAULT NULL, `trial_amount` DECIMAL(10, 2) NOT NULL, `trial_length` INT NOT NULL, `trial_unit` VARCHAR(128) DEFAULT NULL, `recurring` INT NOT NULL, `total_occurrences` INT NOT NULL, `signup_mail_subject` VARCHAR(255) DEFAULT NULL, `signup_mail_body` TEXT DEFAULT NULL, `eot_mail_subject` VARCHAR(255) DEFAULT NULL, `eot_mail_body` TEXT DEFAULT NULL, `cancel_mail_subject` VARCHAR(255) DEFAULT NULL, `cancel_mail_body` TEXT DEFAULT NULL, `modify_mail_subject` VARCHAR(255) DEFAULT NULL, `modify_mail_body` TEXT DEFAULT NULL, `expiring_mail_subject` VARCHAR(255) DEFAULT NULL, `expiring_mail_body` TEXT DEFAULT NULL, `expiring_mail_days` INT NOT NULL, `start_grant_roles` TEXT DEFAULT NULL, `start_remove_roles` TEXT DEFAULT NULL, `expire_grant_roles` TEXT DEFAULT NULL, `expire_remove_roles` TEXT DEFAULT NULL, `weight` INT NOT NULL DEFAULT 0, `allow_roles` TEXT DEFAULT NULL, `register_urls` VARCHAR(128) DEFAULT '', `expire_when` VARCHAR(32) DEFAULT 'subscr_eot', `show_registration` INT NOT NULL, `show_account` INT NOT NULL, `modify_options` TEXT DEFAULT NULL, `data` TEXT DEFAULT NULL, PRIMARY KEY (mpid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /usr/home/national/public_html/includes/database.inc on line 529.
user warning: Table 'ms_memberships' already exists query: CREATE TABLE ms_memberships ( `mid` INT NOT NULL auto_increment, `oid` INT NOT NULL, `uid` INT NOT NULL, `mpid` INT NOT NULL, `status` INT NOT NULL DEFAULT 1, `expiration` INT NOT NULL DEFAULT 0, `start_date` INT NOT NULL DEFAULT 0, `current_payments` INT NOT NULL DEFAULT 0, `max_payments` INT NOT NULL DEFAULT 0, PRIMARY KEY (mid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /usr/home/national/public_html/includes/database.inc on line 529.
user warning: Duplicate entry '1' for key 'PRIMARY' query: INSERT INTO ms_membership_plans (mpid, name, description, main_amount, main_length, main_unit, trial_amount, trial_length, trial_unit, recurring, total_occurrences, signup_mail_subject, signup_mail_body, eot_mail_subject, eot_mail_body, cancel_mail_subject, cancel_mail_body, modify_mail_subject, modify_mail_body, expiring_mail_subject, expiring_mail_body, expiring_mail_days, start_grant_roles, start_remove_roles, expire_grant_roles, expire_remove_roles, weight, allow_roles, register_urls, expire_when, show_registration, show_account, data) VALUES (1, 'Standard Membership Annual', 'Standard membership of The National Photographic Society - £49.95 annual payment\r\nUK or Overseas', 49.95, 1, 'Y', 0.00, 0, '', 1, 0, 'Thank you for Signing Up, [customerName]!', '<p>\r\n Dear [customerName] , You have purchased the [planName] membership for [paymentAmount] on [site-date], and have been granted the [changedRoles] role. Thank you! Sincerely, Site Admin</p>\r\n', '[customerName], your Membership has ended', '<p>\r\n Dear [customerName] , Your [planName] membership has expired or been cancelled. The [changedRoles] role has been removed. To renew your membership, please click the following link: [renewLink] Sincerely, Site Admin</p>\r\n', 'Membership Cancelled', '<p>\r\n Dear [customerName] , Your [planName] membership has been cancelled and will not automatically renew anymore. The [changedRoles] role will be removed at the end of the term. Sincerely, Site Admin</p>\r\n', 'Membership Modified', '<p>\r\n Dear [customerName] , Your membership has been successfully modified. Sincerely, Site Admin</p>\r\n', '[customerName], your Membership is Expiring Soon!', '<p>\r\n Dear [customerName] , Your [planName] membership will expire on [expirationDate]. To renew your membership, click the following link: [renewLink] Sincerely, Site Admin</p>\r\n', 0, 'a:1:{i:6;s:1:\"6\";}', 'a:0:{}', 'a:1:{i:0;s:1:\"0\";}', 'a:1:{i:6;s:1:\"6\";}', 2, 'a:7:{i:1;i:0;i:2;i:0;i:4;i:0;i:5;i:0;i:3;i:0;i:6;i:0;i:7;i:0;}', '', 'subscr_eot', 1, 1, 'a:1:{s:17:\"override_settings\";a:2:{s:13:\"ms_paypal_wps\";a:2:{s:8:\"override\";i:1;s:8:\"settings\";a:2:{s:4:\"main\";a:2:{s:19:\"ms_paypal_wps_email\";s:40:\"info@national-photographic-society.co.uk\";s:25:\"ms_paypal_wps_use_sandbox\";b:0;}s:8:\"advanced\";a:4:{s:27:\"ms_paypal_wps_cancel_return\";N;s:24:\"ms_paypal_wps_page_style\";s:0:\"\";s:17:\"ms_paypal_wps_sra\";s:1:\"0\";s:25:\"ms_paypal_wps_no_shipping\";s:1:\"1\";}}}s:13:\"ms_affiliates\";a:1:{s:8:\"settings\";a:1:{s:4:\"main\";a:1:{s:32:\"ms_affiliates_payout_percentages\";s:0:\"\";}}}}}') in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 619.
user warning: Duplicate entry '2' for key 'PRIMARY' query: INSERT INTO ms_membership_plans (mpid, name, description, main_amount, main_length, main_unit, trial_amount, trial_length, trial_unit, recurring, total_occurrences, signup_mail_subject, signup_mail_body, eot_mail_subject, eot_mail_body, cancel_mail_subject, cancel_mail_body, modify_mail_subject, modify_mail_body, expiring_mail_subject, expiring_mail_body, expiring_mail_days, start_grant_roles, start_remove_roles, expire_grant_roles, expire_remove_roles, weight, allow_roles, register_urls, expire_when, show_registration, show_account, data) VALUES (2, 'LNPS', 'Upgrade to Licenciate from Standard user or transfer from SWPP or MPA Licenciate - £29.95', 29.95, 0, '', 0.00, 0, '', 0, 0, 'Thank you for Signing Up, [customerName]!', 'Dear [customerName] ,\r\nYou have purchased the [planName] membership for [paymentAmount] on [site-date], and have been granted the [changedRoles] role. Thank you!\r\n\r\nSincerely,\r\nSite Admin', '[customerName], your Membership has ended', 'Dear [customerName] ,\r\nYour [planName] membership has expired or been cancelled. The [changedRoles] role has been removed.\r\nTo renew your membership, please click the following link: [renewLink]\r\n\r\nSincerely,\r\nSite Admin', 'Membership Cancelled', 'Dear [customerName] ,\r\nYour [planName] membership has been cancelled and will not automatically renew anymore. The [changedRoles] role will be removed at the end of the term.\r\n\r\nSincerely,\r\nSite Admin', 'Membership Modified', 'Dear [customerName] ,\r\nYour membership has been successfully modified.\r\n\r\nSincerely,\r\nSite Admin', '[customerName], your Membership is Expiring Soon!', 'Dear [customerName] ,\r\nYour [planName] membership will expire on [expirationDate]. To renew your membership, click the following link: [renewLink]\r\n\r\nSincerely,\r\nSite Admin', 0, 'a:1:{i:3;s:1:\"3\";}', 'a:0:{}', 'a:1:{i:0;s:1:\"0\";}', 'a:1:{i:3;s:1:\"3\";}', 5, 'a:7:{i:6;i:6;i:1;i:0;i:2;i:0;i:4;i:0;i:5;i:0;i:3;i:0;i:7;i:0;}', '', 'subscr_eot', 0, 1, 'a:1:{s:17:\"override_settings\";a:2:{s:13:\"ms_paypal_wps\";a:2:{s:8:\"override\";i:1;s:8:\"settings\";a:2:{s:4:\"main\";a:2:{s:19:\"ms_paypal_wps_email\";s:40:\"info@national-photographic-society.co.uk\";s:25:\"ms_paypal_wps_use_sandbox\";b:0;}s:8:\"advanced\";a:4:{s:27:\"ms_paypal_wps_cancel_return\";N;s:24:\"ms_paypal_wps_page_style\";s:0:\"\";s:17:\"ms_paypal_wps_sra\";s:1:\"1\";s:25:\"ms_paypal_wps_no_shipping\";s:1:\"1\";}}}s:13:\"ms_affiliates\";a:1:{s:8:\"settings\";a:1:{s:4:\"main\";a:1:{s:32:\"ms_affiliates_payout_percentages\";s:0:\"\";}}}}}') in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 619.
user warning: Duplicate entry '3' for key 'PRIMARY' query: INSERT INTO ms_membership_plans (mpid, name, description, main_amount, main_length, main_unit, trial_amount, trial_length, trial_unit, recurring, total_occurrences, signup_mail_subject, signup_mail_body, eot_mail_subject, eot_mail_body, cancel_mail_subject, cancel_mail_body, modify_mail_subject, modify_mail_body, expiring_mail_subject, expiring_mail_body, expiring_mail_days, start_grant_roles, start_remove_roles, expire_grant_roles, expire_remove_roles, weight, allow_roles, register_urls, expire_when, show_registration, show_account, data) VALUES (3, 'Student / Overseas', 'Student / Overseas membership of The National Photographic Society. Not eligible for LNPS, ANPS or FNPS qualifications. - £29.95', 29.95, 1, 'Y', 0.00, 0, '', 1, 0, 'Thank you for Signing Up, [customerName]!', '<p>\r\n Dear [customerName] , You have purchased the [planName] membership for [paymentAmount] on [site-date], and have been granted the [changedRoles] role. Thank you! Sincerely, Site Admin</p>\r\n', '[customerName], your Membership has ended', '<p>\r\n Dear [customerName] , Your [planName] membership has expired or been cancelled. The [changedRoles] role has been removed. To renew your membership, please click the following link: [renewLink] Sincerely, Site Admin</p>\r\n', 'Membership Cancelled', '<p>\r\n Dear [customerName] , Your [planName] membership has been cancelled and will not automatically renew anymore. The [changedRoles] role will be removed at the end of the term. Sincerely, Site Admin</p>\r\n', 'Membership Modified', '<p>\r\n Dear [customerName] , Your membership has been successfully modified. Sincerely, Site Admin</p>\r\n', '[customerName], your Membership is Expiring Soon!', '<p>\r\n Dear [customerName] , Your [planName] membership will expire on [expirationDate]. To renew your membership, click the following link: [renewLink] Sincerely, Site Admin</p>\r\n', 0, 'a:1:{i:6;s:1:\"6\";}', 'a:0:{}', 'a:1:{i:0;s:1:\"0\";}', 'a:1:{i:6;s:1:\"6\";}', 4, 'a:7:{i:1;i:0;i:2;i:0;i:4;i:0;i:5;i:0;i:3;i:0;i:6;i:0;i:7;i:0;}', '', 'subscr_eot', 1, 0, 'a:1:{s:17:\"override_settings\";a:2:{s:13:\"ms_paypal_wps\";a:2:{s:8:\"override\";i:1;s:8:\"settings\";a:2:{s:4:\"main\";a:2:{s:19:\"ms_paypal_wps_email\";s:40:\"info@national-photographic-society.co.uk\";s:25:\"ms_paypal_wps_use_sandbox\";b:0;}s:8:\"advanced\";a:4:{s:27:\"ms_paypal_wps_cancel_return\";N;s:24:\"ms_paypal_wps_page_style\";s:0:\"\";s:17:\"ms_paypal_wps_sra\";s:1:\"0\";s:25:\"ms_paypal_wps_no_shipping\";s:1:\"1\";}}}s:13:\"ms_affiliates\";a:1:{s:8:\"settings\";a:1:{s:4:\"main\";a:1:{s:32:\"ms_affiliates_payout_percentages\";s:0:\"\";}}}}}') in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 619.
user warning: Duplicate entry '4' for key 'PRIMARY' query: INSERT INTO ms_membership_plans (mpid, name, description, main_amount, main_length, main_unit, trial_amount, trial_length, trial_unit, recurring, total_occurrences, signup_mail_subject, signup_mail_body, eot_mail_subject, eot_mail_body, cancel_mail_subject, cancel_mail_body, modify_mail_subject, modify_mail_body, expiring_mail_subject, expiring_mail_body, expiring_mail_days, start_grant_roles, start_remove_roles, expire_grant_roles, expire_remove_roles, weight, allow_roles, register_urls, expire_when, show_registration, show_account, data) VALUES (4, 'ANPS', 'Upgrade to Associate from Standard user/Licenciate or transfer from SWPP or MPA Associate - £39.95', 39.95, 0, '', 0.00, 0, '', 0, 0, 'Thank you for Signing Up, [customerName]!', 'Dear [customerName] ,\r\nYou have purchased the [planName] membership for [paymentAmount] on [site-date], and have been granted the [changedRoles] role. Thank you!\r\n\r\nSincerely,\r\nSite Admin', '[customerName], your Membership has ended', 'Dear [customerName] ,\r\nYour [planName] membership has expired or been cancelled. The [changedRoles] role has been removed.\r\nTo renew your membership, please click the following link: [renewLink]\r\n\r\nSincerely,\r\nSite Admin', 'Membership Cancelled', 'Dear [customerName] ,\r\nYour [planName] membership has been cancelled and will not automatically renew anymore. The [changedRoles] role will be removed at the end of the term.\r\n\r\nSincerely,\r\nSite Admin', 'Membership Modified', 'Dear [customerName] ,\r\nYour membership has been successfully modified.\r\n\r\nSincerely,\r\nSite Admin', '[customerName], your Membership is Expiring Soon!', 'Dear [customerName] ,\r\nYour [planName] membership will expire on [expirationDate]. To renew your membership, click the following link: [renewLink]\r\n\r\nSincerely,\r\nSite Admin', 0, 'a:1:{i:4;s:1:\"4\";}', 'a:0:{}', 'a:1:{i:0;s:1:\"0\";}', 'a:1:{i:4;s:1:\"4\";}', 6, 'a:7:{i:3;i:3;i:6;i:6;i:1;i:0;i:2;i:0;i:4;i:0;i:5;i:0;i:7;i:0;}', '', 'subscr_eot', 0, 1, 'a:1:{s:17:\"override_settings\";a:2:{s:13:\"ms_paypal_wps\";a:2:{s:8:\"override\";i:1;s:8:\"settings\";a:2:{s:4:\"main\";a:2:{s:19:\"ms_paypal_wps_email\";s:40:\"info@national-photographic-society.co.uk\";s:25:\"ms_paypal_wps_use_sandbox\";b:0;}s:8:\"advanced\";a:4:{s:27:\"ms_paypal_wps_cancel_return\";N;s:24:\"ms_paypal_wps_page_style\";s:0:\"\";s:17:\"ms_paypal_wps_sra\";s:1:\"0\";s:25:\"ms_paypal_wps_no_shipping\";s:1:\"1\";}}}s:13:\"ms_affiliates\";a:1:{s:8:\"settings\";a:1:{s:4:\"main\";a:1:{s:32:\"ms_affiliates_payout_percentages\";s:0:\"\";}}}}}') in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 619.
user warning: Duplicate entry '5' for key 'PRIMARY' query: INSERT INTO ms_membership_plans (mpid, name, description, main_amount, main_length, main_unit, trial_amount, trial_length, trial_unit, recurring, total_occurrences, signup_mail_subject, signup_mail_body, eot_mail_subject, eot_mail_body, cancel_mail_subject, cancel_mail_body, modify_mail_subject, modify_mail_body, expiring_mail_subject, expiring_mail_body, expiring_mail_days, start_grant_roles, start_remove_roles, expire_grant_roles, expire_remove_roles, weight, allow_roles, register_urls, expire_when, show_registration, show_account, data) VALUES (5, 'FNPS', 'Upgrade to Fellowship from Standard user/Licenciate/Associate or transfer from SWPP or MPA Fellowship - £49.95', 49.95, 0, '', 0.00, 0, '', 0, 0, 'Thank you for Signing Up, [customerName]!', 'Dear [customerName] ,\r\nYou have purchased the [planName] membership for [paymentAmount] on [site-date], and have been granted the [changedRoles] role. Thank you!\r\n\r\nSincerely,\r\nSite Admin', '[customerName], your Membership has ended', 'Dear [customerName] ,\r\nYour [planName] membership has expired or been cancelled. The [changedRoles] role has been removed.\r\nTo renew your membership, please click the following link: [renewLink]\r\n\r\nSincerely,\r\nSite Admin', 'Membership Cancelled', 'Dear [customerName] ,\r\nYour [planName] membership has been cancelled and will not automatically renew anymore. The [changedRoles] role will be removed at the end of the term.\r\n\r\nSincerely,\r\nSite Admin', 'Membership Modified', 'Dear [customerName] ,\r\nYour membership has been successfully modified.\r\n\r\nSincerely,\r\nSite Admin', '[customerName], your Membership is Expiring Soon!', 'Dear [customerName] ,\r\nYour [planName] membership will expire on [expirationDate]. To renew your membership, click the following link: [renewLink]\r\n\r\nSincerely,\r\nSite Admin', 0, 'a:1:{i:5;s:1:\"5\";}', 'a:0:{}', 'a:1:{i:0;s:1:\"0\";}', 'a:1:{i:5;s:1:\"5\";}', 7, 'a:7:{i:4;i:4;i:3;i:3;i:6;i:6;i:1;i:0;i:2;i:0;i:5;i:0;i:7;i:0;}', '', 'subscr_eot', 0, 1, 'a:1:{s:17:\"override_settings\";a:2:{s:13:\"ms_paypal_wps\";a:2:{s:8:\"override\";i:1;s:8:\"settings\";a:2:{s:4:\"main\";a:2:{s:19:\"ms_paypal_wps_email\";s:40:\"info@national-photographic-society.co.uk\";s:25:\"ms_paypal_wps_use_sandbox\";b:0;}s:8:\"advanced\";a:4:{s:27:\"ms_paypal_wps_cancel_return\";N;s:24:\"ms_paypal_wps_page_style\";s:0:\"\";s:17:\"ms_paypal_wps_sra\";s:1:\"0\";s:25:\"ms_paypal_wps_no_shipping\";s:1:\"1\";}}}s:13:\"ms_affiliates\";a:1:{s:8:\"settings\";a:1:{s:4:\"main\";a:1:{s:32:\"ms_affiliates_payout_percentages\";s:0:\"\";}}}}}') in /usr/home/national/public_html/sites/all/modules/moneyscripts/ms_membership/ms_membership.install on line 619.
user warning: Duplicate column name 'modify_options' query: ALTER TABLE ms_membership_plans ADD `modify_options` TEXT DEFAULT NULL in /usr/home/national/public_html/includes/database.mysql-common.inc on line 298.
Successfully Imported 0 Membership Plans and 7 Memberships
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
ms_membership module
Update #6600
No queries
Update #6601
No queries
Update #6602
Failed: ALTER TABLE {ms_membership_plans} ADD `modify_options` TEXT DEFAULT NULL

Think it's ok now thanks.

I uploaded the new set of files, disabled all your modules and enabled core.

Then I enabled them including new gateway and ran update.

It all seems to be working ok, should I worry about renaming tables etc? Not to confident about modifying tables manually!

Rod