Skip to Content.
Sympa Menu

comanage-users - [comanage-users] Schema fix for develop branch deployers

Subject: COmanage Users List

List archive

[comanage-users] Schema fix for develop branch deployers


Chronological Thread 
  • From: Benn Oshrin <>
  • To: "" <>,
  • Subject: [comanage-users] Schema fix for develop branch deployers
  • Date: Tue, 28 Nov 2017 22:48:42 -0500
  • Ironport-phdr: 9a23:VmynPxDr6F+QqMn8QzM7UyQJP3N1i/DPJgcQr6AfoPdwSPX7oMbcNUDSrc9gkEXOFd2CrakV26yO6+jJYi8p2d65qncMcZhBBVcuqP49uEgeOvODElDxN/XwbiY3T4xoXV5h+GynYwAOQJ6tL1LdrWev4jEMBx7xKRR6JvjvGo7Vks+7y/2+94fdbghMhzexe69+IAmrpgjNq8cahpdvJLwswRXTuHtIfOpWxWJsJV2Nmhv3+9m98p1+/SlOovwt78FPX7n0cKQ+VrxYES8pM3sp683xtBnMVhWA630BWWgLiBVIAgzF7BbnXpfttybxq+Rw1DWGMcDwULs5Xymp4aV2Rx/ykCoJNyM3/n/UhMJ+gq1Urw6uqRNkzo7IYoyYLuZycr/TcN4YQ2dKQ8ZfVzZGAoO5d4YCEvQOPeBer4LgvlUOthu+BROtBOPp1zRFgWT50rM80+QnFgHLxw0gH9QSsHvKttX1MrkdUfyrwKXS0zrMcu5W1C775YPVcR4huemBUaxsfcfS00UiEwHIgk+NpYHrIT+ZzPoBv3SY4uZ4SO6jl20qpxt/rzSz3MsglJTFipwPxlza+ih0woA4LsCiRkFhe96rCp5QujmaN4RoRsMiRHlluCY9yr0DuJ60Yi0Kx44mxx7bcvCIaYyF7gjsVOqLPDh4nmxqd6i6hxay9kig0fH8WtOo31ZNqypJitjMtnYT2BzP8sWLVOdx80S71TuL1Q3f8PxILE4qmabBNZIt3r09moIWsUvZHy/2nEv2jLWRdkUh4uWn8ProYrPgpp+bLIJ0iwf+MrgwlcylB+Q3LBQOU3aB9euiybLj4FX1QK9Wgf0ujqnZrJfaKNwHqa6+Bg9ayIAj5AywDzi4ydgXgGcILExedRKDjojpIE3OIOvmAfulglSslitryO7cPr3nHJrNMmbPnK3/crlg9k5W0BAzwsxH55JIFrEBJ+r+VVP2tNzdFBA5NRa7w+n5B9lky4MeQnyAArWCMK7JtV+I5/kvI/WXZIMLojr9Kv4l5+Lwgn8jn18SY7Wp0YUNZH+mA/tmPhbRXX25yNwGFG4MtwUzCfHxhUeZeT9Ve3uoWa8gvHc2BJ/sRdPIQYWkhrWO0WKmBZBMfUhHDEyBC3Hla9/CVvsRPmbaKchkmzoNWrXkR4I//RCoqALgzbd7dKzZ9jBLm4jk0Y1f6uvV3TYp9SZ1CYzJ2WyLSWZcn2UUSiUw0bwl50Fx1wHQguBDn/VEGIkLtLtyWQAgOMuEwg==

** If you are not running from the develop branch or feature-3.1 branch,
you can safely ignore this message. **

If you are running off the develop branch or feature-3.1 branch since
commit dc951511bc (July 28), you'll need to manually fix a foreign key
constraint, as the automatic schema migration will not correct this.
(You can run this now, or the next time you pull from origin.)

On postgres, the fix is

sql=> alter table cm_history_records drop constraint
cm_history_records_co_email_list_id_fkey;
sql=> alter table cm_history_records add constraint
cm_history_records_co_email_list_id_fkey foreign key (co_email_list_id)
references cm_co_email_lists(id);

It should be the same or similar on mysql.

It's unlikely anyone is actually affected by this error, as it is
related to the new (not yet complete) CO Email List functionality. But
if you don't fix this and start using that functionality later, you'll
have a hard time tracking any associated errors.

Thanks,

-Benn-


  • [comanage-users] Schema fix for develop branch deployers, Benn Oshrin, 11/29/2017

Archive powered by MHonArc 2.6.19.

Top of Page