Hi, On Tue, Mar 25, 2014 at 8:38 AM, Scott Kushner <skushner@mplmain.mtpl.org> wrote:
Does anyone know how to get around this? It seems that I'm stuck in a loop with the installer and cannot get out!
Any help would be appreciated.
It looks like some manual SQL would be called for, following the steps in the relevant database schema update. Specifically, since it looks like that the borrowernumber column is already present, probably from a previous run, you should try: [1] UPDATE patronimage LEFT JOIN borrowers USING ( cardnumber ) SET patronimage.borrowernumber = borrowers.borrowernumber; [2] ALTER TABLE patronimage DROP FOREIGN KEY patronimage_fk1; It's possible that this one may fail if no such foreign key with that name exists. If so, that's fine, you can continue on: [3] ALTER TABLE patronimage DROP PRIMARY KEY, ADD PRIMARY KEY( borrowernumber ); [4] ALTER TABLE patronimage DROP cardnumber; [5] ALTER TABLE patronimage ADD FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON DELETE CASCADE ON UPDATE CASCADE; If you get this far, the final step is to tell Koha that you've successfully installed that DB revision: UPDATE systempreferences SET value = '3.1300030' WHERE variable = 'Version'; After that, you should be able to proceed with the rest of the schema upgrade. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: gmc@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org