Problems upgrading from 6.x-5.10 to 6.x-6.10

2 replies [Last post]
Tue, 07/06/2010 - 08:58
sharpshooter
Offline
Membership Suite
Pay to Publish
Affiliates Suite
File Downloads Suite
Bonus Pack
Pay Per View
Joined: 03/26/2010
Status: 
Answered

Hi,

Been having some trouble upgrading from 6.x-5.10 to 6.x-6.10 today.

I followed the upgrade for core modules, but kept getting this error when running update.php :-

  1. User warning: Table 'ms_membership_plans_old' already exists query: RENAME TABLE ms_membership_plans TO ms_membership_plans_old in _db_query() (line 141 of /httpdocs/includes/database.mysqli.inc).

The tables didn't exist before running the update. I restored the DB and repeated a couple of times, with the same result each time.

Has anyone else seen this?

‹ PayPal subscription - PayPal Sandbox Differences between manual and paid gateway membership assignment? ›
Top
Wed, 07/07/2010 - 09:35
#1
Leighton Whiting
Offline
Membership Suite
Pay to Publish
Affiliates Suite
File Downloads Suite
Bonus Pack
Pay Per View
Joined: 06/02/2009
Sharpshooter, Can you try

Sharpshooter,
Can you try looking in your database and seeing if you already have a table named ms_membership_plans_old? If you do, can you rename it to something else, then try the update again?

Sincerely,
Leighton Whiting

Top
Thu, 07/08/2010 - 04:43
#2
sharpshooter
Offline
Membership Suite
Pay to Publish
Affiliates Suite
File Downloads Suite
Bonus Pack
Pay Per View
Joined: 03/26/2010
Hi, I already tried that, but

Hi, I already tried that, but got the same error.

After a lot of trial and error, I got the updates to install if I commented out line #579 of ms_membership.install

  1. db_add_field($ret, 'ms_membership_plans', 'modify_options', array('type' => 'text', 'description' => 'Which plans can be changed to from this plan', 'serialize' => TRUE));

The install was failing at update_6602 saying that the modify_options field already existed.

I think it must have been created as part of update_6600, when drupal_install_schema('ms_membership'); was called.
Not sure if this is related http://drupal.org/node/150220

Thanks,
Derek.

Top

Twitter Feed