Author Topic: Error after upgrade to 1.9 (Read 1689 times)

markbaa · December 07, 2007, 12:54:54 am

Hi All

Just upgraded from.... 1.6 I think? To the latest, on Joomla. It mostly seemed to go ok, and things are mostly working as expected. However, going to CiviMember gives me:

"Database Error Code: Unknown column 'civicrm_membership.owner_membership_id' in 'field list', 1054"

And the section of PHP where that occurs.

I'm guessing there was a problem with one of the SQL upgrade scripts, but not sure where to start with that...? Any hints?

Mark

Piotr Szotkowski · December 07, 2007, 01:46:23 am

That column was added in the 1.6 → 1.7 upgrade:

Code: [Select]

shot@devielle:~/work/CiviCRM/svn/v1.9$ sgrep owner_membership_id sql/civicrm_upgradedb_v1.*
sql/civicrm_upgradedb_v1.6_v1.7_41.mysql:199:   ALTER TABLE civicrm_membership ADD owner_membership_id int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'Optional FK to Parent Membership.';
sql/civicrm_upgradedb_v1.6_v1.7_41.mysql:200:   ALTER TABLE civicrm_membership ADD INDEX index_owner_membership_id( owner_membership_id );

markbaa · December 07, 2007, 02:20:12 am

Ok, thanks.

I guess I need to run the 1.6 > 1.7 SQL upgrade script again. I assume that I will then need to re-run the others afterwards? Is that a safe assumption?

Of course I'll backup first, but any other things I should watch out for? Or should I be pretty safe just re-running those scripts?

Piotr Szotkowski · December 07, 2007, 04:15:03 am

It’d be best if you rolled back to the backup of your original database (1.6), then run the scripts in sequence and see whether that doesn’t throw any errors (and stop at first of them).

CiviCRM Community Forums (archive)

News:

Author Topic: Error after upgrade to 1.9 (Read 1689 times)

markbaa

Error after upgrade to 1.9

Piotr Szotkowski

Re: Error after upgrade to 1.9

markbaa

Re: Error after upgrade to 1.9

Piotr Szotkowski

Re: Error after upgrade to 1.9