"No such field" when logging enabled

[aydun]

I had an older version of civicrm_stripe enabled and logging which was working. I upgraded to 4.7.2 and then got error "DB Error: no such field". The log shows Unknown column 'processor_id' in 'field list' when inserting into civicrm_stripe_customers.

processor_id does exist as a column in civicrm_stripe_customers but not in log_civicrm_stripe_customers. It is added as a new column in CRM_Stripe_Upgrader::upgrade_5001() but that does not handle the change to the logging tables.

(Note that columns are added in several upgrade_* functions and the issue applies more widely.)

This could be avoided either by also altering the log tables directly or disabling and re-enabling logging in the upgrader.

This can be resolved by disabling logging and re-enabling (Administer >> System Settings >> Misc)